第1个回答 2013-12-30
这个叫重构,不是重建
要学会DB2的帮助,
在db2cmd 中输入db2 ? REORG
reorg的完整语法就会出来
REORG {TABLE table-name Table-Clause | {INDEXES ALL FOR TABLE table-name |
INDEX index-name [FOR TABLE table-name]} Index-Clause |
TABLE mdc-table-name RECLAIM EXTENTS ONLY Reclaim-Extents-Clause}
[Table-Partition-Clause] [On-DbPartitionNum-Clause]
Table-Clause:
[INDEX index-name] [[ALLOW {READ | NO} ACCESS]
[USE tablespace-name] [INDEXSCAN] [LONGLOBDATA [USE long-tablespace-name]]
[KEEPDICTIONARY | RESETDICTIONARY]] |
[INPLACE [ [ALLOW {WRITE | READ} ACCESS] [NOTRUNCATE TABLE]
[START | RESUME] | {STOP | PAUSE} ]]
Index-Clause:
[ALLOW {READ | NO | WRITE} ACCESS]
[{CLEANUP ONLY [ALL | PAGES] | CONVERT}]
Reclaim-Extents-Clause:
[ALLOW {WRITE | READ | NO} ACCESS]
Table-Partition-Clause:
ON DATA PARTITION partition-name
On-DbPartitionNum-Clause:
ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number
[TO db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number
[TO db-partition-number] , ...)]}