Placing system catalog tables with database tables

When a disk that contains the system catalog for a particular database fails, the entire database remains inaccessible until the system catalog is restored. Because of this potential inaccessibility, do not cluster the system catalog tables for all databases in a single dbspace. Instead place the system catalog tables with the database tables that they describe.

To create a system catalog table in the table dbspace:

  1. Create a database in the dbspace in which the table is to reside.
  2. Use the SQL statements DATABASE or CONNECT to make that database the current database.
  3. Enter the CREATE TABLE statement to create the table.
Parent topic: Chunk and dbspace configuration
Copyright© 2020 HCL Technologies Limited