Generate tablespaces, database partition groups, and buffer pool DDLS.
创建表空间、数据库分区、组和缓存池ddl。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
Each partition must use a unique partition number and the same database partition may be found in one or more database partition groups.
每个分区必须使用一个惟一的分区号,而同一个数据库分区可以属于一个或多个数据库分区组中。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
用户可以通过使用数据库分区组和表空间,来确定将表数据分布到哪些数据库分区上。
Small tables should be placed in single-partition database partition groups, except when you want to take advantage of collocation with a larger table.
除非想要利用与更大的表的并置,否则应该将小型的表放在单分区的数据库分区组中。
This is accomplished by placing user tables in database partition groups that do not include the database partition in the IBMCATGROUP database partition group.
为此,可以将用户表放在不包括IBMCATGROUP数据库分区组中的数据库分区的数据库分区组中。
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个条目,对于单分区的数据库分区组,这个数组只包含一个条目。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
应用推荐