DB2数据库中有一张分区表(包含主键索引和部分分区索引),在对某个分区做reorg时,其它分区是否可以select或者update? reorg的语句,如:db2 "reorg table wf_h_activityinst on datapartition P201701"
收起信息中心查到如下描述,分区表包含全局索引的情况下,对单个分区reorg也是allow no access模式。
When the ON DATA PARTITION clause is specified for a table reorganization of a data partitioned table, only the specified data partition is reorganized:
If there are no nonpartitioned indexes (except system-generated XML path indexes)defined on the table, the access mode applies only to the specified partition,users are allowed to read from and write to the other partitions of the table.
If there are nonpartitioned indexes defined on the table (excluding system-generated XML path indexes), the ALLOW NO ACCESS mode is the default and only supported access mode. In this case, the table is placed in ALLOW NO ACCESS mode. If ALLOW READ ACCESS is specified, SQL1548N is returned (SQLSTATE 5U047).