Road map to the catalog views

This topic lists the catalog views, grouped by object or functionality.

Table 1. Road map to the read-only catalog views
Description	Catalog View
attributes of structured data types	SYSCAT.ATTRIBUTES catalog view
audit policies	SYSCAT.AUDITPOLICIES catalog view SYSCAT.AUDITUSE catalog view
authorities on database	SYSCAT.DBAUTH catalog view
buffer pool configuration on database partition group	SYSCAT.BUFFERPOOLS catalog view
buffer pool size exceptions for database partitions	SYSCAT.BUFFERPOOLDBPARTITIONS catalog view
buffer pool size exceptions for members	SYSCAT.BUFFERPOOLEXCEPTIONS catalog view
cast functions	SYSCAT.CASTFUNCTIONS catalog view
check constraints	SYSCAT.CHECKS catalog view
column masks	SYSCAT.CONTROLS catalog view
column mask dependences	SYSCAT.CONTROLDEP catalog view
column privileges	SYSCAT.COLAUTH catalog view
columns	SYSCAT.COLUMNS catalog view
columns referenced by check constraints	SYSCAT.COLCHECKS catalog view
columns used in dimensions	SYSCAT.COLUSE catalog view
columns used in keys	SYSCAT.KEYCOLUSE catalog view
conditions	SYSCAT.CONDITIONS catalog view
constraint dependencies	SYSCAT.CONSTDEP catalog view
controls	SYSCAT.CONTROLS catalog view
database partition group database partitions	SYSCAT.DBPARTITIONGROUPDEF catalog view
database partition group definitions	SYSCAT.DBPARTITIONGROUPS catalog view
data partitions	SYSCAT.DATAPARTITIONEXPRESSION catalog view SYSCAT.DATAPARTITIONS catalog view
data type dependencies	SYSCAT.DATATYPEDEP catalog view
data types	SYSCAT.DATATYPES catalog view
detailed column group statistics	SYSCAT.COLGROUPCOLS catalog view SYSCAT.COLGROUPDIST catalog view SYSCAT.COLGROUPDISTCOUNTS catalog view SYSCAT.COLGROUPS catalog view
detailed column options	SYSCAT.COLOPTIONS catalog view
detailed column statistics	SYSCAT.COLDIST catalog view
distribution maps	SYSCAT.PARTITIONMAPS catalog view
event monitor definitions	SYSCAT.EVENTMONITORS catalog view
events currently monitored	SYSCAT.EVENTS catalog view SYSCAT.EVENTTABLES catalog view
fields of row data types	SYSCAT.ROWFIELDS catalog view
function dependencies¹	SYSCAT.ROUTINEDEP catalog view
function mapping	SYSCAT.FUNCMAPPINGS catalog view
function mapping options	SYSCAT.FUNCMAPOPTIONS catalog view
function parameter mapping options	SYSCAT.FUNCMAPPARMOPTIONS catalog view
function parameters¹	SYSCAT.ROUTINEPARMS catalog view
functions¹	SYSCAT.ROUTINES catalog view
global variables	SYSCAT.VARIABLEAUTH catalog view SYSCAT.VARIABLEDEP catalog view SYSCAT.VARIABLES catalog view
hierarchies (types, tables, views)	SYSCAT.HIERARCHIES catalog view SYSCAT.FULLHIERARCHIES catalog view
identity columns	SYSCAT.COLIDENTATTRIBUTES catalog view
index columns	SYSCAT.INDEXCOLUSE catalog view
index data partitions	SYSCAT.INDEXPARTITIONS catalog view
index dependencies	SYSCAT.INDEXDEP catalog view
index exploitation	SYSCAT.INDEXEXPLOITRULES catalog view
index extension dependencies	SYSCAT.INDEXEXTENSIONDEP catalog view
index extension parameters	SYSCAT.INDEXEXTENSIONPARMS catalog view
index extension search methods	SYSCAT.INDEXEXTENSIONMETHODS catalog view
index extensions	SYSCAT.INDEXEXTENSIONS catalog view
index options	SYSCAT.INDEXOPTIONS catalog view
index privileges	SYSCAT.INDEXAUTH catalog view
indexes	SYSCAT.INDEXES catalog view
invalid objects	SYSCAT.INVALIDOBJECTS catalog view
member susbsets	SYSCAT.MEMBERSUBSETATTRS catalog view SYSCAT.MEMBERSUBSETMEMBERS catalog view SYSCAT.MEMBERSUBSETS catalog view
method dependencies¹	SYSCAT.ROUTINEDEP catalog view
method parameters¹	SYSCAT.ROUTINES catalog view
methods¹	SYSCAT.ROUTINES catalog view
module objects	SYSCAT.MODULEOBJECTS catalog view
module privileges	SYSCAT.MODULEAUTH catalog view
modules	SYSCAT.MODULES catalog view
nicknames	SYSCAT.NICKNAMES catalog view
object mapping	SYSCAT.NAMEMAPPINGS catalog view
package dependencies	SYSCAT.PACKAGEDEP catalog view
package privileges	SYSCAT.PACKAGEAUTH catalog view
packages	SYSCAT.PACKAGES catalog view
partitioned tables	SYSCAT.TABDETACHEDDEP catalog view
pass-through privileges	SYSCAT.PASSTHRUAUTH catalog view
periods	SYSCAT.PERIODS catalog view
predicate specifications	SYSCAT.PREDICATESPECS catalog view
procedure options	SYSCAT.ROUTINEOPTIONS catalog view
procedure parameter options	SYSCAT.ROUTINEPARMOPTIONS catalog view
procedure parameters¹	SYSCAT.ROUTINEPARMS catalog view
procedures¹	SYSCAT.ROUTINES catalog view
protected tables	SYSCAT.SECURITYLABELACCESS catalog view SYSCAT.SECURITYLABELCOMPONENTELEMENTS catalog view SYSCAT.SECURITYLABELCOMPONENTS catalog view SYSCAT.SECURITYLABELS catalog view SYSCAT.SECURITYPOLICIES catalog view SYSCAT.SECURITYPOLICYCOMPONENTRULES catalog view SYSCAT.SECURITYPOLICYEXEMPTIONS catalog view SYSCAT.SURROGATEAUTHIDS catalog view
provides Db2® for z/OS® compatibility	SYSIBM.SYSDUMMY1 catalog view
referential constraints	SYSCAT.REFERENCES catalog view
remote table options	SYSCAT.TABOPTIONS catalog view
roles	SYSCAT.ROLEAUTH catalog view SYSCAT.ROLES catalog view
routine dependencies	SYSCAT.ROUTINEDEP catalog view
routine parameters¹	SYSCAT.ROUTINEPARMS catalog view
routine privileges	SYSCAT.ROUTINEAUTH catalog view
routines¹	SYSCAT.ROUTINES catalog view SYSCAT.ROUTINESFEDERATED catalog view
row permisssions	SYSCAT.CONTROLS catalog view
row permission dependeencies	SYSCAT.CONTROLDEP catalog view
schema privileges	SYSCAT.SCHEMAAUTH catalog view
schemas	SYSCAT.SCHEMATA catalog view
sequence privileges	SYSCAT.SEQUENCEAUTH catalog view
sequences	SYSCAT.SEQUENCES catalog view
server options	SYSCAT.SERVEROPTIONS catalog view
server-specific user options	SYSCAT.USEROPTIONS catalog view
statements	SYSCAT.STATEMENTS catalog view SYSCAT.STATEMENTTEXTS catalog view
storage groups	SYSCAT.STOGROUPS catalog view
procedures	SYSCAT.ROUTINES catalog view
system servers	SYSCAT.SERVERS catalog view
table constraints	SYSCAT.TABCONST catalog view
table dependencies	SYSCAT.TABDEP catalog view
table privileges	SYSCAT.TABAUTH catalog view
table space use privileges	SYSCAT.TBSPACEAUTH catalog view
table spaces	SYSCAT.TABLESPACES catalog view
tables	SYSCAT.TABLES catalog view
transforms	SYSCAT.TRANSFORMS catalog view
trigger dependencies	SYSCAT.TRIGDEP catalog view
triggers	SYSCAT.TRIGGERS catalog view
trusted contexts	SYSCAT.CONTEXTATTRIBUTES catalog view SYSCAT.CONTEXTS catalog view
type mapping	SYSCAT.TYPEMAPPINGS catalog view
usage lists	SYSCAT.USAGELISTS catalog view
user-defined functions	SYSCAT.ROUTINES catalog view
view dependencies	SYSCAT.TABDEP catalog view
views	SYSCAT.TABLES catalog view SYSCAT.VIEWS catalog view
workload management	SYSCAT.HISTOGRAMTEMPLATEBINS catalog view SYSCAT.HISTOGRAMTEMPLATES catalog view SYSCAT.HISTOGRAMTEMPLATEUSE catalog view SYSCAT.SCPREFTBSPACES catalog view SYSCAT.SERVICECLASSES catalog view SYSCAT.THRESHOLDS catalog view SYSCAT.WORKACTIONS catalog view SYSCAT.WORKACTIONSETS catalog view SYSCAT.WORKCLASSATTRIBUTES catalog view SYSCAT.WORKCLASSES catalog view SYSCAT.WORKCLASSSETS catalog view SYSCAT.WORKLOADAUTH catalog view SYSCAT.WORKLOADCONNATTR catalog view SYSCAT.WORKLOADS catalog view
wrapper options	SYSCAT.WRAPOPTIONS catalog view
wrappers	SYSCAT.WRAPPERS catalog view
XML strings	SYSCAT.XMLSTRINGS catalog view
Index on XML column	SYSCAT.INDEXXMLPATTERNS catalog view
XSR objects	SYSCAT.XDBMAPGRAPHS catalog view SYSCAT.XDBMAPSHREDTREES catalog view SYSCAT.XSROBJECTAUTH catalog view SYSCAT.XSROBJECTCOMPONENTS catalog view SYSCAT.XSROBJECTDEP catalog view SYSCAT.XSROBJECTDETAILS catalog view SYSCAT.XSROBJECTHIERARCHIES catalog view SYSCAT.XSROBJECTS catalog view

