If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
When you create a range-partitioned table in DB2 z/OS, the underlying table space is also partitioned and such a partitioned table space can not hold more than one table.
在DB2z/OS 中创建一个范围分区的表时,底层的表空间也被分区,并且这样一个分区的表空间无法容纳多个表。
If database partitioning and range partitioning are used together, the rows in a table are first hashed across the database partitions and then range-partitioned within each database partition.
如果数据库分区和范围分区一同使用,那么表内的行首先会跨数据库分区做散列处理,然后再在每个数据库分区中执行范围分区。
Listing 3 creates a range-partitioned table with relational and XML data, rolls out (detaches) a partition containing old data, and rolls in (attaches) a partition containing recent data.
清单3创建一个包含关系和XML数据的范围分区表,滚出(分离)包含老数据的分区,滚入(附加)包含最近数据的分区。
Managing a range-partitioned table that includes one or more XML columns isn't much different from managing a range-partitioned table with only relational columns.
与管理只包含关系列的范围分区表相比,管理包含一个或多个XML 列的范围分区表的差异并不大。
Managing a range-partitioned table that includes one or more XML columns isn't much different from managing a range-partitioned table with only relational columns.
与管理只包含关系列的范围分区表相比,管理包含一个或多个XML 列的范围分区表的差异并不大。
应用推荐