DB2 Version 9.7 for Linux, UNIX, and Windows

Road map to the catalog views

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 on database partition SYSCAT.BUFFERPOOLDBPARTITIONS catalog view
cast functions SYSCAT.CASTFUNCTIONS catalog view
check constraints SYSCAT.CHECKS 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
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 dependencies1 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 parameters1 SYSCAT.ROUTINEPARMS catalog view
functions1 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
method dependencies1 SYSCAT.ROUTINEDEP catalog view
method parameters1 SYSCAT.ROUTINES catalog view
methods1 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
predicate specifications SYSCAT.PREDICATESPECS catalog view
procedure options SYSCAT.ROUTINEOPTIONS catalog view
procedure parameter options SYSCAT.ROUTINEPARMOPTIONS catalog view
procedure parameters1 SYSCAT.ROUTINEPARMS catalog view
procedures1 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 parameters1 SYSCAT.ROUTINEPARMS catalog view
routine privileges SYSCAT.ROUTINEAUTH catalog view
routines1 SYSCAT.ROUTINES catalog view
SYSCAT.ROUTINESFEDERATED 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 in packages SYSCAT.STATEMENTS 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
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.SERVICECLASSES catalog view
SYSCAT.THRESHOLDS catalog view
SYSCAT.WORKACTIONS catalog view
SYSCAT.WORKACTIONSETS 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
XML values index 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
1 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
routines1 SYSSTAT.ROUTINES catalog view
tables SYSSTAT.TABLES catalog view
1 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.