System Tablespaces
The DB2 system catalogs and their views are stored in an SMS tablespace, called SYSCATSPACE, created when the database is created. A new database is also created with two other SMS tablespaces: USERSPACE1 (for user data) and TEMPSPACE1 (a temporary tablespace).
Each database must have at least one temporary tablespace. Temporary tablespaces are used when sorts overflow from memory to disk. SQL queries with group by or order by clauses, for example, result in sorts, as do index create operations.
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
