使用功能键选择分区。
用箭头键来选择分区。
使用功能键选择分区。
在选择分区键时，应该注意以下几点。
You should bear mind of the following considerations when choosing a partitioning key.
在这些情况下，建议您基于数据平衡选择分区键。
In such cases, it is recommended that you choose a partitioning key based on even data balancing.
此外，基于为数不多的sql语句选择分区键也不是一个好的做法。
In addition, it is not a good idea to select partitioning keys based on a handful of SQL statements.
在选择分区键时，可以画出一个数据模型，用来显示数据库内的这些表之间的关系。
When choosing partitioning keys, draw a data model that shows the relationships among the tables that are in your database.
这个数据模型以及表间的业务关系可以提供一种比sql语句更为稳定的选择分区键的方式。
The data model and the business relationship between tables can provide a more stable way of selecting a partitioning key than specific SQL statements.
要启用优化器以选择分区内并行性，您必须按如下所示设置分区内并行的数据库管理器配置参数。
To enable the optimizer to choose the intra-partition parallelism you must set the intra_parallel database manager configuration parameter as shown here.
在下一屏幕中，您可以选择分区工具，可以是Autopartition或Disk Druid，如图6所示。
On the next screen, you can select a partition tool from Autopartition or Disk Druid, as shown in Figure 6.
这个号码将用于作为分区映射的一个索引，以选择那一行所在的数据库分区。
That number is used as an index into the partitioning map to select the database partition for that row.
此外，一个物理磁盘只能拥有八个物理分区，因此用户在安装系统之前，必须为每个分区选择正确的大小。
Additionally, a physical disk could only have eight physical partitions, so the customer had to select the correct size of each partition before installing the system.
这提供了几个好处，包括添加或删除分区时的性能提升和在分区级别执行选择维护操作的能力。
This provides several benefits, including improved performance when adding or removing partitions and the ability to perform select maintenance operations at the partition level.
这使您能选择足够多的分区数量，以便每个服务器节点都能稳定地处理每个分区上的负载。
This enables you to choose a large enough number of partitions such that each server node can readily handle the load on each partition.
随即出现的显示允许管理者选择连接到哪个分区。
The resulting display allows the operator to select which partition to attach to.
在这种环境下，应该查看数据模型来决定分区键的最佳选择。
In this kind of environment, you should examine your data model to determine the best choice for partitioning keys.
在操作系统启动时，系统管理员选择用来启动分区的配置文件。
At operating system boot time, the system administrator selects which profile a partition is booted with.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
These recommendations address the database schema, the choice between XML and relational storage, definition of indexes, and physical data organization with partitioning and clustering options.
在激活共享内存分区时，会自动地选择合适的分页空间设备。
When a shared memory partition is activated, a suitable paging space device will automatically be selected.
当你选择安装类型时，一定要选择自定义(高级)并且选择之前你创建的那个分区。
When you're choosing installation type, be sure to select Custom (advanced) and choose the partition you set up above.
对于TP，设计决定包括选择用作表分区键的列和分区的数量。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
与以前的DB 2版本一样，一定要通过选择分布键跨分区均匀地分布行。
As with earlier releases of DB2, it is important to select a distribution key that evenly distributes rows across partitions.
在某些情况下，您可能会发现根据并置和数据平衡选择恰当的分区键的准则会相互矛盾。
In some cases, you might find that guidelines for choosing the proper partitioning key based on collocation and data balancing contradict one another.
此外，我们没有过多讨论的一个优点是，您现在可以选择将磁盘存储分区迁移到成本更低的存储器中。
In addition, one advantage we have not given much discussion here is the option you now have to move portions of your disk storage to lower-cost options.
本文提供了如何根据您自己的需要选择最佳分区键的指导和工具。
This article provided guidance and tooling for choosing the best partitioning keys based on your needs.
选择适当的分区键对于优化基于DB 2软件的分区环境中的数据库性能非常关键。
Choosing appropriate partitioning keys is essential for optimizing database performance in a partitioned environment based on DB2 software.
在创建或更新共享内存分区概要文件时，可以在内存配置部分中找到选择分页VIOS分区的选项。
When creating or updating Shared memory partitions profiles you can find the option to select the paging VIOS partitions in the memory configuration section.
通过选择相应的逻辑分区配置文件，它可以帮助启动、停止和重新设置一个分区。
It facilitates start, stop, and reset of a partition by selecting the corresponding logical partition profile.
如果基于查询工作负载选择一个分区键，那么此分区键通常应该包含一个合并列或常被用于很多查询的一组列。
If you choose a partitioning key based on your query workload, the partitioning key should typically consist of either a joined column or a set of columns that is frequently used in many queries.
对于分区索引，建议选择不大可能改变的键列。
For partitioning indexes, it is recommended that you choose key columns that are unlikely to be changed.
应用推荐