每个数据库有自己的编目表空间、临时表空间和用户表空间，这些表空间是在成功创建数据库时默认创建的。
Each database has its own catalog table space, temporary table space, and user table space which are created by default upon successful database creation.
使用上面这组命令将创建缓冲池和表空间。
In the above set of commands, buffer pools and table Spaces have been created.
为实现一定百分比的预留空间，和常规表一样使用相同的语法，即在创建表时使用PCTFREE选项。
To implement a percentage of space to be reserved, you use the same syntax as with regular tables, namely, by using the PCTFREE option when the table is created.
您在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.
可使用以下命令创建此类数据库和表空间。
The following commands can be used to create such a database and table spaces.
创建所需的数据库和表空间。
而对于DB 2 9.7，还可以在数据库创建后，将数据库和表空间转换为使用自动存储。
With DB2 9.7 you can also convert your database and tablespaces to use automatic storage after database creation.
当然，这还要求为数据和索引创建单独的表空间。
Of course, this also requires that you create separate tablespaces for data and indexes.
默认情况下，不同的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.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建，并且在使用这些表空间之前，还需要为之指定一个用户。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
创建DB 2数据库、缓冲池和表空间，使用大于4k的页面大小。
Create DB2 database, buffer pool, and tablespace with more than 4k.
除了模式和表之外，这两个脚本还负责创建一组表空间。
These two scripts also take care of creating a set of tablespaces, in addition to the schema and tables.
第 1 步：我们假设已经用默认表空间创建了一个数据库，同时创建下面的事实表和维度表。
STEP A: We assume you have created a database with the default table spaces. Create the fact and dimension tables as follows.
为此，需要创建FrameworkManager名称空间，其中导入的所有表和视图都保持不变。
To do so, one would create a Framework Manager namespace in which all imported tables and views remain unmodified.
下列示例利用系统管理的目录表空间以及数据库管理的临时表空间和用户表空间创建了名为tested的数据库。
The following example creates the database named tested with a system-managed catalog tablespace and database-managed temporary and user tablespaces.
MQT被创建之后，便处于检查暂挂状态(请参阅DB 2基础：阐明表和表空间的状态)，在对它执行SETintegrity语句之前，不能查询它。
After being created, the MQT is in check pending state (see Demystifying table and table space states), and cannot be queried until the SET INTEGRITY statement has been executed against it.
loadshp创建了两个表：cities和tsunami，并将空间数据分别加载到citylim和inundation列中。
Loadshp creates two tables called cities and tsunami and loads the spatial data into the citylim and inundation columns, respectively.
输出表的名称是输出表的名称（和驱动器的路径），将创建一个包含空间统计。
Output Table Name is the name (and drive path) of the output table that will be created containing the spatial statistics.
输出表的名称是输出表的名称（和驱动器的路径），将创建一个包含空间统计。
Output Table Name is the name (and drive path) of the output table that will be created containing the spatial statistics.
应用推荐