下面的脚本给出了一个例子,我们可以对其进行更改,从而在自己的环境中创建一个用户临时表空间。
The script below shows an example, which you can modify to create a user temporary table space in your environment.
没有创建用户临时表空间。
创建数据库时不存在用户临时表空间。
No user temporary table Spaces exist when a database is created.
为了构建这个日志框架,需要数据库管理员帮我们设置存储过程的日志目录并创建一个用户临时表空间。
In order for you to set up the logging framework, you will need help from your database administrator to set up the stored procedure logging directory and a user temporary table space.
您在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.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
You should create one or more USER temporary table spaces for storing data of temporary tables.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
每个数据库有自己的编目表空间、临时表空间和用户表空间,这些表空间是在成功创建数据库时默认创建的。
Each database has its own catalog table space, temporary table space, and user table space which are created by default upon successful database creation.
最好从系统临时表空间创建用户临时表空间。
It is best to create user temporary table space from the system one.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建,并且在使用这些表空间之前,还需要为之指定一个用户。
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.
创建一个用作全局临时表的用户表空间。
Create a user temporary table space for use by the global temporary table.
用户临时表空间是可选的,默认情况下不会创建用户临时表空间。
User temporary table Spaces are optional and none are created by default.
下列示例利用系统管理的目录表空间以及数据库管理的临时表空间和用户表空间创建了名为tested的数据库。
The following example creates the database named tested with a system-managed catalog tablespace and database-managed temporary and user tablespaces.
随数据库创建的系统临时表空间的默认名为TEMPSPACE1。
用于已声明的临时表的用户临时表空间可以在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中创建。
A user temporary tablespace, for declared temporary tables, can be created in IBMDEFAULTGROUP or any user-created database partition group, but not in IBMTEMPGROUP.
应用推荐