If we issued the following statement on a two-partition database.
如果在一个由两个分区组成的数据库上发出以下语句。
The utility was tested in a single partition database on the following platforms.
该实用工具已经在下列平台的单个分区数据库中进行了测试。
The partition number is 0 in this case because we are dealing with a single-partition database.
在该例中,分区号是0,因为我们处理的是单分区数据库。
Scenario: You wish to change the name of this three partition database from PRODUCTS to OLDPROD.
场景:希望将这个三分区数据库的名称从 PRODUCTS 改为 OLDPROD。
Staging tables (not supported by the load utility in multiple partition database environments).
分段表(在多分区数据库环境中装载实用程序不支持这种表)。
Each subset that contains more than one database partition is known as a multi-partition database partition group.
每个包含不止一个数据库分区的子集称作多分区数据库分区组。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
The name of the report file is db2locktimeout.dbpartition.agentid.timestamp where dbpartition is always 0 for a single-partition database.
报告文件的名称为 db2locktimeout.dbpartition.agentid.timestamp,对于单分区的数据库,其中的 dbpartition始终为0。
Small tables should be placed in single-partition database partition groups, except when you want to take advantage of collocation with a larger table.
除非想要利用与更大的表的并置,否则应该将小型的表放在单分区的数据库分区组中。
A method for discovering functional dependencies based on the stripped partition database This efficient method is based on the concept of agree sets.
基于带状划分数据库的发现函数依赖集的方法这种方法基于一致集的概念。
There is an implicit assumption that the rows of each table are evenly distributed across all the partitions in each multiple-partition database partition group.
有一个隐式的假设:每个表中的行是均匀分布在每个多分区数据库分区组中的所有分区上的。
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.
对于单分区数据库,您可以对数据库分区号仅指定- 1(当前分区)或- 2(所有分区),结果是一样的。
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.
取决于数据库分区的数量,您可以有一个或多个单分区的数据库分区组,以及一个或多个多分区的数据库分区组。
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.
分区映射是内部生成的数组,对于多分区的数据库分区组,这个数组包含4,096个条目,对于单分区的数据库分区组,这个数组只包含一个条目。
Each database partition has its own set of computing resources, including CPU and storage.
每个数据库分区有它自己的一组计算资源,包括CPU和存储。
A database partition group is a set of one or more database partitions.
数据库分区组是由一个或多个数据库分区组成的一个组。
Database partition 0 is typically used for storing small, non-partitioned lookup tables.
数据库分区0通常用于存储小型的非分区的查找表。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
The joined tables must be defined in the same database partition group.
被合并的表必须在相同的数据库分区组内定义。
MAXFILOP is the maximum per database per partition.
MAXFILOP是每数据库每分区的最大值。
Each partition must use a unique partition number and the same database partition may be found in one or more database partition groups.
每个分区必须使用一个惟一的分区号,而同一个数据库分区可以属于一个或多个数据库分区组中。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
Each database in a partitioned database environment can have its catalog partition on a different database partition server.
在分区数据库环境中,每个数据库可以在一个不同的数据库分区服务器上有它的编目分区。
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.
数据被划分到一个数据库分区组中的所有分区上,可以为数据库分区组添加一个或多个数据库分区,或者从中去掉数据库分区。
A database partition can belong to more than one partition group.
一个数据库分区可以属于不止一个分区组。
The coordinator partition runs on the same database partition as the application, or in the case of a remote application, the database partition to which that application is connected.
协调分区与应用程序运行在同一个数据库分区上,或者,对于远程应用程序,协调分区运行在应用程序所连接的那个数据库分区上。
Each subset is known as a database partition group.
每个子集称作一个数据库分区组。
The most common partitioned environment consists of a single database partition on each physical system that makes up the database partition cluster.
最常见的分区环境由每个物理系统上的一个数据库分区组成,这些物理系统组成数据库分区集群。
Each entry represents a database partition on a particular server that participates in the database partitioning of the instance.
每个条目表示一个特定服务器上的一个数据库分区,该分区参与了该实例的数据库分区。
The coordinator partition runs on the same database partition as the application, or, in the case of remote applications, the database partition to which that application is connected.
协调分区与应用程序运行在同一个数据库分区上,或者,对于远程应用程序,协调分区运行在应用程序所连接的那个数据库分区上。
应用推荐