图3说明了给定分区的数据库对象之间的关系。
Figure 3. DB2 object-relationship diagram for a given database partition.
ee -用于带有单个分区的数据库。
转换到ext4或者ext3没有任何分区的数据丢失。
Convert any of your partitions to EXT4 or EXT3 without data loss.
收集所有分区的数据可能没有意义，尤其是在分区数量很大的情况下。
It just doesn't make sense to collect data on all partitions, especially if you have many of them.
非dos分区的数据将全部丢失。你准备删除哪一个非dos分区？
Data in the deleted Non-DOS partition will be lost. What Non-DOS partition do you want to delete?
该命令的输出会展示出每个分区的数据和索引统计信息，并针对需要重组的分区提供建议。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
为此，可以将用户表放在不包括IBMCATGROUP数据库分区组中的数据库分区的数据库分区组中。
This is accomplished by placing user tables in database partition groups that do not include the database partition in the IBMCATGROUP database partition group.
RUNSTATS不是在分区的数据库中并行运行的，但对一个分区确定信息，然后对所有分区推断出合适的估计值。
RUNSTATS does not run in parallel in a partitioned database, but information is determined for one partition, and then extrapolated to determine a suitable estimate for all partitions.
取决于数据库分区的数量，您可以有一个或多个单分区的数据库分区组，以及一个或多个多分区的数据库分区组。
Depending on the number of database partitions, you may have one or more single-partition database partition groups, and one or more multi-partition database partition groups.
在分区数据库环境中，执行LOAD_ONLY操作期间，分区头用于验证该文件是否只包含属于特定数据库分区的数据。
In a partitioned database environment, during a LOAD_ONLY operation, partition headers are used to verify that the file only contains data belonging to a specific database partition.
分区映射是内部生成的数组，对于多分区的数据库分区组，这个数组包含4,096个条目，对于单分区的数据库分区组，这个数组只包含一个条目。
A partitioning map is an internally generated array containing either 4,096 entries for multiple-partition database partition groups, or a single entry for single-partition database partition groups.
如果所有分区都处于他们都在发送和接收数据的combo状态，那么统计信息就不能被收集。
If all partitions are in a combo state where they are both sending and receiving data, then statistics cannot be collected.
全局视图显示所有分区的聚合数据。
The global view displays aggregated data from all partitions.
从最佳实践的角度来看，各个数据库分区上的表数据倾斜应该不多于10%。
From the best practices perspective, the table data skew on every individual database partition should be no more than 10%.
因此，REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
如何从无法撤销配置的磁盘恢复服务器，或者取出无法移出这个磁盘的物理分区中的数据？
How could I recover a server from a disk that could not be deconfigured or have the data from a failed physical partition moved off of it?
建议使用单独的分区来存储缓存的数据。
It is recommended to use a separate partition for storing the cached data.
新例程用来评估已有的和新的分区键的数据倾斜。
New routines to estimate data skews for existing and new partitioning keys.
每个索引分区仅从相应的数据分区取得索引行。
Each index partition indexes rows only from the corresponding data partition.
表数据倾斜指的是特定的一些数据库分区上的某个表内的记录数与这个表所跨的所有数据库分区的平均记录数之间的差额。
Table data skew refers to a difference between the number of records in a table on particular database partitions and the average number of records across all database partitions for this table.
首先，每个分区都有自己的元数据子集。
DB 2提供了压缩一个表空间或分区中的数据的能力。
DB2 provides the capability to compress the data in a table space or partition.
创建一个数据库分区组来指定要参加分区的那些数据库分区。
Create a database partition group that specifies the database partitions that will participate in the partitioning.
每个数据库分区上的数据库管理器使用每个系统上的处理器来管理数据库中属于该分区的那部分数据。
The processors on each system are used by the database manager at each database partition to manage its own part of the total data in the database.
在任何时候重新在硬盘上分区，都会有破坏原有分区数据的危险性。
Any time you repartition your hard drive, you run the risk of destroying the data on the original partitions.
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
Q: Can the local index partition and data partition be in the same table space for each partition?
可以从产生的不连续分区聚合作业的输出数据。
The output data of the job can be aggregated from discrete partitions of results.
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
清单3创建一个包含关系和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.
将工作分区与它们的数据分区进行匹配，这将增加服务器缓存的命中概率，并减少对数据库的远程访问，后者会引起较大的延迟。
Matching work partitions to their data partitions will increase the probability of a cache hit within the server and decrease remote accesses to the database, which introduces quite a bit of latency.
应用推荐