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