The below is the list of catalog tables in DB2. Given here to your quick reference.

- SYSIBM.SYSCONTROLS table
The SYSIBM.SYSCONTROLS table contains one row for each row permission and column mask. - SYSIBM.SYSCOPY table
The SYSIBM.SYSCOPY table contains information needed for recovery. - SYSIBM.SYSCTXTTRUSTATTRS table
The SYSIBM.SYSCTXTTRUSTATTRS table contains one row for each list of attributes for a given trusted context. - SYSIBM.SYSDATABASE table
The SYSIBM.SYSDATABASE table contains one row for each database, except for database DSNDB01. - SYSIBM.SYSDATATYPES table
The SYSIBM.SYSDATATYPES table contains one row for each distinct type defined to the system. - SYSIBM.SYSDBAUTH table
The SYSIBM.SYSDBAUTH table records the privileges that are held by users over databases.
Ref IBM
Also read
- How to Connect DB2 in PHP engine
- How to Understand Data Protection in DB2
- Left Vs Right Outer Join Which is Better







You must be logged in to post a comment.