每天一条DB2命令-024

每天一条DB2命令-024
#全库runstats
db2 -x "select 'runstats on table ' ||trim(tabschema)||'.'|| trim(tabname)||' with distribution and detailed indexes all;'from syscat.tables where tabschema not like 'SYS%' and TYPE = 'T' order by tabschema,tabname" > runstats.sql
db2 -tvf runstats.sql