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.
执行下列命令在节点上创建表空间。
Spreading tablespaces over multiple containers (which map to separate disks).
将表空间分布在多个容器(这些容器映射到不同磁盘)。
You should understand the basic concepts of tablespaces, tables, and columns.
您应当理解表空间、表和列的基本概念。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
In this benchmark, a moderate page size, 16kb, was chosen for all DMS tablespaces.
在该基准测试中，为所有dms表空间选择了一个16kb的中等页面大小。
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.
为获得最佳的数据库性能，正确定义表空间是至关重要的。
As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.
作为OLTP应用程序的经验法则，可在多个设备上使用dms表空间。
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设备容器表空间，操作系统不在文件系统缓存器中缓存页面。
For production machines, we recommend to choose the appropriate database elements like tablespaces and so on.
对于生产机器，我们建议选择诸如表空间等适当的数据库元素。
The disk subsystem is organized for optimal performance by carefully mapping the tablespaces onto the disks.
还要通过仔细地将表空间映射到磁盘上来组织好磁盘子系统，从而获得最佳性能。
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数据库的所有存储组件，包括表空间、日志和备份。
The strategy is to spread the data for all tablespaces across as many drives as possible to maximize the IO parallelism.
策略是将所有表空间的数据扩展到尽可能多的驱动器中，以最大化IO并行性。
Run db2 list tablespaces show detail and db2 list packages for all show detail for the database(s) and save the results.
对数据库运行db2listtablespaces showdetail和 db2 listpackages forallshow detail并保存结果。
This way, a LOAD FROM CURSOR is a fast and easy possibility to move data between different tablespaces or different databases.
因此，LOADFROM CURSOR是在不同的表空间或数据库之间快速轻松地转移数据的方法。
This option is available for all DB2 tablespaces, including system and temporary tablespaces and database managed tablespaces.
所有DB 2表空间都可以使用这个选项，包括系统表空间和临时表空间，以及数据库管理的表空间。
应用推荐