
DB2 重建索引的命令正确格式是什么?
reorgindexsT_HK_TRANSDTL_IDX1fortableT_HK_TRANSDTL;报104错误,T_HK_TRANSDTL_IDX1是我的索引名,T_...
reorg indexs T_HK_TRANSDTL_IDX1 for table T_HK_TRANSDTL ;报104错误,T_HK_TRANSDTL_IDX1 是我的索引名,T_HK_TRANSDTL 是表名,语法有错误?
展开
3个回答
展开全部
reorg是用来整理磁盘碎片的即重构表。DB2修改表结构后需要做reorg
以下两种方法都可以:
reorg table T_HK_TRANSDTL;
reorg table T_HK_TRANSDTL INDEX T_HK_TRANSDTL_IDX1 RESETDICTIONARY;这种是按照索引T_HK_TRANSDTL_IDX1重构表
,再执行一下runstats on table T_HK_TRANSDTL with distribution and index all;收集统计信息就可以了
以下两种方法都可以:
reorg table T_HK_TRANSDTL;
reorg table T_HK_TRANSDTL INDEX T_HK_TRANSDTL_IDX1 RESETDICTIONARY;这种是按照索引T_HK_TRANSDTL_IDX1重构表
,再执行一下runstats on table T_HK_TRANSDTL with distribution and index all;收集统计信息就可以了
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] , ...)]}
要学会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] , ...)]}
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
REORG INDEXES ALL FOR TABLE 表名 ALLOW READ ACCESS;
你indexs 写错了。
你indexs 写错了。
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询