Db2 catalog tables

The catalog tables contain information about Db2 objects such as tables, views, and indexes. When you create, alter, or drop an object, Db2 inserts, updates, or deletes rows of the catalog that describe the object.

The DSNDB06 system database contains the Db2 catalog.

When you create, alter, or drop any structure, Db2 inserts, updates, or deletes rows in the catalog table that describe the structure and how it relates to other structures. For example, SYSIBM.SYSTABLES is one catalog table that records information when a table is created. Db2 inserts a row into SYSIBM.SYSTABLES that includes the table name, its owner, its creator, and the name of its table space and its database.