DB 2 9.7表分区增强。
该定义中使用的列被称为表分区键列。
The columns used in this definition are referred to as the table partitioning key columns.
表分区特性提供以下收益。
它可以用于压缩整个表、表分区和物化视图。
It can be used to compress entire tables, table partitions, and materialized views.
in - placealter不会改变表分区号。
An in-place alter does not change the table partition Numbers.
TP支持按照一个维将一个表分区成多个数据分区。
TP supports partitioning a table into data partitions along a single dimension.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
You can store data in different partitions in the same table of a database using table partitioning.
对于TP，设计决定包括选择用作表分区键的列和分区的数量。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
本部分讨论关于表分区的一些不明显的观察值，以及一些常见的问题。
This section discusses some observations about table partitioning that might not be very obvious and some things that we frequently get questions on.
指定的列组成表的分区键 —参见边栏 “选择表分区键”。
The group of columns specified make up the partitioning key for the table —see sidebar, "Choosing a table partitioning key."
增加下列结构的有效性：索引或索引分区，表或表分区，索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
MTK现在提供对转换Oracle范围分区(也称表分区)的支持。
MTK now provides support for translating Oracle range partitioning (also known as table partitioning).
一个列是否被用作MD c维对于是否应该将它作为表分区键没有影响，反之亦然。
Whether a column should be used as table partitioning key for TP is not affected by whether that column is also used an MDC dimension and vice versa.
尽管表分区就像是一个单独的表，但是一个分区理论上最大可以达到16TB。
Although, since table partitions are treated just like an individual table, a partition could theoretically grow to a maximum of 16tb.
本文介绍了以下DB2表设计特性：表分区、MDC、DPF和MQT。
This article introduced the following DB2 table design features: table partitioning, MDC, DPF, and MQT.
然而，由于xml列不属于表分区键的一部分，任何唯一xml值索引必须创建为全局索引。
However, since XML columns cannot be part of the table partitioning key, any unique XML values index will have to be created as a global index.
处理在将旧分区中的行转移到新表分区时因alter操作而生成的DML日志记录。
Process DML log records generated due to an alter operation while moving the rows from the old partition to the new table partition.
在我的上一期专栏中，我阐述了如何使用表分区，基于一列或多列中的值，跨多个存储对象组织数据。
In my last column, I explained how you can use table partitioning to organize data across multiple storage objects based on values in one or more columns.
如果表分区不在该数据库分区上，那么将请求发送给数据库分区组中持有该表分区的第一个数据库分区。
If a table partition does not exist on the database partition, the request is sent to the first database partition in the database partition group that holds a partition for that table.
重放位置的推进是必需的，因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
The replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
DB 2V 9引入了一个表分区特性，它能够增加一个表的可能大小，同时能够显著减少管理大型数据库所需要的维护。
DB2 V9 introduced a table partitioning feature that can increase the potential size of a single table, and significantly reduce the maintenance effort required to manage very large databases.
对于需要每月根据sale_date转出数据的数据库，一种典型的设计是使用sale_date作为表分区键，并为每个月创建一个单独的分区。
A typical design for a database with monthly roll-out based on sale_date, would be to use sale_date as the table partitioning key and create a separate partition for each month.
简介：RogerE. Sanders解释使用DB2forLinux,UNIX,andWindows 进行表分区的原因、地点、时间和方式，并展示 DB2 9.7 中的增强如何使分区过程更简单快速。
Summary: Roger E. Sanders explains why, where, when, and how to partition tables with DB2 for Linux, UNIX, and Windows—and shows how enhancements in DB2 9.7 make the process easier and faster.
对于被合并的表的分区键内的每列，必须存在一个同等连接的谓语。
For each column in the partitioning key of the joined tables, an equijoin predicate must exist.
下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
在与一个数据库分区组相关联的表空间中，每个表的分区键可以确定表是否是并置的。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
源表必须是非分区表，或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
DB 210现在支持自动重新组织分区表空间的不相连分区范围。
DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.
不支持哈希分区表。
全局分区页表由不同分区的pmb到lmb的映射组成。
The global partition page table consists of the mapping of PMBs to the LMBs of different partitions.
应用推荐