| Description | Catalog View | Page |
|---|---|---|
| attributes of structured data types | "OBJCAT.ATTRIBUTES" | "OBJCAT.ATTRIBUTES" |
| authorities on database | OBJCAT.DBAUTH (92) | "SYSCAT.DBAUTH" |
| Buffer pool configuration on nodegroup | OBJCAT.BUFFERPOOLS (92) | "SYSCAT.BUFFERPOOLS" |
| Buffer pool size on node | OBJCAT.BUFFERPOOLSNODE (92) | "SYSCAT.BUFFERPOOLNODES" |
| check constraints | "OBJCAT.CHECKS" | "OBJCAT.CHECKS" |
| column privileges | OBJCAT.COLAUTH (92) | "SYSCAT.COLAUTH" |
| columns | "OBJCAT.COLUMNS" | "OBJCAT.COLUMNS" |
| columns referenced by check constraints | "OBJCAT.COLCHECKS" | "OBJCAT.COLCHECKS" |
| columns used in keys | "OBJCAT.KEYCOLUSE" | "OBJCAT.KEYCOLUSE" |
| constraint dependencies | "OBJCAT.CONSTDEP" | "OBJCAT.CONSTDEP" |
| datatypes | "OBJCAT.DATATYPES" | "OBJCAT.DATATYPES" |
| event monitor definitions | OBJCAT.EVENTMONITORS (92) | "SYSCAT.EVENTMONITORS" |
| events currently monitored | OBJCAT.EVENTS (92) | "SYSCAT.EVENTS" |
| function parameters | "OBJCAT.FUNCPARMS" | "OBJCAT.FUNCPARMS" |
| hierarchies (types, tables, views) | "OBJCAT.HIERARCHIES" | "OBJCAT.HIERARCHIES" |
| indexes | "OBJCAT.INDEXES" | "OBJCAT.INDEXES" |
| detailed column statistics | OBJCAT.COLDIST (92) | "SYSCAT.COLDIST" |
| nodegroup definitions | OBJCAT.NODEGROUPS (92) | "SYSCAT.NODEGROUPS" |
| nodegroup nodes | OBJCAT.NODEGROUPDEF (92) | "SYSCAT.NODEGROUPDEF" |
| partitioning maps | OBJCAT.PARTITIONMAPS (92) | "SYSCAT.PARTITIONMAPS" |
| package dependencies | "OBJCAT.PACKAGEDEP" | "OBJCAT.PACKAGEDEP" |
| package privileges | OBJCAT.PACKAGEAUTH (92) | "SYSCAT.PACKAGEAUTH" |
| packages | OBJCAT.PACKAGES (92) | "SYSCAT.PACKAGES" |
| stored procedures | OBJCAT.PROCEDURES (92) | "SYSCAT.PROCEDURES" |
| procedure parameters | OBJCAT.PROCPARMS (92) | "SYSCAT.PROCPARMS" |
| referential constraints | "OBJCAT.REFERENCES" | "OBJCAT.REFERENCES" |
| schema privileges | OBJCAT.SCHEMAAUTH (92) | "SYSCAT.SCHEMAAUTH" |
| schemas | OBJCAT.SCHEMATA (92) | "SYSCAT.SCHEMATA" |
| statements in packages | OBJCAT.STATEMENTS (92) | "SYSCAT.STATEMENTS" |
| table constraints | "OBJCAT.TABCONST" | "OBJCAT.TABCONST" |
| table privileges | OBJCAT.TABAUTH (92) | "SYSCAT.TABAUTH" |
| tables | "OBJCAT.TABLES" | "OBJCAT.TABLES" |
| table spaces | OBJCAT.TABLESPACES (92) | "SYSCAT.TABLESPACES" |
| trigger dependencies | "OBJCAT.TRIGDEP" | "OBJCAT.TRIGDEP" |
| triggers | "OBJCAT.TRIGGERS" | "OBJCAT.TRIGGERS" |
| user-defined functions | "OBJCAT.FUNCTIONS" | "OBJCAT.FUNCTIONS" |
| view dependencies | "OBJCAT.VIEWDEP" | "OBJCAT.VIEWDEP" |
| views | OBJCAT.TABLES | "OBJCAT.TABLES" |
| OBJCAT.VIEWS (92) | "SYSCAT.VIEWS" |
(92) The column definition of these catalog views is identical to their SYSCAT counterparts of the same name. The page reference points to the SYSCAT catalog views for the column definitions.