db2 reorg,runstats

db2 -x "select 'reorgchk update statistics on table ' || rtrim(tabschema)||'.'||rtrim(tabname) || ';' from syscat.tables where type = 'T' " > reorgchk.sql
db2 -x "select 'reorgchk current statistics on table ' || rtrim(tabschema)||'.'||rtrim(tabname) || ';' from syscat.tables where type = 'T' " > reorgchk.sql
db2 -tvf reorgchk.out

db2 -x "select 'runstats on table ' || rtrim(tabschema)||'.'||rtrim(tabname) || ' on all columns with distribution on all columns and indexes all allow write access;'from syscat.tables where type = 'T' " > runstats.sql
db2 -tvf runstats.sql

db2 -x "select 'rebind package ' || trim(PKGSCHEMA) || '.' || trim(PKGNAME) || ';'  from syscat.packages" > rebind.sql
db2 -tvf rebind.sql


db2 reorgchk current statistics on table all

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/725820/viewspace-2217912/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/725820/viewspace-2217912/