The consumed space in the user temporary table space will be freed.
所消耗的用户临时表空间中的空间将得到释放。
We then turn tracing on using the default user temporary table space provided by the friendly DBA.
然后，我们使用友好的DBA提供的默认用户临时表空间打开跟踪。
After an application session defines a created temporary table, concurrently running sessions do not have to redefine it.
在应用程序会话定义已创建的临时表之后，并发运行的会话不需要重新定义它。
Listing 9 shows an example of a declared temporary table.
清单9展示了一个已声明临时表的示例。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
It completes the encapsulation of the temporary table declaration through stored procedures.
完成了通过存储过程声明临时表的封装。
Each DB2 database contains at least one catalog table space, one or more user table Spaces, and one or more temporary table Spaces.
每一个DB 2数据库都至少包含一个分类表空间，一个或多个用户空间，以及一个或多个临时表空间。
You can reference a created temporary table in SQL functions, triggers, indexes, and views.
您可以在sql函数、触发器、索引和视图中引用已创建的临时表。
Each database has its own catalog table space, temporary table space, and user table space which are created by default upon successful database creation.
每个数据库有自己的编目表空间、临时表空间和用户表空间，这些表空间是在成功创建数据库时默认创建的。
The script below shows an example, which you can modify to create a user temporary table space in your environment.
下面的脚本给出了一个例子，我们可以对其进行更改，从而在自己的环境中创建一个用户临时表空间。
If the same temporary table may be instantiated from multiple locations in application code, the definition of the table is centralized at one place.
如果在应用程序代码中的多个位置实例化相同的临时表，该表的定义可以集中在一个地方。
For instance VSAM or IMS data can be retrieved into a global or declared temporary table and subsequently processed by client applications using SQL and result set logic.
例如，客户机应用程序可以使用SQL和结果集逻辑把VSAM或IMS数据读取到全局或声明的临时表中，然后处理它们。
There is no reason to have more than one temporary table space of the same page size, and usually one with the largest page size is sufficient.
没有必要拥有多个具有相同页大小的临时表空间，通常只需一个具有最大页大小的临时表空间就够了。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
No user temporary table space was created.
没有创建用户临时表空间。
Temporary tables are stored in user temporary table Spaces.
临时表存储在用户临时表空间中。
The procedure developer does not have to hunt through application code (which may be maintained by another person) to find the DDL of the temporary table.
过程开发人员不必为了得到临时表的DDL而找遍应用程序代码(可能是由其他人来维护的)。
Consider using a table variable instead a temporary table.
考虑使用表变量来代替临时表。
The key point to note here is that the procedure creates successfully even though the temporary table was not declared within the procedure body.
这里要注意的关键是，即使在过程体中没有声明临时表，该过程也被成功创建。
How can P2 and P3 reference a temporary table declared in P1 without re-declaring it themselves?
P2和P3又如何能引用P 1中声明的临时表而无需再重新声明呢？
No user temporary table Spaces exist when a database is created.
创建数据库时不存在用户临时表空间。
Indexes defined on a declared global temporary table cannot be transferred.
定义在声明的全局临时表上的索引不能被转移。
Prior to this release, the declared temporary table (DGTT) was the only type of user-defined temporary table.
在此发行版之前，已声明的临时表(DGTT)是唯一的一种用户定义的临时表。
As well, DB2 always required a system temporary table space that had a 4 KB page size too.
DB 2同样总是需要一个也是4KB页面大小的系统临时表空间。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
Also, any connection can refer to a created temporary table at any time without the need for a setup script to initialize the created temporary table.
此外，任意连接都可以随时引用已创建的临时表，而不需要设置脚本来初始化已创建的临时表。
Figure 8 shows the database, which has five table Spaces: a catalog, two regular, a long, and a system temporary table space.
图8显示了一个具有五个表空间的数据库：一个目录表空间、两个常规表空间、一个长表空间和一个系统临时表空间。
Listing 7 shows the statistics associated with temporary-table creation.
清单7给出了与临时表创建有关的统计信息。
Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).
使用为基线数据的每会话存储创建的全局临时表（CGTT）（对于每个表函数，使用一个 CGTT）。
To use this routine in DB2 V8.2.2 requires an 8 KB page user temporary table space.
为了使用该例程，DB 2V8.2.2中需要一个8KB页面的用户临时表空间。
应用推荐