¹ The following catalog views for functions, methods, and procedures defined in Db2 Version 7.1 and earlier are still available:

   Functions:  SYSCAT.FUNCTIONS, SYSCAT.FUNCDEP, SYSCAT.FUNCPARMS
   Methods:    SYSCAT.FUNCTIONS, SYSCAT.FUNCDEP, SYSCAT.FUNCPARMS
   Procedures: SYSCAT.PROCEDURES, SYSCAT.PROCPARMS

However, these views have not been updated since Db2 Version 7.1. Use the SYSCAT.ROUTINES, SYSCAT.ROUTINEDEP, or SYSCAT.ROUTINEPARMS catalog view instead.

Table 2. Road map to the updatable catalog views
Description	Catalog View
columns	SYSSTAT.COLUMNS catalog view
detailed column group statistics	SYSSTAT.COLGROUPDIST catalog view SYSSTAT.COLGROUPDISTCOUNTS catalog view SYSSTAT.COLGROUPS catalog view
detailed column statistics	SYSSTAT.COLDIST catalog view
indexes	SYSSTAT.INDEXES catalog view
routines¹	SYSSTAT.ROUTINES catalog view
tables	SYSSTAT.TABLES catalog view

¹ The SYSSTAT.FUNCTIONS catalog view still exists for updating the statistics for functions and methods. This view, however, does not reflect any changes since Db2 Version 7.1.