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
[display-posts tag=”db2-tips” posts_per_page=”03″]
You must be logged in to post a comment.