Db2 catalog tables
Db2 for z/OS maintains a set of tables (in database DSNDB06) called the Db2 catalog.
About these topics
These topics describe that catalog by describing the columns of each catalog table.
The catalog tables describe such things as table spaces, tables, columns, indexes, privileges, application plans, and packages. Authorized users can query the catalog; however, it is primarily intended for use by Db2 and is therefore subject to change. All catalog tables are qualified by SYSIBM. Do not use this qualifier for user-defined tables.
The catalog tables are updated by Db2 during normal operations in response to certain SQL statements, commands, and utilities.
Db2 12 catalog levels
The catalog level of a data sharing group or subsystem indicates that a particular CATMAINT utility UPDATE LEVEL job was run on the Db2 catalog, and the data sharing group or Db2 subsystem is ready for the activation of certain function levels.
- V12R1M509
- V12R1M507
- V12R1M505
- V12R1M503
- V12R1M502
- V12R1M500
For a summary of the changes, see Catalog changes in Db2 12.
Trailing blanks in converted catalog columns
Db2 subsystems that were migrated from earlier releases might have trailing blanks in catalog table columns that were converted from fixed to varying length data types. You might need to make adjustments in applications that use these columns in comparisons. For more information, see Trailing blanks in Db2 catalog columns.
Release indicators in the Db2 catalog
Some objects depend on functions in particular releases of Db2. If you are running on a release of Db2 and fall back to a previous release, an object that depends on the more recent release becomes frozen. The object is marked with a release dependency indicator and is unavailable until remigration.
The release dependency indicator, which is listed in the IBMREQD, RELCREATED, and RELBOUND columns of the catalog tables, shows the release of Db2 upon which the objects depend.
Db2 release dependency indicators in the IBMREQD, RELCREATED, and RELBOUND columns might use the following values:
Values | Meanings for IBMREQD, RELCREATED, and RELBOUND columns |
---|---|
R | Db2 13 |
Q | Db2 12 |
P | Db2 11 |
O | DB2 10 |
M | DB2 9 |
L | DB2 version 8 |
K | DB2 version 7 |
J | DB2 version 6 |
I | DB2 version 6 |
H | DB2 version 5 |
G | DB2 version 4 |
F | DB2 version 3R1 |
E | DB2 version 2R3 |
D | DB2 version 2R2 |
C | DB2 version 2R1 |
B | DB2 version 1R3 |
Y | Rows with IBMREQD='Y' were provided with the Db2 for z/OS product code |
N | Rows with IBMREQD='N' have no release dependency and were not provided with the Db2 for z/OS product code |
Programming interface information
Not all catalog table columns are part of the general-use programming interface. Whether a column is part of this interface is indicated in a column labeled Use
in the table that describes the column. The meanings of the Use column values are shown in the following table.
Use column value | Meaning |
---|---|
G | Column is part of the general-use programming interface |
S | Column is part of the product-sensitive interface |
I | Column is for internal use only |
N | Column is not used |
For columns with N or I in the Use column, the name of the column and its description might not appear in the explanation of the column.
For more information about programming interface information, see Programming interface information.
Db2 catalog tables, table spaces, and indexes
Table | Table space | Indexes (Type2 ) | Description |
---|---|---|---|
IPLIST | SYSDDF | DSNDUX01 (U) | Contains a row for each IP address that corresponds to a remote DRDA server |
IPNAMES | SYSDDF | DSNFPX01 (UC) | Contains a row for each remote DRDA server that Db2 can access using TCP/IP |
LOCATIONS | SYSDDF | DSNFCX01 (UC) | Contains a row for every accessible remote server |
LULIST | SYSDDF |
DSNFLX01
DSNFLX02 |
Contains a row for each real LU name that is associated with the dummy LU name for a data sharing group |
LUMODES | SYSDDF | DSNFMX01 (UC) | Contains a row for the conversation limit for each combination of LU name and VTAM® logon mode description |
LUNAMES | SYSDDF | DSNFNX01 (UC) | Contains a row for each remote SNA client or server |
MODESELECT | SYSDDF | DSNFDX01 (UC) | Contains a row for each VTAM logon mode and combination of authorization ID, plan name, and LU name |
SYSAUDITPOLICIES | SYSTSADT | DSNAPX03 (UC) | Each row represents an audit policy. |
SYSAUDITPOLICIES_H | SYSTSADH | — | Not used |
SYSAUTOALERTS | SYSTSATS |
DSNALX01 (UC)
DSNALX02 (N) DSNALX03 (N) DSNALX04 (N) DSNALX05 (N) DSNALX06 (N) |
Contains a row for each recommendation from the autonomic procedures |
SYSAUTOALERTS_OUT | SYSTSATX | DSNALX07 (A) | Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTOALERTS |
SYSAUTORUNS_HIST | SYSTSPRH |
DSNPHX01 (UC)
DSNPHX02 (N) DSNPHX03 (N) |
Contains a row for each execution of an autonomic procedure. |
SYSAUTORUNS_HISTOU | SYSTSPHX | DSNPHX04 (A) | Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTORUNS_HIST |
SYSAUTOTIMEWINDOWS | SYSTSATW | DSNTWX01 (UC) | Contains a row for each time period during which autonomic procedures can be run |
SYSAUXRELS | SYSTSAUX |
DSNOXX01 (NC)
DSNOXX02 (N) |
Contains one row for each auxiliary table for a LOB column |
SYSCHECKDEP | SYSTSCKD | DSNSDX01 (UC) | Contains one row for each reference to a column in a table check constraint |
SYSCHECKS2 | SYSTSCHX | DSNCHX01 (UC) | Contains one row for each table check constraint |
SYSCHECKS | SYSTSCKS | DSNSCX01 (UC) | Contains one row for each table check constraint |
SYSCOLAUTH | SYSTSFAU |
DSNACX01 (N)
DSNACX02 (N) DSNACX03 (N) DSNACX04 (N) |
Records the UPDATE privileges that are held by users on individual columns of a table or view |
SYSCOLAUTH_H | SYSTSFAH | — | Not used |
SYSCOLDIST | SYSSTATS | DSNTNX01 (NC) | Contains cardinality, frequency, and histogram statistics for a single column or a column group. |
SYSCOLDIST_HIST | SYSHIST | DSNHFX01 (N) | Contains accumulated rows from SYSCOLDIST |
SYSCOLDISTSTATS | SYSSTATS | DSNTPX01 (NC) | Contains cardinality, frequency, and histogram statistics for a single column or a column group. Each partition can have 0 or more rows. |
SYSCOLSTATS | SYSSTATS | DSNTCX01 (NC) | Contains partition statistics for selected columns. Each column contains a row for each partition in the table |
SYSCOLUMNS | SYSTSCOL |
DSNDCX01 (U)
DSNDCX02 (N) DSNDCX05 (N) DSNDCX06 (N) |
Contains one row for every column of each table and view |
SYSCOLUMNS_HIST | SYSHIST | DSNHEX01 (N) | Contains accumulated rows from SYSCOLUMNS |
SYSCONSTDEP | SYSTSCON |
DSNCCX01 (N)
DSNCCX02 (N) |
Records dependencies on check constraints or user-defined defaults for a column |
SYSCONTEXTAUTHIDS | SYSCONTX |
DSNCDX01 (UC)
DSNCDX02 (N) |
Contains the authorization ID under which a trusted context can be used. |
SYSCONTEXTAUTHID_H | SYSTSCXH | — | Not used |
SYSCONTEXT | SYSCONTX |
DSNCTX01 (UC)
DSNCTX02 (U) DSNCTX03 (U) DSNCTX04 (N) |
Contains one row for each trusted context. |
SYSCONTEXT_H | SYSTSCNH | — | Not used |
SYSCONTROLS | SYSTSCTL |
DSNCLX01 (U)
DSNCLX02 (U) DSNCLX03 (N) DSNCLX04 (N) DSNCLX05 (N) |
Contains one row for each row permission and column mask. |
SYSCONTROLS_DESC | SYSTSCTD | DSNTRX02 (A) | Contains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLS |
SYSCONTROLS_DESC_H | SYSTSCHD | DSNTRX04 (A) | Contains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLS_H |
SYSCONTROLS_RTXT | SYSTSCTR | DSNTRX01 (A) | Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS. |
SYSCONTROLS_RTXT_H | SYSTSCHR | DSNTRX03 (A) | Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS_H |
SYSCOPY | SYSTSCPY |
DSNUCH01 (N)
DSNUCX01 (N) |
Contains information that is needed for recovery |
SYSCTXTTRUSTATTRS | SYSCONTX | DSNCAX01 (UC) | Contains the attributes for a given trusted context |
SYSCTXTTRUSTATTR_H | SYSTSTAH | Not used | |
SYSDATABASE | SYSTSDBA |
DSNDDH01 (U)
DSNDDX02 (N) |
Contains one row for each database, except for database DSNDB01 |
SYSDATATYPES | SYSTSDAT |
DSNODX01 (U)
DSNODX02 (U) |
Contains one row for each distinct data type |
SYSDBAUTH | SYSTSDBU |
DSNADH01 (N)
DSNADX01 (N) DSNADH02 (N) |
Records the privileges held by users over databases |
SYSDBAUTH_H | SYSTSDBH | — | Not used |
SYSDBRM | SYSTSDBR |
DSNDBX01 (N)
DSNDBX02 (U) |
Contains one row for each DBRM of each application plan |
SYSDEPENDENCIES | SYSTSDEP |
DSNONX01 (U)
DSNONX02 (N) |
Records the dependencies between objects |
SYSDUMMY1 | SYSEBCDC | — | Contains one row. This table is used by SQL statements that do not use any tables but must specify a table name. |
SYSDUMMYA | SYSTSASC | — | Contains one row and is used for SQL statements in which a table reference is required, but the contents of the table are not important. SYSTSASC is an ASCII table space. |
SYSDUMMYE | SYSEBCDC | — | Contains one row and is used for SQL statements in which a table reference is required, but the contents of the table are not important. SYSEBCDIC is an EBCDIC table space. |
SYSDUMMYU | SYSTSUNI | — | Contains one row and is used for SQL statements in which a table reference is required, but the contents of the table are not important. SYSTSUNI is a UNICODE table space. |
SYSDYNQRY | SYSTSDQY |
DSNDQX01 (U)
DSNDQX02 (UC) DSNDQX11 (U) |
Contains one row for each stabilized dynamic query. |
SYSDYNQRYDEP | SYSTSDQD |
DSNDQX03 (N)
DSNDQX04 (N) DSNDQX05 (N) DSNDQX12 (N) |
Records the dependencies of stabilized dynamic queries. |
SYSDYNQRY_EXPL | SYSTSDQE | DSNDQX08 (A) | Internal use for stabilized dynamic queries. |
SYSDYNQRY_OPL | SYSTSDQO | DSNDQX10 (A) | Internal use for stabilized dynamic queries. |
SYSDYNQRY_SHTEL | SYSTSDQH | DSNDQX09 (A) | Internal use for stabilized dynamic queries. |
SYSDYNQRY_SPAL | SYSTSDQS | DSNDQX07 (A) | Internal use for stabilized dynamic queries. |
SYSDYNQRY_TXTL | SYSTSDQT | DSNDQX06 (A) | Internal use for stabilized dynamic queries. |
SYSENVIRONMENT | SYSTSENV | DSNOEX01 (U) | Records the environment variables when an object is created |
SYSFIELDS | SYSTSFLD | DSNDFX01 (N) | Contains one row for every column that has a field procedure |
SYSFOREIGNKEYS | SYSTSFOR | DSNDRH01 (N) | Contains one row for every column of every foreign key |
SYSINDEXCLEANUP | SYSTSIXC | DSNICX01 (N) | Contains time window data to control index cleanup processing. |
SYSINDEXCONTROL | SYSTSICO | Contains rows that specify time windows to control the use of memory allocated for an index. | |
SYSINDEXES | SYSTSIXS |
DSNDXX01 (U)
DSNDXX02 (U) DSNDXX03 (U) DSNDXX04 (N) DSNDXX07 |
Contains one row for every index |
SYSINDEXES_RTSECT | SYSTSIXR | DSNDXX06 (A) | Contains the LOB data for the RTSECTION column of SYSIBM.SYSINDEXES. |
SYSINDEXES_TREE | SYSTSIXT | DSNDXX05 (A) | Contains the LOB data for the PARSETREE column of SYSIBM.SYSINDEXES. |
SYSINDEXES_HIST | SYSHIST |
DSNHHX01 (NC)
DSNHHX02 (N) |
Contains accumulated rows from SYSINDEXES |
SYSINDEXPART | SYSTSIPT |
DSNDRX01 (U)
DSNDRX02 (N) DSNDRX03 (N) |
Contains one row for each nonpartitioned index and one row for each partition of a partitioning index or DPSI |
SYSINDEXPART_HIST | SYSHIST | DSNHGX01 (N) | Contains accumulated rows from SYSINDEXPART |
SYSINDEXSPACESTATS | SYSTSISS |
DSNRTX02 (U)
DSNRTX03 (N) |
Contains Real-time Statistics for index spaces. |
SYSIXSPACESTATS_H | SYSTSISH | A history table for temporal versioning of the SYSINDEXSPACESTATS catalog table table. For more information, see Temporal versioning for Db2 statistics-related catalog tables. | |
SYSINDEXSTATS | SYSSTATS | DSNTXX01 (UC) | Contains one row for each partition of a partitioning index or data-partitioned secondary index (DPSI) |
SYSINDEXSTATS_HIST | SYSHIST | DSNHIX01 (NC) | Contains accumulated rows from SYSINDEXSTATS |
SYSJARCLASS_SOURCE | SYSJAUXB | DSNJSX01 (A) | Contains the source code for a Java™ stored procedure |
SYSJARCONTENTS | SYSJAVA | DSNJCX01 (NC) | Records the classes for each JAR file for a Java stored procedure |
SYSJARDATA | SYSJAUXA | DSNJDX01 (A) | Contains the contents of the JAR file for each Java stored procedure |
SYSJAROBJECTS | SYSJAVA | DSNJOX01 (UC) | Records the contents of each JAR file for a Java stored procedure |
SYSJAVAOPTS | SYSJAVA | DSNJVX01 (UC) | Records the build options for a Java stored procedure |
SYSJAVAPATHS | SYSJAVA |
DSNJPX01 (U)
DSNJPX02 (N) |
Contains the complete JAR class resolution path, and records the dependencies that one JAR has on the JARs in its Java path. |
SYSKEYS | SYSTSKEY |
DSNDKX01 (U)
DSNDKX02 (N) DSNDKX03 (U) |
Contains one row for each column of an index key |
SYSKEYCOLUSE | SYSTSKYC | DSNCUX01 (N) | Contains a row for every column in a unique constraint (primary key or unique key) |
SYSKEYTARGETS | SYSTARG |
DSNRKX01 (UC)
DSNRKX02 (N) |
Contains one row for each key-target participating in an extended index definition |
SYSKEYTARGETS_HIST | SYSHIST | DSNHKX01 (N) | Contains accumulated rows from SYSKEYTARGETS |
SYSKEYTARGETSTATS | SYSSTATS | DSNTKX01 (U) | Contains partition statistics for selected key-targets |
SYSKEYTGTDIST | SYSSTATS | DSNTDX01 (N) | Contains one or more rows for the first key-target of an extended index key |
SYSKEYTGTDIST_HIST | SYSHIST | DSNTDX02 (N) | Contains accumulated rows from SYSKEYTGTDIST |
SYSKEYTGTDISTSTATS | SYSSTATS | DSNTSX01 (N) | Contains zero or more rows per partition for the first key-target of a data-partitioned secondary index (DPSI) |
SYSLEVELUPDATES | SYSTSLVH |
DSNLVX01 (N)
DSNLVX02 (N) |
Contains information about the function levels, catalog levels, and code levels of the Db2 subsystem or data sharing group. |
SYSLOBSTATS | SYSSTATS | DSNLNX01 (UC) | Contains one row for each LOB table space |
SYSLOBSTATS_HIST | SYSHIST | DSNHJX01 (NC) | Contains accumulated rows from SYSLOBSTATS |
SYSOBDS 1 | SYSALTER |
DSNDOB01 (N)
DSNDOB02 (N) |
Contains one row for each table space or index that can be recovered to an image copy that was made before the first version was generated. Important: Do not manipulate data in the SYSIBM.SYSOBDS catalog table, except at the direction of IBM Support.
|
SYSOBD_AUX 1 | SYSTSOBX | DSNOB03 (A) | Contains the LOB data for the OBD_IMAGE column of SYSIBM.SYSOBDS. |
SYSOBJROLEDEP | SYSROLES |
DSNRDX01 (UC)
DSNRDX02 (N) |
Contains one row for each dependent role |
SYSPACKAGE | SYSTSPKG |
DSNKKX01 (U)
DSNKKX02 (U) |
Contains one row for each package |
SYSPACKAUTH | SYSTSPKA |
DSNKAX01 (N)
DSNKAX02 (N) DSNKAX03 (N) |
Contains the privileges that are held by users over packages |
SYSPACKAUTH_H | SYSTSPKH | — | Not used |
SYSPACKCOPY | SYSTSPKC | DSNPCX01 (UC) | |
SYSPACKDEP | SYSTSPKD |
DSNKDX01 (N)
DSNKDX02 (N) DSNKDX03 (N) |
Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, and triggers |
SYSPACKLIST | SYSTSPKL |
DSNKLX01 (N)
DSNKLX02 (U) |
Contains one row for every package list entry for a plan |
SYSPACKSTMT | SYSTSPKS | DSNKSX01 (UC) | Contains one row for every SQL statement that belongs to a package |
SYSPACKSTMT_STMB | SYSTSPVR | DSNKSX02 (A) | Contains the LOB data for the STMTBLOB column of SYSIBM.SYSPACKSTMT. |
SYSPACKSTMT_STMT | SYSTSPKX | DSNPKX01 (A) | Contains the LOB data for the STATEMENT column of SYSIBM.SYSPACKSTMT. |
SYSPARMS | SYSTSPRM |
DSNOPX01 (U)
DSNOPX02 (N) DSNOPX03 (N) DSNOPX04 (N) |
Contains a row for each parameter of a routine or a row for each column of a table that is passed as a parameter to a routine |
SYSPENDINGDDL | SYSTSPEN |
DSNPDX01 (N)
DSNPDX02 (N) |
Contains information about which objects have pending definition changes. The entries exist only during the window between when the pending option is run and when the utility materializes these pending options. |
SYSPENDINGDDLTEXT | SYSTSPDT | DSNPDX03 (A) | Contains the LOB data for the STATEMENT_TEXT column of SYSIBM.SYSPENDINGDDL. |
SYSPENDINGOBJECTS | SYSTSPDO |
DSNPOX01 (N)
DSNPOX02 (N) DSNPOX03 (N) |
Contains name and OBID information about the pending-CREATE objects, whose data sets are created but object definitions have not been materialized to the real catalog. |
SYSPKSYSTEM | SYSTSPKY | DSNKYX01 (N) | Contain one row of system information for each package |
SYSPLAN | SYSTSPLN |
DSNPPH01 (U)
|
Contains one row for each application plan |
SYSPLANAUTH | SYSTSPLA |
DSNAPH01 (N)
DSNAPX01 (N) DSNAPX02 (N) |
Records the privileges that are held by users over application plans |
SYSPLANAUTH_H | SYSTSPLH | — | Not used |
SYSPLANDEP | SYSTSPLD |
DSNGGX01 (N)
DSNGGX05 (N) |
Records the dependencies of plans on tables, views, aliases, synonyms, table spaces, and indexes |
SYSPLSYSTEM | SYSTSPLY | DSNKPX01 (N) | Contains one row of system information for each plan |
SYSQUERY | SYSTSQRY |
DSNQYX01 (N)
DSNQYX02 (U) DSNQYX03 (N) DSNQYX04 (N) |
Contains a set of queries |
SYSQUERY_AUX | SYSTSQRA | DSNQSX01 (A) | Contains the LOB data for the STMTTEXT column of SYSIBM.SYSQUERY |
SYSQUERYOPTS | SYSTSQRO | DSNQPX01 (N) | Contains optimization parameters for the queries in SYSIBM.SYSQUERY. |
SYSQUERYPLAN | SYSTSQRP | DSNQNX01 (N) | Contains the plan hint information for the queries in the SYSIBM.SYSQUERY table |
SYSQUERYPREDICATE | SYSTSQRE |
DSNQEX01 (UC)
DSNQEX02 (N) |
Contains rows that describe the predicates within a query. Rows are added to this table by using the BIND QUERY command. Rows are removed from this table by using the FREE QUERY command. |
SYSQUERYSEL | SYSTSQRS | — | Contains rows that describe the selectivity of predicates. Rows are added to this table by using the BIND QUERY command. Rows are removed from this table by using the FREE QUERY command. |
SYSRELS | SYSTSREL |
DSNDLX01 (N)
DSNDLX02 (N) DSNDLX03 (N) DSNDLX04 (U) |
Contains one row for every relationship |
SYSRESAUTH | SYSGPAUT |
DSNAGH01 (N)
DSNAGX01 (N) |
Records the privileges that are held by users over buffer pools, storage groups, table spaces, and collections |
SYSRESAUTH_H | SYSTSAUH | — | Not used |
SYSROLES | SYSROLES | DSNRLX01 (UC) | Contains one row for each role |
SYSROUTINES | SYSTSROU |
DSNOFX01 (U)
DSNOFX02 (U) DSNOFX03 (N) DSNOFX04 (U) DSNOFX05 (N) DSNOFX06 (N) DSNOFX07 (U) DSNOFX08 (N) |
Contains a row for every routine |
SYSROUTINESTEXT | SYSPLUXA | DSNPLX01 (A) | Contains LOB data for the column SYSIBM.SYSROUTINES.TEXT |
SYSROUTINES_TREE | SYSPLUXB | DSNPLX02 (A) | Contains the LOB data for the PARSETREE column of SYSIBM.SYSROUTINES. |
SYSROUTINEAUTH | SYSTSRAU |
DSNOAX01 (N)
DSNOAX02 (U) DSNOAX03 (N) |
Records the privileges that users hold on routines |
SYSROUTINEAUTH_H | SYSTSRAH | — | Not used |
SYSROUTINES_OPTS | SYSGRTNS | DSNROX01 (UC) | Contains one row to record the build options for each generated routine |
SYSROUTINES_SRC | SYSGRTNS |
DSNRSX01 (N)
DSNRSX02 (U) |
Contains one or more rows for the source code for each generated routine |
SYSSCHEMAAUTH | SYSTSSCM |
DSNSKX01 (N)
DSNSKX02 (N) |
Contains one or more rows for each grantee of a privilege on a schema |
SYSSCHEMAAUTH_H | SYSTSSCH | — | Not used |
SYSSEQUENCEAUTH | SYSSEQ2 |
DSNWCX01 (N)
DSNWCX02 (N) DSNWCX03 (N) |
Records the privileges that users hold on sequences |
SYSSEQUENCEAUTH_H | SYSTSSAH | — | Not used |
SYSSEQUENCES | SYSSEQ |
DSNSQX01 (U)
DSNSQX02 (UD) DSNSQX03 (N) |
Contains one row for each identity column or user-defined sequence. |
SYSSEQUENCESDEP | SYSSEQ2 |
DSNSRX01 (N)
DSNSRX02 (N) |
Records the dependencies of identity columns on the corresponding entries in SYSIBM.SYSSEQUENCES |
SYSSESSION | SYSTSSES | DSNSNX02 (N) | Contains session tokens that are generated by the server and associated session data. |
SYSSESSION_EX | SYSTSSNX |
DSNSNX04 (U)
DSNSNX05 (U) |
Contains the global variable data of LOB or array type that corresponds to the locator stored in the GLOBAL_VARIABLES column of SYSSESSION table. |
SYSSESSION_GV | SYSTSSNL | DSNSNX01 (U) | Contains the LOB data for the GLOBAL_VARIABLES column of SYSIBM.SYSSESSION table. |
SYSSESSION_DATA | SYSTSSXL | DSNSNX03 (U) | Contains LOB data for the DATA column of the SYSSESSION_EX table. |
SYSSESSION_STATUS | SYSTSSTA | DSNSNX06 (U) | Contains the session token and timestamp value when the corresponding session data was last referenced. |
SYSSTATFEEDBACK | SYSTSSFB | DSNSFX01 (UC) | Contains one row for every missing or conflicting statistic that is identified during query optimization. |
SYSSTMT | SYSTSSTM |
DSNPSX01 (N)
DSNPSX02 (N) |
Contains one or more rows for each SQL statement of each DBRM |
SYSSTOGROUP | SYSTSSTG | DSNSSH01 (U) | Contains one row for each storage group |
SYSSTRINGS | SYSTSSRG | DSNSSX01 (U) | Contains information necessary to perform string translations |
SYSSYNONYMS | SYSTSSYN |
DSNDYX01 (U)
DSNDYX02 (N) |
Contains one row for each synonym of a table or view |
SYSTABAUTH | SYSTSTAU |
DSNATX01 (N)
DSNATX02 (N) DSNATX03 (N) DSNATX04 (N) DSNATX05 (U) |
Records the privileges that are held by users on tables, views, and triggers |
SYSTABAUTH_H | SYSTSTBH | — | Not used |
SYSTABCONST | SYSTSTBC |
DSNCNX01 (U)
DSNCNX02 (N) |
Contains one row for each unique constraint that was created in Db2 for z/OS DB2 version 7 or later |
SYSTABLES | SYSTSTAB |
DSNDTX01 (U)
DSNDTX02 (N) DSNDTX03 (N) DSNDTX05 |
Contains one row for each table, view, and alias |
SYSTABLES_HIST | SYSHIST | DSNHDX01 (N) | Contains accumulated rows from SYSTABLES |
SYSTABLES_PROFILES | SYSTSTPF | DSNPRX01 (UC) | Contains a row for each profile that is associated with a table in SYSIBM.SYSTABLES |
SYSTABLES_PROFILE_TEXT | SYSTSPTX | DSNPRX02 (UC) | Contains the LOB data for the PROFILE_TEXT column of SYSIBM.SYSTABLES_PROFILES |
SYSTABLEPART | SYSTSTPT |
DSNDPX01 (U)
DSNDPX02 (N) DSNDPX03 (N) DSNDPX04 (N) DSNDPX05 (N) |
Contains one row for each nonpartitioned table space and one row for each partition of a partitioned table space |
SYSTABLEPART_HIST | SYSHIST | DSNHCX01 (N) | Contains accumulated rows from SYSTABLEPART |
SYSTABLESPACE | SYSTSTSP | DSNDSX01 (U) | Contains one row for each table space |
SYSTABLESPACESTATS | SYSTSTSS | DSNRTX01 (U) | Contains Real Time Statistics for table spaces. |
SYSTABSPACESTATS_H | SYSTSTSH | A history table for temporal versioning of the SYSTABLESPACESTATS catalog table table. For more information, see Temporal versioning for Db2 statistics-related catalog tables. | |
SYSTABSTATS | SYSSTATS |
DSNTTX01 (U)
DSNTTX02 (N) |
Contains one row for each partition of a partitioned table space and no rows for nonpartitioned table spaces |
SYSTABSTATS_HIST | SYSHIST | DSNHBX01 (NC) | Contains accumulated rows from SYSTABSTATS |
SYSTRIGGERS | SYSTSTRG |
DSNOTX01 (UC)
DSNOTX02 (N) DSNOTX03 (N) |
Contains one row for each trigger |
SYSTRIGGERS_STMT | SYSTSTRT | DSNOTX04 (A) | Contains the LOB data for the STATEMENT column of SYSIBM.SYSTRIGGERS |
SYSUSERAUTH | SYSUSER |
DSNAUH01 (N)
DSNAUX02 (N) |
Records the system privileges that are held by users |
SYSUSERAUTH_H | SYSTSUAH | — | Not used |
SYSVARIABLEAUTH | SYSTSVAU |
DSNVAX01 (N)
DSNVAX02 (N) DSNVAX03 (N) |
Contains one row for each authorization ID that has privileges for each global variable. |
SYSVARIABLES | SYSTSVAR |
DSNOVX01 (U)
|
Contains one row for each global variable that has been created. |
SYSVARIABLES_DESC | SYSTSVAD | DSNOVX03 (A) | Contains the LOB data for the DESCRIPTOR column of SYSIBM.SYSVARIABLES. |
SYSVARIABLES_TEXT | SYSTSVAT | DSNOVX02 (A) | Contains the LOB data for the DEFAULTTEXT column of SYSIBM.SYSVARIABLES. |
SYSVIEWS | SYSTSVEW | DSNVVX01 (U) | Contains one or more rows for each view |
SYSVIEWS_STMT | SYSTSVWT | DSNVWX01 (A) | Contains the LOB data for the STATEMENT column of SYSIBM.SYSVIEWS |
SYSVIEWS_TREE | SYSTSVTR | DSNVWX02 (A) | Contains the LOB data for the PARSETREE column of SYSIBM.SYSVIEWS |
SYSVIEWDEP | SYSTSVWD |
DSNGGX02 (N)
DSNGGX03 (N) DSNGGX04 (N) DSNGGX06 |
Records the dependencies of views on tables and other views |
SYSVIEWDEP_H | SYSTSVDH | — | Not used. |
SYSVOLUMES | SYSTSVOL | DSNSSH02 (N) | Contains one row for each volume of each storage group |
SYSXMLRELS | SYSXML |
DSNXRX01 (N)
DSNXRX02 (N) |
Contains one row for each XML table that is created for an XML column |
SYSXMLSTRINGS | SYSXML |
DSNXSX01 (UC)
DSNXSX02 (U) |
Each row holds a single string and its unique ID. They are used to condense XML data. The string can be an element name, attribute name, name space prefix, or a name space URI. |
SYSXMLTYPMOD | SYSTSXTM | DSNTMX01 (U) | Contains rows about the XML type modifiers of XML columns. Rows in this table can be inserted, updated, and deleted. |
SYSXMLTYPMSCHEMA | SYSTSXTS |
DSNMSX01 (U)
DSNMSX02 (N) |
Contain rows about XML schemas for the XML type modifiers that are stored in SYSXMLTYPMOD. Each row contains one XML schema specification for one XML type modifier. Rows in this table can be inserted, updated, and deleted. |
USERNAMES | SYSDDF | DSNFEX01 (U) | Contains a row for each authorization ID to be translated or checked as it is sent to or from this Db2 |
- Descriptions of the SYSIBM.SYSOBDS and SYSIBM.SYSOBD_AUX catalog tables are available only to users who work in enterprises with a Db2 12 license. For more information see
Internal catalog table formats
in Advanced diagnostic information for Db2 12 for z/OS. - The following index types are indicated:
- A
- Auxiliary
- N
- Nonunique
- U
- Unique
- UC
- Unique clustering
- UD
- Unique descending
Where to find PDF format and online content
The following table shows where to find the PDF format and online content from this section of the Db2 for z/OS product documentation.
PDF Manuals | Where to find the online content |
---|---|
SQL Reference |