DB2 5 Schema Names Where all Catalog Tables Present

You can say catalog tables as system Tables in DB2. These come with initial database creation – you don’t need to create explicitly.

Top Catalog Tables

  • Tables
  • Indexes
  • Views
  • Security information
  • Tables update information
  • Statistics

Related: Top DB2 Interview Questions

Catalog Table Schemas

The tables under SYSIBM schema are master tables. The tables under SYSCAT are views of SYSIBM.

  1. SYSIBM
  2. SYSCAT
  3. SYSFUN
  4. SYSPROC
  5. SYSSTAT

Database Object Vs SYSCAT System Catalog Views

Database ObjectSYSCAT System Catalog View
TableTABLES
ViewVIEWS
IndexINDEXES
Data typeDATATYPES
ColumnCOLUMNS
Table spaceTABLESPACES
Buffer poolBUFFERPOOLS
PackagePACKAGES
ConstraintsCHECKS
Referential integrityREFERENCES
Partition groupsNODEGROUPS
Partition group definitionsNODEGROUPDEF
XML values indexINDEXXMLPATTERNS
Stored proceduresPROCEDURES
SequencesSEQUENCES
Event MonitorsEVENTMONITORS

DB2 Catalog Table Interview Questions

1). Which is the schema used for user-defined functions?

Ans) SYSFUN

2). Which is the schema used for stored procedures?

Ans) SYSPROC

3). The views created under SYSSTAT are user editable?

Yes. These are editable.

4) Which command you need to use to know tables defined under a schema?

Ans) LIST TABLES FOR SCHEMA schema-name

Top DB2 Blogs

The Bottom Line

  1. Catalog tables you can read. 
  2. During performance management, the data is very much useful
  3. Security catalog tables useful to know who did data change in a particular table.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.