If a table is in set integrity pending state at the beginning of the copy operation, the data is not loaded into the target table.
如果在复制操作开始时表处于set integrity pending状态,那么数据不会装载到目标表中。
After the load operation completes, target schema tables are in set integrity pending state, and the ADMIN_COPY_SCHEMA procedure issues a set integrity statement to get the tables out of this state.
在装载操作完成之后,目标模式表处于set integrity pending状态,ADMIN_COPY_SCHEMA过程会执行一个set integrity语句使表脱离这种状态。
SET INTEGRITY statements are issued against both tables to take them out of their pending states.
对于这两个表,都发出SET integrity语句,以便使它们都脱离悬挂状态。
Because the table Spaces are already in backup pending state, the SET INTEGRITY statement fails.
因为表空间已经处于backuppending状态,所以SET integrity语句会失败。
After being created, the MQT is in check pending state (see Demystifying table and table space states), and cannot be queried until the SET INTEGRITY statement has been executed against it.
MQT被创建之后,便处于检查暂挂状态(请参阅DB 2基础:阐明表和表空间的状态),在对它执行SET integrity语句之前,不能查询它。
Step 3: Use SET INTEGRITY statement to bring an MQT out of check-pending state.
步骤3:使用SET integrity语句使MQT脱离check - pending状态。
Step 3: Use SET INTEGRITY statement to bring an MQT out of check-pending state.
步骤3:使用SET integrity语句使MQT脱离check - pending状态。
应用推荐