IBM Books

Create Database -- Catalog Tables

Graphic of Overview push button appears here.
Figure rule not displayed.

Use the Catalog Tables page of the Create Database SmartGuide to allocate storage space for the database.

All the system catalog tables for the database are stored in the catalog table space. Every database requires one catalog table space that cannot be dropped. The default name is SYSCATSPACE.

When you create a database, system catalog tables are also created at the same time. These system tables grow as user tables, views, indexes, authorizations, and packages are added to the database. Initially, they use approximately 1600KB of disk space.

The amount of space allocated for the catalog tables depends on the type of table space and the extent size for the table space.


Figure rule not displayed.

Controls

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]