To ensure that catalog methods function correctly when the CatalogSchema property is set to a schema other than the default schema, views for the catalog tables listed in the following table must exist in the specified schema. The views that are required depend on your DB2 database.

Table 1. Catalog Tables for DB2
Database Catalog Tables
DB2 for Linux/UNIX/Windows
  • SYSCAT.TABLES
  • SYSCAT.COLUMNS
  • SYSCAT.PROCEDURES
  • SYSCAT.PROCPARAMS
  • SYSCAT.COLAUTH
  • SYSCAT.TABAUTH
  • SYSCAT.KEYCOLUSE
  • SYSCAT.INDEXES
  • SYSCAT.INDEXCOLUSE
  • SYSCAT.REFERENCES
  • SYSCAT.SYSSCHEMATA
  • SYSCAT.TYPEMAPPINGS
  • SYSCAT.DBAUTH
DB2 for z/OS
  • SYSIBM.SYSTABCONST
  • SYSIBM.SYSTABLES
  • SYSIBM.SYSSYNONYMS
  • SYSIBM.SYSCOLUMNS
  • SYSIBM.SYSPROCEDURES
  • SYSIBM.SYSROUTINES
  • SYSIBM.SYSPARMS
  • SYSIBM.SYSCOLAUTH
  • SYSIBM.SYSTABAUTH
  • SYSIBM.SYSKEYS
  • SYSIBM.SYSINDEXES
  • SYSIBM.SYSRELS
  • SYSIBM.SYSFOREIGNKEYS
  • SYSIBM.SYSSCHEMAAUTH
  • SYSIBM.SYSDBAUTH
DB2 for i
  • QSYS2.SYSCST
  • QSYS2.SYSKEYCST
  • QSYS2.SYSPROCS
  • QSYS2.SYSPARMS
  • QSYS2.SYSTABLES
  • QSYS2.SYSSYNONYMS
  • QSYS2.SYSCOLUMNS
  • QSYS2.SQLTABLEPRIVILEGES
  • QSYS2.SYSKEYS
  • QSYS2.SYSINDEXES
  • QSYS2.SYSREFCST