IBM Books

Administration Guide


"Roadmap" to Catalog Views


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"


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]