Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.