DB2 System Catalog Tables
Each DB2 database has a set of tables called the system catalog tables. DB2 creates these tables when a database is created. They contain definitions of database objects (for example, tables, views, indexes, and packages), security information about the type of access that users have to these objects, and statistical information about the tables in the database.
DB2 automatically updates these tables when SQL Data Definition Language (DDL) statements are issued. For example, when you create a table, DB2 enters the definition of the table into the SYSIBM.SYSTABLES table. When you create an index, DB2 enters the index definition into the SYSIBM.SYSINDEXES table. DB2 uses these catalog tables to keep track of what exists ...
Get Understanding DB2®: Learning Visually with Examples 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.
