tablespaces

Of course , this also requires that you create separate tablespaces for data and indexes .

当然，这还要求为数据和索引创建单独的表空间。

Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces .

确保系统目录和系统临时表空间中具有足够的自由空间。

You should understand the basic concepts of tablespaces , tables , and columns .

您应当理解表空间、表和列的基本概念。

It is not always possible to have the same tablespaces set up in test that you have in production .

并非总是可以在测试中设置与生产中相同的表空间。

Generate tablespaces , database partition groups , and buffer pool DDLs

创建表空间、数据库分区、组和缓存池DDL

For production machines , we recommend to choose the appropriate database elements like tablespaces and so on .

对于生产机器，我们建议选择诸如表空间等适当的数据库元素。

IBMDEFAULTGROUP-default database partition group for the tablespaces containing the user tables .

IBMDEFAULTGROUP-用于包含用户表的表空间的默认数据库分区组。

This is the layout for database partition groups , buffer pools and tablespaces .

这是用于数据库分区组、缓冲池和表空间的布局。

Spreading tablespaces over multiple containers ( which map to separate disks ) .

将表空间分布在多个容器（这些容器映射到不同磁盘）。

Tablespaces that have a lower sequentiality ratio also are better candidates for SSDs .

具有较低连续率的表空间也比较适合放在SSD上。

These two scripts also take care of creating a set of tablespaces , in addition to the schema and tables .

除了模式和表之外，这两个脚本还负责创建一组表空间。

This way , a LOAD FROM CURSOR is a fast and easy possibility to move data between different tablespaces or different databases .

因此，LOADFROMCURSOR是在不同的表空间或数据库之间快速轻松地转移数据的方法。

As well as a table can be moved between tablespaces within a database , a table can be moved between two different databases .

除了可以在一个数据库中的表空间之间转移表之外，还可以在不同的数据库之间转移表。

If you are using DB2 automatic storage , you need to decide whether you want Performance Expert to collect counters for tablespaces .

如果使用DB2自动存储，就需要决定是否要让PerformanceExpert收集表空间的计数器。

All storage components of the DB2 database were defined on this volume group , including tablespaces , log , and backups .

在这个卷组上定义了DB2数据库的所有存储组件，包括表空间、日志和备份。

You have already extracted DDL and made the required manual changes for the mapping between tables and tablespaces if required .

已经提取了DDL，对表和表空间之间的映射做了必要的手工修改。

This option is available for all DB2 tablespaces , including system and temporary tablespaces and database managed tablespaces .

所有DB2表空间都可以使用这个选项，包括系统表空间和临时表空间，以及数据库管理的表空间。

By executing the DB2 command LIST TABLESPACES , you can see all the tablespaces of a database .

执行DB2命令LISTTABLESPACES，就可以看到一个数据库的所有表空间。

Using database partition groups and tablespaces , a user can determine across which and how many database partitions their table data is to be spread .

用户可以通过使用数据库分区组和表空间，来确定将表数据分布到哪些数据库分区上。

The SYS_ANY keyword can be used for all tablespaces .

SYSANY关键字可以用于所有表空间。

In addition , the user can specify specific mappings for some tablespaces , and the default tablespace selection algorithm for the remaining .

另外，用户可以为某些表空间指定特定的映射，而对其他表空间使用默认的表空间选择算法。

TABLESPACE_MAP The user may specify tablespace name mappings to be used instead of the tablespaces from the source system during a copy .

TABLESPACEMAP用户可以指定在复制期间使用的表空间名映射，而不使用来自源数据库的表空间。

It is recommended for database managed tablespaces to split regular data from LOB data , placing LOB data in a large tablespace .

对于数据库管理的表空间，建议拆开LOB数据中的常规数据，将LOB数据放在一个很大的表空间中。

Always attempt to place DB2 logs on a separate disk from the tablespaces to avoid I / O contention between these critical database components .

始终将DB2日志放在与表空间隔离的磁盘，以避免关键数据库组件之间的I/O争用。

You can customize the setup script to specify different tablespaces for the configuration tables based on the need to backup and share the connection configurations .

根据备份和共享连接配置的需要，可以通过定制设置脚本为配置表指定不同的表空间。

When specifying this NONRECOVERABLE keyword , the user is not forced to take backups of the tablespaces immediately .

如果指定这个NONRECOVERABLE关键字，那么用户不必马上对表空间进行备份。

Then use the range partition features of DB2 to roll newer data into the frequently used or " hot " tablespaces as the older data grows colder .

然后，随着较旧的数据使用率下降，再使用DB2的范围分区特性将较新的数据转入常用或“热”表空间。

Also , while the redistribute utility still running , the redistributed table can also do the same if tablespace backup is performed on the tablespaces associated with the table .

而且，当重分发实用程序仍在运行时，如果在与该表相关的表空间上执行了表空间备份，那么也可以在被重分发的表上执行相同的操作。

When these metrics are summarized for all tablespaces based on descending order of weighting factor , those tablespaces that have a higher weighting factor are better candidates for SSDs .

对于所有表空间，综合上述指标，按权重因子降序排列，那些具有较高权重因子的表空间更适合放在SSD上。

Before creating tables for the database , you first create the database partition group where the tablespaces will be stored , and then you create the tablespace where the tables will be stored .

在为数据库创建表之前，首先创建用于存储表空间的数据库分区组，然后创建用于存储表的表空间。