A system temporary tablespace is used by the database manager to perform various SQL operations such as sorting, reorganizing tables, creating indexes, and joining tables. A database must have at least one temporary tablespace. The maximum size of a temporary tablespace is 2 TB. DB2 supports both system temporary tablespaces and user temporary tablespaces. The user temporary tablespace is used for DECLARED TEMPORARY tables.
Pass DB2 Certification in first attampt. Become IBM IBM DB2 9 DBA for Linux UNIX and Windows certified.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
