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