执行下列命令在节点上创建表空间。
Execute the following commands to create the tablespaces on the nodes.
在以前,当创建表空间时,必须为它们指定容器。
Previously when you created table Spaces you had to specify containers for them. You can now have them automatically use the database storage pool.
创建表空间、数据库分区、组和缓存池ddl。
Generate tablespaces, database partition groups, and buffer pool DDLS.
如清单16所示,用名为cont1的容器创建表空间。
As shown in Listing 16, create a tablespace with one container named cont1.
可以将容器定义成文件(在创建表空间时将把给定的大小全部分配给它们)或设备。
Containers can be defined either as files (which are fully allocated with the size given when the table space is created) or devices.
在创建表空间的时候,会指派一个默认的缓冲池IBMDEFAULTBP。
When a tablespace is created, it is assigned to the default buffer pool IBMDEFAULTBP.
使用该方法时需要您指定最初空间大小,并且应当可以使用该打小成功创建表空间。
In this method, you are required to specify the initial amount of space and it should be available to have your table space successfully created.
当创建表空间时,可以将它与特定的缓冲区池(数据库缓存)关联起来,并关联到特定的容器。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
注意,如前所述,添加分区选项会自动根据组中第一个分区的表空间设置在新分区上创建表空间。
Note that, as described earlier, the add partition option automatically creates the tablespace on the new partition based on the tablespace setting from the first partition of the group.
该功能需要您在数据库级指定一个或多个存储路径,您希望DB 2在该路径中为每个表空间创建容器。
This feature requires you to specify, at database level, one or more storage paths where you want DB2 to create containers for every table space.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
没有创建用户临时表空间。
如果数据包括LOB,那么用户就必须创建lob表空间。
If the data includes LOBs, then the user must create LOB table Spaces.
有了这个特性,就不再需要担心如何创建附加的表空间、添加容器以及监控容器的增长等。
With this feature, you no longer need to worry about tasks such as creating additional table Spaces for capacity, adding containers, and monitoring container growth.
这种LDSVSAM数据集的最大尺寸将间接取决于您创建的表空间的类型和您在create语句上指定的参数。
The maximum size of such LDS VSAM datasets would depend indirectly upon the type of table space you create and the parameters you specify on the create statement.
除非显式指定,否则新创建的表空间都是具有较大行id的DMS。
Unless explicitly specified, new table Spaces are created as DMS with large row IDs.
在DB 29中,默认情况下,新创建的表空间是DMS。
使用上面这组命令将创建缓冲池和表空间。
In the above set of commands, buffer pools and table Spaces have been created.
清单1显示了用于创建存储表空间的命令。
Listing 1 shows you the commands to use to create automatic storage table Spaces.
可使用以下命令创建此类数据库和表空间。
The following commands can be used to create such a database and table spaces.
您在DSNDB07创建的表空间将用作处理SQL联接和排序以及临时表的存储。
Table Spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables.
在DB 2UDBV 7中创建分区的表空间时,DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
根据使用的数据库,创建适当的表空间。
Based on the database being used, create the appropriate table Spaces.
随数据库创建的系统临时表空间的默认名为TEMPSPACE1。
用它的所有回滚段重新创建回滚表空间。
Recreate the rollback tablespace with all of its rollback segments.
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
You should create an index in a separate table space so that if something goes wrong with the index table space, you can easily drop it and then recreate the same indexes.
每个数据库有自己的编目表空间、临时表空间和用户表空间,这些表空间是在成功创建数据库时默认创建的。
Each database has its own catalog table space, temporary table space, and user table space which are created by default upon successful database creation.
这样可以确保能够在32K页面大小的表空间中创建任何行大小超过4 K字节的用户表。
This ensures that any user tables whose row size exceeds 4k bytes is successfully created into a 32k page size tablespace.
您可以使用in子句在用户数据所在的表空间上创建一个索引,或者在其他表空间上创建索引。
You can use the in clause to create an index in the same table space where user data resides, or in a different table space.
默认情况下,不同的IBMtsom表是在默认表空间创建的,所以您应该使用另一个表空间来存储事件数据和事件表索引。
By default all the different IBM TSOM tables are created in the default table space, so you should use a separate table space for event data and event table indexes.
应用推荐