| Description | Catalog View |
|
|---|---|---|
| attributes of structured data types | "SYSCAT.ATTRIBUTES" |
|
| authorities on database | "SYSCAT.DBAUTH" |
|
| buffer pool configuration on nodegroup | "SYSCAT.BUFFERPOOLS" |
|
| buffer pool size on node | "SYSCAT.BUFFERPOOLNODES" |
|
| cast functions | "SYSCAT.CASTFUNCTIONS" |
|
| check constraints | "SYSCAT.CHECKS" |
|
| column privileges | "SYSCAT.COLAUTH" |
|
| columns | "SYSCAT.COLUMNS" |
|
| columns referenced by check constraints | "SYSCAT.COLCHECKS" |
|
| columns used in keys | "SYSCAT.KEYCOLUSE" |
|
| detailed column options | "SYSCAT.COLOPTIONS" |
|
| detailed column statistics | "SYSCAT.COLDIST" |
|
| constraint dependencies | "SYSCAT.CONSTDEP" |
|
| datatypes | "SYSCAT.DATATYPES" |
|
| event monitor definitions | "SYSCAT.EVENTMONITORS" |
|
| events currently monitored | "SYSCAT.EVENTS" |
|
| hierarchies(types, tables,views) | "SYSCAT.FULLHIERARCHIES" |
|
| function dependencies | "SYSCAT.FUNCDEP" |
|
| function mapping | "SYSCAT.FUNCMAPPINGS" |
|
| function mapping options | "SYSCAT.FUNCMAPOPTIONS" |
|
| function mapping parameter options | "SYSCAT.FUNCMAPPARMOPTIONS" |
|
| function parameters | "SYSCAT.FUNCPARMS" |
|
| hierarchies (types, tables, views) | "SYSCAT.HIERARCHIES" |
|
| index privileges | "SYSCAT.INDEXAUTH" |
|
| Index columns | "SYSCAT.INDEXCOLUSE" |
|
| index dependencies | "SYSCAT.INDEXDEP" |
|
| indexes | "SYSCAT.INDEXES" |
|
| index options | "SYSCAT.INDEXOPTIONS" |
|
| nodegroup definitions | "SYSCAT.NODEGROUPS" |
|
| nodegroup nodes | "SYSCAT.NODEGROUPDEF" |
|
| object mapping | "SYSCAT.NAMEMAPPINGS" |
|
| package dependencies | "SYSCAT.PACKAGEDEP" |
|
| package privileges | "SYSCAT.PACKAGEAUTH" |
|
| packages | "SYSCAT.PACKAGES" |
|
| partitioning maps | "SYSCAT.PARTITIONMAPS" |
|
| pass-through privileges | "SYSCAT.PASSTHRUAUTH" |
|
| procedure options | "SYSCAT.PROCOPTIONS" |
|
| procedure parameter options | "SYSCAT.PROCPARMOPTIONS" |
|
| procedure parameters | "SYSCAT.PROCPARMS" |
|
| provides DB2 Universal Database for OS/390 compatibility | "SYSIBM.SYSDUMMY1" |
|
| referential constraints | "SYSCAT.REFERENCES" |
|
| remote table options | "SYSCAT.TABOPTIONS" |
|
| reverse data type mapping | "SYSCAT.REVTYPEMAPPINGS" |
|
| schema privileges | "SYSCAT.SCHEMAAUTH" |
|
| schemas | "SYSCAT.SCHEMATA" |
|
| server options | "SYSCAT.SERVEROPTIONS" |
|
| server options values | "SYSCAT.USEROPTIONS" |
|
| statements in packages | "SYSCAT.STATEMENTS" |
|
| stored procedures | "SYSCAT.PROCEDURES" |
|
| system servers | "SYSCAT.SERVERS" |
|
| table constraints | "SYSCAT.TABCONST" |
|
| table privileges | "SYSCAT.TABAUTH" |
|
| tables | "SYSCAT.TABLES" |
|
| table spaces | "SYSCAT.TABLESPACES" |
|
| table spaces use privileges | "SYSCAT.TBSPACEAUTH" |
|
| trigger dependencies | "SYSCAT.TRIGDEP" |
|
| triggers | "SYSCAT.TRIGGERS" |
|
| type mapping | "SYSCAT.TYPEMAPPINGS" |
|
| user-defined functions | "SYSCAT.FUNCTIONS" |
|
| view dependencies | "SYSCAT.VIEWDEP" |
|
| views | "SYSCAT.TABLES" |
|
| "SYSCAT.VIEWS" |
| |
| wrapper options | "SYSCAT.WRAPOPTIONS" |
|
| wrappers | "SYSCAT.WRAPPERS" |
|