| 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. |
DB2 Version 9.7 for Linux, UNIX, and Windows