db2 reorg
上一篇 /
下一篇 2011-02-21 14:19:28
/ 个人分类:db2
1.reorgchk update statistics on table all
2.(1) reorg table
reorg table maximo.po use tempspace1
(2) reorg index all
reorg indexes all for table maximo.po use tempace1
(3) reorg tale with one index
reorg table maximo.po index index1 use tempace1
3.runstats
runstats on table maximo.po with distribution and detailed indexes all
4.reorgchk
P.S.(1)Pause reorg:
db2 reorg table schema.table inplace pause
(2) resume reorg
db2 reorg table schema.table inplace resume
List all tablesdb2 SELECT 'REORG TABLE', CONCAT(RTRIM(SUBSTR(TABSCHEMA,1,15)),CONCAT('.',RTRIM(SUBSTR(TABNAME,1,32)))), ';' FROM SYSCAT.TABLES WHERE TYPE = 'T'
收藏
举报
TAG: