https://github.com/famousdraw

每天一条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

posted on 2021-10-28 11:12  红色MINI  阅读(31)  评论(0编辑  收藏  举报

导航