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.
