下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
正如可以向分区表添加或附加新分区一样，也可以删除现有分区。
Just as you can add or attach new partitions to a partitioned table, you can also remove existing partitions.
如果您被通知需要重新引导系统以确保分区表被更新，那么请在继续下面的步骤之前重新引导系统。
If you get the message that you need to reboot your system to ensure that the partition table is updated, then please reboot your system now before continuing.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
DB 210现在支持自动重新组织分区表空间的不相连分区范围。
DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.
MBR是磁盘上的第一个扇区，因而分区表在其中所占空间不大。
The MBR is the first sector on the disk, so the partition table is not a very large part of it.
限定分区扫描允许DB 2将数据扫描限制在一个分区表空间中。
Limited partition scan is a method that allows DB2 to limit the scan of data in a partitioned table space.
IPL查询分区表，从而能够加载位于不同介质上任意位置的数据。
The IPL interrogates the partition table and subsequently is able to load data wherever it may exist on the various media.
您可以使用“p”来显示当前的分区表。
可以随时按下“p ”预览新的分区表。
TableName：按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
TableName：通过名称标识将添加新分区的分区表。
TableName: Identifies the partitioned table, by name, that a new partition is to be added to.
它是通过在分区表中查找一个活动分区来实现这种功能的。
It does this by looking through the partition table for an active partition.
当找到一个活动分区时，它会扫描分区表中的其他分区，以确保它们都不是活动的。
When it finds an active partition, it scans the remaining partitions in the table to ensure that they're all inactive.
那意味着，无论何时添加或删除分区，都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
源表必须是非分区表，或者是只拥有一个分区且没有已附加或已分离的分区的分区表。
The source table must be a nonpartitioned table or a partitioned table that has only one partition and no attached or detached partitions.
GPT将所有分区存储在单个分区表中(带有备份)，因此扩展分区或逻辑分区没有存在的必要。
GPT stores all partitions in a single partition table (with backup), so there's no need for extended or logical partitions.
支持临时表、常规表以及范围和列表类型的分区表。
Supports temporary, regular and partitioned tables of different types of range and list.
磁盘错误、管理员的失误和其他问题可能会破坏关键的磁盘结构(比如分区表)，从而影响一个磁盘上的所有卷。
Disk errors, administrator mistakes, and other problems can affect all the volumes on a disk by wiping out critical disk structures, such as the partition table.
Q：如何计算已分区表（或者任何相关的表）的表大小和索引大小？
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
FAT32也改进了传统的FAT引导区和分区表，使得与其他一些启动管理器不兼容。
FAT32 also modifies the traditional FAT boot sector and allocation table, making it incompatible with some boot managers.
注意，分区表的每个分区可以有不同的压缩词典，在DPF中一个表的每个分区也可以有不同的压缩词典。
Note that each partition of a partitioned table can have a different compression dictionaries and each partition of a table in DPF can have a different compression dictionaries.
如果sql表是一个分区表，每个分区(成员)都可以有一个单独的媒介首选项。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
支持用户表、临时表、常规表以及范围、哈希和多维簇类型的分区表。
Supports user, temporary, regular and partitioned tables of different types range, hash and multidimensional clusters.
理想情况下，一个哈希分区表内的每个数据库分区都应具有相同数量的记录。
Ideally, each database partition in a hash-partitioned table should hold the same number of records.
不支持哈希分区表。
如果表是一个范围集群表(不支持行压缩)，可以考虑将其变换为范围分区表(支持行压缩)。
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).
分区表空间：分区表空间只能包含一个表。
Partitioned: A partitioned table space may contain only a single table.
执行这样一个语句时，一个新表将创建，并在逻辑上构成分区表的一部分。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
执行这样一个语句时，一个新表将创建，并在逻辑上构成分区表的一部分。
When such a statement is executed, a new table is created and logically made a part of the partitioned table.
应用推荐