db2 "select varchar(tabschema,15) as tabschema,varchar(tabname,40) as tabname, varchar(VOLATILE,5) AS VOLATILE FROM SYSCAT.TABLES WHERE VOLATILE = 'C'" | tee -a /tmp/VOLATILE_table.out
db2 alter table DB2INST1.T1 volatile
db2 "runstats on table DB2INST1.T1 with distribution and index all"
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
http://www.cndba.cn/hbhe0316/article/107923
版权声明：本文为博主原创文章，未经博主允许不得转载。
DB2
CNDBA社区
