IBM TSOM USES range partitioning for event tables, so you can detach a partition, archive the detached partition on an external storage, or drop the detached partition.
IBMTSOM使用范围分区实现事件表，所以您可以分离一个分区，将分离的分区保存在一个外部存储上，或者删除所分离的分区。
Starting in DB2 9.7.1, the detach operation is made online by allowing a partition to be detached while queries are concurrently accessing the remaining partitions of the table.
自db29.7.1起，允许在分离分区的同时，可以对表中剩下的分区进行查询访问，从而实现了在线DETACH操作。
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
当不存在依赖的物化查询表(MQT)时，系统在完成第一阶段(ALTERTABLEDETACH PARTITION)的提交后，启动第二阶段。
When there are no dependent materialized query tables (MQT), the system initiates the second phase after the first phase (ALTER table DETACH PARTITION) commits.
当不存在依赖的物化查询表(MQT)时，系统在完成第一阶段(ALTERTABLEDETACH PARTITION)的提交后，启动第二阶段。
应用推荐