Recovering from the loss of a data file that belongs to the system tablespace.
从属于系统表空间的数据文件的丢失中恢复。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
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作为工作区域以存储中间结果。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面,大小16K,由系统管理(fnis缓冲池BP)。
TABLESPACE_MAP the user may specify tablespace name mappings to be used instead of the tablespaces from the source system during a copy.
TABLESPACE_MAP用户可以指定在复制期间使用的表空间名映射,而不使用来自源数据库的表空间。
The following example creates the database named tested with a system-managed catalog tablespace and database-managed temporary and user tablespaces.
下列示例利用系统管理的目录表空间以及数据库管理的临时表空间和用户表空间创建了名为tested的数据库。
Then what the different between system temporary tablespace and user temporary tablespace?
要使用临时表,是不是要有用户临时表空间?
Then what the different between system temporary tablespace and user temporary tablespace?
要使用临时表,是不是要有用户临时表空间?
应用推荐