Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Effect of Configuration on I/O Activity > Chunk and Dbspace Configuration >

Place 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, It is recommended that you do not cluster the system catalog tables for all databases in a single dbspace but 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.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]