Heavy hitter: SYSIBM.SYSTABLES

I tried out the GET_DEPENDENCY procedure on one of the central catalog tables. SYSIBM.SYSTABLES is the catalog table behind SYSCAT.TABLES (and some more). As you can see from the output below, a total of 23 views are dependent on it.

db2 => call dbms_utility.get_dependency(‘TABLE’,‘SYSIBM’,‘SYSTABLES’)

  Return Status = 0

DEPENDENCIES ON SYSIBM.SYSTABLES

*TABLE SYSIBM.SYSTABLES() *   VIEW SYSCAT  .AUDITUSE() *   VIEW SYSCAT  .INDEXES() *   VIEW SYSCAT  .NICKNAMES() *   VIEW SYSCAT  .PERIODS() *   VIEW SYSCAT  .TABLES() *   VIEW SYSIBM  .CHECK_CONSTRAINTS() *   VIEW SYSIBM  .COLUMNS() *   VIEW SYSIBM  .SQLCOLPRIVILEGES() *   VIEW SYSIBM  .SQLCOLUMNS() *   VIEW SYSIBM  .SQLFOREIGNKEYS() *   VIEW SYSIBM  .SQLPRIMARYKEYS() *   VIEW SYSIBM  .SQLSPECIALCOLUMNS() *   VIEW SYSIBM  .SQLSTATISTICS() *   VIEW SYSIBM  .SQLTABLEPRIVILEGES() *   VIEW SYSIBM  .SQLTABLES() *   VIEW SYSIBM  .TABLES() *   VIEW SYSIBM  .TABLE_CONSTRAINTS() *   VIEW SYSIBM  .VIEWS() *   VIEW SYSIBMADM.OBJECTOWNERS() *   VIEW SYSIBMADM.PRIVILEGES() *   VIEW SYSSTAT .COLDIST() *   VIEW SYSSTAT .COLUMNS() *   VIEW SYSSTAT .TABLES() *   PACKAGE SYSIBMADM.DBMS_ALERT() *   PACKAGE SYSIBMADM.DBMS_JOB() *   PACKAGE SYSIBMADM.DBMS_UTILITY() *   PACKAGE SYSIBMADM.UTL_DIR()

Do you know of another system table with more dependencies?