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?