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