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.
IBM TSOM使用范围分区实现事件表,所以您可以分离一个分区,将分离的分区保存在一个外部存储上,或者删除所分离的分区。
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.
自db2 9.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)时,系统在完成第一阶段(ALTER TABLE DETACH PARTITION)的提交后,启动第二阶段。
应用推荐