对于分区数据库系统，在每台参与分区数据库的计算机上都应该有一个单独的数据库文件系统。
For partitioned database systems, there should be a separate database file system on each machine that participates in the partitioned database.
数据被划分到一个数据库分区组中的所有分区上，可以为数据库分区组添加一个或多个数据库分区，或者从中去掉数据库分区。
Data is divided across all the partitions in a database partition group and you can add or drop one or more database partitions from a database partition group.
为此，可以将用户表放在不包括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.
使用分区表的另一个优点是，可以轻松地在表中添加新数据(作为新的数据分区)，同时可以轻松地删除并存档老数据。
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.
在分区数据库环境中，每个数据库可以在一个不同的数据库分区服务器上有它的编目分区。
Each database in a partitioned database environment can have its catalog partition on a different database partition server.
每个数据库分区上的数据库管理器使用每个系统上的处理器来管理数据库中属于该分区的那部分数据。
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.
对于单分区数据库，您可以对数据库分区号仅指定- 1(当前分区)或- 2(所有分区)，结果是一样的。
For a single partition database, you can just specify -1 (current partition) or -2 (all partitions) for the database partition number and the results will be the same.
通过分别定义包含历史数据和当前月份数据的数据库视图，您可以根据时间对数据进行分区。
You can partition data based on time by defining database views that contain historic data and the current month data respectively.
在分区数据库环境中，数据库管理器必须有方法知道表的哪些行存储在哪个数据库分区上，以便发现它需要的数据。
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.
清单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.
如果表分区不在该数据库分区上，那么将请求发送给数据库分区组中持有该表分区的第一个数据库分区。
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.
第三，不能使用该工具改变和数据库分区有关的分区号，比方说，不能将数据库分区10改为数据库分区20。
Third, you cannot use the tool to change the partition number associated with a database partition. For example, you cannot change database partition 10 to be database partition 20.
Ceph开发了一些非常有趣的概念(例如，动态元数据分区，数据分布和复制)，这些概念在本文中只进行简短地探讨。
Ceph has developed some very interesting concepts (such as dynamic metadata partitioning and data distribution and replication), which this article explores shortly.
因此，每个分区都将数据发送到所有其他分区，同时留有部分数据。
Therefore, each partition is sending data to all other partitions, while leaving some data behind.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
从最佳实践的角度来看，各个数据库分区上的表数据倾斜应该不多于10%。
From the best practices perspective, the table data skew on every individual database partition should be no more than 10%.
如果不需要特别考虑并置，那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
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.
通过DPF可以更快速地添加数据，因为每个数据库分区可以并行工作。
DPF enables data to be added more quickly because each database partition can process the work in parallel.
当一个数据库由两个或更多数据库分区组成，并且每个数据库分区存储位于其中的每个表的一部分表数据时，就属于数据库分区的情况。
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.
在这种类型的数据库中，数据被根据存储位置进行散列，以标识哪个数据库分区将存储数据。
Within this type of database, data is hashed for storage location, to identify which database partition will store the data.
一个数据库分区由它自己的数据、索引、配置文件和事务逻辑组成。
A database partition consists of its own data, indexes, configuration files, and transaction logs.
它的优点和上节类似：紧凑数据表、跨三个具体子类的数据分区以及对子类任意数据的修改都只涉及一张表。
The pros are similar to the above section: compact tables, data partitions across three concrete subclass tables, and any data change on a subclass only involves one table.
一种常见的设计是为每个月的数据创建一个数据分区。
A common design would be to create a data partition for each month's data.
就像城市地图按网格分成一些区一样，数据库管理器使用分区键来确定数据所存储在的位置(数据库分区)。
Just as a city map is organized into sections using a grid, the database manager USES a partitioning key to determine the location (the database partition) where the data is stored.
用户可以通过使用数据库分区组和表空间，来确定将表数据分布到哪些数据库分区上。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
此外，通过跨多个数据库分区分散数据以使多个分区可并行处理分配到其上的数据，也能减少复杂的分析查询的响应时间。
Also, the response time of complex analytical queries can be reduced by spreading the data across multiple database partitions, such that all partitions work on their assigned data in parallel.
为了解决有问题的事务，一个数据分区可能需要与另一个数据分区联系。
In order to resolve an in doubt transaction, a data partition may need to contact another data partition.
于是DB 2就可以在存储数据的数据库分区上执行连接或子查询，而不必在数据库分区之间移动数据。
DB2 can then choose to perform the join or subquery at the database partition where the data is stored, instead of having to move data between database partitions.
在分区数据库环境中，执行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.
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
应用推荐