The SYS_ANY keyword can be used for all tablespaces.
SYS_ANY关键字可以用于所有表空间。
Review the tablespaces where the objects are to be stored.
查看对象所要存储到的表空间。
Review the tablespaces where the indexes are to be stored.
查看将要存储索引的表空间。
Execute the following commands to create the tablespaces on the nodes.
执行下列命令在节点上创建表空间。
Generate tablespaces, database partition groups, and buffer pool DDLS.
创建表空间、数据库分区、组和缓存池ddl。
The tablespaces were defined carefully to ensure excellent disk performance.
为确保优秀的磁盘性能，还需要慎重定义表空间。
You should understand the basic concepts of tablespaces, tables, and columns.
您应当理解表空间、表和列的基本概念。
DB2 does not need a list of tables for taking backups of DMS tablespaces, and.
DB2在对dms表空间做备份时并不需要表的列表。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
In this benchmark, a moderate page size, 16kb, was chosen for all DMS tablespaces.
在该基准测试中，为所有dms表空间选择了一个16kb的中等页面大小。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.
作为OLTP应用程序的经验法则，可在多个设备上使用dms表空间。
The same is true for temporary tablespaces often used for performing sort operations.
对于经常用于执行排序操作的临时表空间，也应该这样。
For optimal database performance, it is critical to have tablespaces defined properly.
为获得最佳的数据库性能，正确定义表空间是至关重要的。
Tablespaces that have a lower sequentiality ratio also are better candidates for SSDs.
具有较低连续率的表空间也比较适合放在SSD上。
Of course, this also requires that you create separate tablespaces for data and indexes.
当然，这还要求为数据和索引创建单独的表空间。
By executing the DB2 command LIST tablespaces, you can see all the tablespaces of a database.
执行db2命令LISTTABLESPACES，就可以看到一个数据库的所有表空间。
IBMDEFAULTGROUP - default database partition group for the tablespaces containing the user tables.
IBMDEFAULTGROUP-用于包含用户表的表空间的默认数据库分区组。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
确保系统目录和系统临时表空间中具有足够的自由空间。
If you use the defaults when creating a database, the following system-managed tablespaces are created.
如果您在创建数据库时使用默认值，则会创建下列系统管理的表空间。
These two scripts also take care of creating a set of tablespaces, in addition to the schema and tables.
除了模式和表之外，这两个脚本还负责创建一组表空间。
For DMS device container tablespaces, the operating system does not cache pages in the file system cache.
对于DMS设备容器表空间，操作系统不在文件系统缓存器中缓存页面。
The disk subsystem is organized for optimal performance by carefully mapping the tablespaces onto the disks.
还要通过仔细地将表空间映射到磁盘上来组织好磁盘子系统，从而获得最佳性能。
For production machines, we recommend to choose the appropriate database elements like tablespaces and so on.
对于生产机器，我们建议选择诸如表空间等适当的数据库元素。
Perl tbs_usage.pl - This script provides the free and used space for all the tablespaces for a given database.
perl tbs_usage . pl——该脚本提供了给定数据库的所有表空间的空闲和已用空间。
With DB2 9.7 you can also convert your database and tablespaces to use automatic storage after database creation.
而对于DB 2 9.7，还可以在数据库创建后，将数据库和表空间转换为使用自动存储。
When specifying this NONRECOVERABLE keyword, the user is not forced to take backups of the tablespaces immediately.
如果指定这个NONRECOVERABLE关键字，那么用户不必马上对表空间进行备份。
You can choose different page sizes for the different tablespaces based on the type of the application that is used.
您可以基于所使用的应用程序类型为不同的表空间选择不同的页面大小。
All storage components of the DB2 database were defined on this volume group, including tablespaces, log, and backups.
在这个卷组上定义了DB 2数据库的所有存储组件，包括表空间、日志和备份。
应用推荐