attributes of structured data types |
SYSCAT.ATTRIBUTES catalog view |
audit policies |
SYSCAT.AUDITPOLICIES catalog view |
SYSCAT.AUDITUSE catalog view |
authorities on database |
SYSCAT.DBAUTH catalog view |
buffer pool configuration on database partition group |
SYSCAT.BUFFERPOOLS catalog view |
buffer pool size on database partition |
SYSCAT.BUFFERPOOLDBPARTITIONS catalog view |
cast functions |
SYSCAT.CASTFUNCTIONS catalog view |
check constraints |
SYSCAT.CHECKS catalog view |
column privileges |
SYSCAT.COLAUTH catalog view |
columns |
SYSCAT.COLUMNS catalog view |
columns referenced by check constraints |
SYSCAT.COLCHECKS catalog view |
columns used in dimensions |
SYSCAT.COLUSE catalog view |
columns used in keys |
SYSCAT.KEYCOLUSE catalog view |
conditions |
SYSCAT.CONDITIONS catalog view |
constraint dependencies |
SYSCAT.CONSTDEP catalog view |
database partition group database partitions |
SYSCAT.DBPARTITIONGROUPDEF catalog view |
database partition group definitions |
SYSCAT.DBPARTITIONGROUPS catalog view |
data partitions |
SYSCAT.DATAPARTITIONEXPRESSION catalog view |
SYSCAT.DATAPARTITIONS catalog view |
data type dependencies |
SYSCAT.DATATYPEDEP catalog view |
data types |
SYSCAT.DATATYPES catalog view |
detailed column group statistics |
SYSCAT.COLGROUPCOLS catalog view |
SYSCAT.COLGROUPDIST catalog view |
SYSCAT.COLGROUPDISTCOUNTS catalog view |
SYSCAT.COLGROUPS catalog view |
detailed column options |
SYSCAT.COLOPTIONS catalog view |
detailed column statistics |
SYSCAT.COLDIST catalog view |
distribution maps |
SYSCAT.PARTITIONMAPS catalog view |
event monitor definitions |
SYSCAT.EVENTMONITORS catalog view |
events currently monitored |
SYSCAT.EVENTS catalog view |
SYSCAT.EVENTTABLES catalog view |
fields of row data types |
SYSCAT.ROWFIELDS catalog view |
function dependencies1 |
SYSCAT.ROUTINEDEP catalog view |
function mapping |
SYSCAT.FUNCMAPPINGS catalog view |
function mapping options |
SYSCAT.FUNCMAPOPTIONS catalog view |
function parameter mapping options |
SYSCAT.FUNCMAPPARMOPTIONS catalog view |
function parameters1 |
SYSCAT.ROUTINEPARMS catalog view |
functions1 |
SYSCAT.ROUTINES catalog view |
global variables |
SYSCAT.VARIABLEAUTH catalog view |
SYSCAT.VARIABLEDEP catalog view |
SYSCAT.VARIABLES catalog view |
hierarchies (types, tables, views) |
SYSCAT.HIERARCHIES catalog view |
SYSCAT.FULLHIERARCHIES catalog view |
identity columns |
SYSCAT.COLIDENTATTRIBUTES catalog view |
index columns |
SYSCAT.INDEXCOLUSE catalog view |
index data partitions |
SYSCAT.INDEXPARTITIONS catalog view |
index dependencies |
SYSCAT.INDEXDEP catalog view |
index exploitation |
SYSCAT.INDEXEXPLOITRULES catalog view |
index extension dependencies |
SYSCAT.INDEXEXTENSIONDEP catalog view |
index extension parameters |
SYSCAT.INDEXEXTENSIONPARMS catalog view |
index extension search methods |
SYSCAT.INDEXEXTENSIONMETHODS catalog view |
index extensions |
SYSCAT.INDEXEXTENSIONS catalog view |
index options |
SYSCAT.INDEXOPTIONS catalog view |
index privileges |
SYSCAT.INDEXAUTH catalog view |
indexes |
SYSCAT.INDEXES catalog view |
invalid objects |
SYSCAT.INVALIDOBJECTS catalog view |
method dependencies1 |
SYSCAT.ROUTINEDEP catalog view |
method parameters1 |
SYSCAT.ROUTINES catalog view |
methods1 |
SYSCAT.ROUTINES catalog view |
module objects |
SYSCAT.MODULEOBJECTS catalog view |
module privileges |
SYSCAT.MODULEAUTH catalog view |
modules |
SYSCAT.MODULES catalog view |
nicknames |
SYSCAT.NICKNAMES catalog view |
object mapping |
SYSCAT.NAMEMAPPINGS catalog view |
package dependencies |
SYSCAT.PACKAGEDEP catalog view |
package privileges |
SYSCAT.PACKAGEAUTH catalog view |
packages |
SYSCAT.PACKAGES catalog view |
partitioned tables |
SYSCAT.TABDETACHEDDEP catalog view |
pass-through privileges |
SYSCAT.PASSTHRUAUTH catalog view |
predicate specifications |
SYSCAT.PREDICATESPECS catalog view |
procedure options |
SYSCAT.ROUTINEOPTIONS catalog view |
procedure parameter options |
SYSCAT.ROUTINEPARMOPTIONS catalog view |
procedure parameters1 |
SYSCAT.ROUTINEPARMS catalog view |
procedures1 |
SYSCAT.ROUTINES catalog view |
protected tables |
SYSCAT.SECURITYLABELACCESS catalog view |
SYSCAT.SECURITYLABELCOMPONENTELEMENTS catalog view |
SYSCAT.SECURITYLABELCOMPONENTS catalog view |
SYSCAT.SECURITYLABELS catalog view |
SYSCAT.SECURITYPOLICIES catalog view |
SYSCAT.SECURITYPOLICYCOMPONENTRULES catalog view |
SYSCAT.SECURITYPOLICYEXEMPTIONS catalog view |
SYSCAT.SURROGATEAUTHIDS catalog view |
provides DB2® for z/OS® compatibility |
SYSIBM.SYSDUMMY1 catalog view |
referential constraints |
SYSCAT.REFERENCES catalog view |
remote table options |
SYSCAT.TABOPTIONS catalog view |
roles |
SYSCAT.ROLEAUTH catalog view |
SYSCAT.ROLES catalog view |
routine dependencies |
SYSCAT.ROUTINEDEP catalog view |
routine parameters1 |
SYSCAT.ROUTINEPARMS catalog view |
routine privileges |
SYSCAT.ROUTINEAUTH catalog view |
routines1 |
SYSCAT.ROUTINES catalog view |
SYSCAT.ROUTINESFEDERATED catalog view |
schema privileges |
SYSCAT.SCHEMAAUTH catalog view |
schemas |
SYSCAT.SCHEMATA catalog view |
sequence privileges |
SYSCAT.SEQUENCEAUTH catalog view |
sequences |
SYSCAT.SEQUENCES catalog view |
server options |
SYSCAT.SERVEROPTIONS catalog view |
server-specific user options |
SYSCAT.USEROPTIONS catalog view |
statements in packages |
SYSCAT.STATEMENTS catalog view |
procedures |
SYSCAT.ROUTINES catalog view |
system servers |
SYSCAT.SERVERS catalog view |
table constraints |
SYSCAT.TABCONST catalog view |
table dependencies |
SYSCAT.TABDEP catalog view |
table privileges |
SYSCAT.TABAUTH catalog view |
table space use privileges |
SYSCAT.TBSPACEAUTH catalog view |
table spaces |
SYSCAT.TABLESPACES catalog view |
tables |
SYSCAT.TABLES catalog view |
transforms |
SYSCAT.TRANSFORMS catalog view |
trigger dependencies |
SYSCAT.TRIGDEP catalog view |
triggers |
SYSCAT.TRIGGERS catalog view |
trusted contexts |
SYSCAT.CONTEXTATTRIBUTES catalog view |
SYSCAT.CONTEXTS catalog view |
type mapping |
SYSCAT.TYPEMAPPINGS catalog view |
user-defined functions |
SYSCAT.ROUTINES catalog view |
view dependencies |
SYSCAT.TABDEP catalog view |
views |
SYSCAT.TABLES catalog view |
SYSCAT.VIEWS catalog view |
workload management |
SYSCAT.HISTOGRAMTEMPLATEBINS catalog view |
SYSCAT.HISTOGRAMTEMPLATES catalog view |
SYSCAT.HISTOGRAMTEMPLATEUSE catalog view |
SYSCAT.SERVICECLASSES catalog view |
SYSCAT.THRESHOLDS catalog view |
SYSCAT.WORKACTIONS catalog view |
SYSCAT.WORKACTIONSETS catalog view |
SYSCAT.WORKCLASSES catalog view |
SYSCAT.WORKCLASSSETS catalog view |
SYSCAT.WORKLOADAUTH catalog view |
SYSCAT.WORKLOADCONNATTR catalog view |
SYSCAT.WORKLOADS catalog view |
wrapper options |
SYSCAT.WRAPOPTIONS catalog view |
wrappers |
SYSCAT.WRAPPERS catalog view |
XML strings |
SYSCAT.XMLSTRINGS catalog view |
XML values index |
SYSCAT.INDEXXMLPATTERNS catalog view |
XSR objects |
SYSCAT.XDBMAPGRAPHS catalog view |
SYSCAT.XDBMAPSHREDTREES catalog view |
SYSCAT.XSROBJECTAUTH catalog view |
SYSCAT.XSROBJECTCOMPONENTS catalog view |
SYSCAT.XSROBJECTDEP catalog view |
SYSCAT.XSROBJECTDETAILS catalog view |
SYSCAT.XSROBJECTHIERARCHIES catalog view |
SYSCAT.XSROBJECTS catalog view |
1 The
following catalog views for functions, methods, and procedures defined
in DB2 Version 7.1 and earlier
are still available: Functions: SYSCAT.FUNCTIONS, SYSCAT.FUNCDEP, SYSCAT.FUNCPARMS
Methods: SYSCAT.FUNCTIONS, SYSCAT.FUNCDEP, SYSCAT.FUNCPARMS
Procedures: SYSCAT.PROCEDURES, SYSCAT.PROCPARMS
However, these views have not been updated since DB2 Version 7.1. Use the SYSCAT.ROUTINES,
SYSCAT.ROUTINEDEP, or SYSCAT.ROUTINEPARMS catalog view instead. |