DB2 SYSIBM Catalog Tables Key Points Read Today How These are Modified

The catalog tables in DB2 also called System tables. You no need to create these tables. These will be created automatically when an administrator creates a database.

Photo Credit: Srini

Information You Can Read from Catalog Tables

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

Related: Top DB2 Interview Questions

Types of Catalog Tables Schemas

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

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

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

Database Object vs SYSCAT 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

Related Posts

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

Author: Srini

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