In the database, five regular tablespaces and one temporary tablespace are defined. The following table shows the details of all tablespaces.
数据库中定义了五个常规的表空间和一个临时表空间。
The following REORG example reorganizes the customer table using the system temporary tablespace TEMPSAPCE1 as a work area to store the intermediate results.
下列 REORG示例重新组织客户表,并使用系统临时表空间 TEMPSAPCE1作为工作区域以存储中间结果。
A user temporary tablespace, for declared temporary tables, can be created in IBMDEFAULTGROUP or any user-created database partition group, but not in IBMTEMPGROUP.
用于已声明的临时表的用户临时表空间可以在IBMDEFAULTGROUP或任何用户创建的数据库分区组中创建,但不能在IBMTEMPGROUP中创建。
A user temporary tablespace, for declared temporary tables, can be created in IBMDEFAULTGROUP or any user-created database partition group, but not in IBMTEMPGROUP.
用于已声明的临时表的用户临时表空间可以在IBMDEFAULTGROUP或任何用户创建的数据库分区组中创建,但不能在IBMTEMPGROUP中创建。
应用推荐