Catalog Views

Types of catalog Views IBM DB2 database manager provides two types of catalog views for every database instance:
 * SYSCAT views
 * SYSSTAT views

SYSCAT views
These views are created as read-only under the SYSCAT schema. They store the information needed to define the logical and physical structure of objects in the database. Select privilege is granted by default, for public in this schema.

SYSSTAT views
These are updatable views under the SYSSTAT schema. They store statistics about the database objects that the database manager uses while processing user requests in the form of queries or database utility calls