Appendix D. Using the DB2 System Catalog Tables

This appendix describes how to use the DB2 system catalog tables to examine your database in more detail. You will learn about:

  • The different types of system catalog tables

  • How to find useful information in the system catalog tables

  • How to perform what-if analysis on query performance

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 ...

Get Understanding DB2®: Learning Visually with Examples, Second Edition 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.