In this common situation, an empty partition needs to be added to the table before the start of a month and data is added each day of the month.
在这种情况下，在一个月开始之前，即这个月还没有开始每天添加数据之前，需要为这个表添加一个空白的分区。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
此外，只有当物理表数据对象或分区中没有压缩字典时，才能运行adc。
From the best practices perspective, the table data skew on every individual database partition should be no more than 10%.
从最佳实践的角度来看，各个数据库分区上的表数据倾斜应该不多于10%。
DB2 provides the capability to compress the data in a table space or partition.
DB 2提供了压缩一个表空间或分区中的数据的能力。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
使用分区表的另一个优点是，可以轻松地在表中添加新数据(作为新的数据分区)，同时可以轻松地删除并存档老数据。
The index partition for each data partition can be in a different table space.
每个数据分区的索引分区可以位于不同的表空间中。
In a partitioned database environment, the database manager must have a way of knowing which table rows are stored on which database partition, so that it can find the data it needs.
在分区数据库环境中，数据库管理器必须有方法知道表的哪些行存储在哪个数据库分区上，以便发现它需要的数据。
Patterns in the data: the frequency of recurring patterns in the data determines how effective compression will be for a particular table space or partition.
数据中的模式：对于特定的表空间或分区，数据中重复出现的模式的出现频率将决定压缩的效果。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
用户可以通过使用数据库分区组和表空间，来确定将表数据分布到哪些数据库分区上。
Database partitioning occurs when a database consists of two or more database partitions, where each database partition stores a subset of table data for each table that resides within it.
当一个数据库由两个或更多数据库分区组成，并且每个数据库分区存储位于其中的每个表的一部分表数据时，就属于数据库分区的情况。
For example, a table that has monthly rollout would have a partition for each month of data.
例如，每月转出数据的表，对于每个月的数据都有一个分区。
Partition the table space as evenly as possible, because the degree of parallelism is influenced by skews in the data.
尽可能均匀地对表空间分区，因为数据不整齐会对并行度产生影响。
By default, the XML data goes in the same table space as the corresponding data partition.
默认情况下，XML数据存储到与其相应数据分区相同的表空间当中。
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数据的范围分区表，滚出(分离)包含老数据的分区，滚入(附加)包含最近数据的分区。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
A data partition, also referred to as a range (currently DB2 supports only a range partitioning scheme), contains a subset of rows that are stored separately from other sets of rows in the table.
数据分区也称为范围(当前DB 2只支持范围分区方案)，一个数据分区包含一个行子集，这些行存储在与表中其他行集不同的地方。
If collocation is not a major consideration, a good partitioning key for a table is one that spreads the data evenly across all database partitions in the database partition group.
如果不需要特别考虑并置，那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
Each of the objects would correspond to a 'partition' and would allow each table space to contain a range of data which can be accessed very easily.
每个对象对应于一个“分区”，允许每个表空间包含一定范围的数据，这样非常容易访问。
The data partition being attached has indexes in a separate table space from the data.
附加的数据分区具有与其数据处于不同表空间中的索引。
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
因此，REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
The table space placement for XML data is determined by the LONG in clause, which can be specified at partition level, table level, or any combination thereof.
XML数据的表空间位置由LONGin子句决定，其可在分区级别、表级别、或它们的任何组合中指定。
The PDGP partition group spans the data nodes, which is where the table Spaces are placed.
PDGP分区组跨越数据节点，这是表空间所在的位置。
Limited partition scan is a method that allows DB2 to limit the scan of data in a partitioned table space.
限定分区扫描允许DB 2将数据扫描限制在一个分区表空间中。
The IPL interrogates the partition table and subsequently is able to load data wherever it may exist on the various media.
IPL查询分区表，从而能够加载位于不同介质上任意位置的数据。
The latest GParted 0.8, released a couple of days ago, adds an option to rescue data from lost partitions: "This new feature uses the gpart command to guess the partition table.
前不久发布了最新版GParted0.8，使大众在修复受损分区数据时，又多了一个选择：“这项新特征运用了gpart软件命令推测分区表信息。
Recall our sample table (Transactions history table) has a separate partition for each month, yet we are adding data one or more times per day.
还记得吗，我们的示例表(Transactions历史表)对于每个月都有一个单独的分区，而我们是每天添加一次或多次数据。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
TSName: Identifies the table space in which each data partition is to be stored.
TSName：指定存储每个数据分区的表空间。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
RANGE/TABLE PARTITIONING（DB29提供） ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
The behavior of runstats is such that it will use the data on the partition that it is run from to extrapolate the number of rows in the table.
runstats的行为使其将使用运行它的分区上的数据来推测该表中的行数。
应用推荐