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.
Additional information
Release dependency indicators: 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. 
Important: The IBMREQD column is not a reliable indicator for indicating
release dependencies. Where possible, the RELCREATED and RELBOUND columns should be used
instead.
The IBMREQD column is not a reliable indicator for indicating
release dependencies. Where possible, the RELCREATED and RELBOUND columns should be used
instead.Release dependency indicators in IBMREQD, RELCREATED, and RELBOUND are defined by
the following values:
- Value
- Meaning
- B
- Version 1R3 dependency indicator, not from the machine-readable material (MRM) tape
- C
- Version 2R1 dependency indicator, not from MRM tape
- D
- Version 2R2 dependency indicator, not from MRM tape
- E
- Version 2R3 dependency indicator, not from MRM tape
- F
- Version 3R1 dependency indicator, not from MRM tape
- G
- Version 4 dependency indicator, not from MRM tape
- H
- Version 5 dependency indicator, not from MRM tape
- I
- Version 6 dependency indicator, not from MRM tape
- J
- Version 6 dependency indicator, not from MRM tape
- K
- DB2 Version 7 dependency indicator, not from MRM tape
- L
- DB2 Version 8 dependency indicator, not from MRM tape
- M
- DB2 9 dependency indicator, not from MRM tape
- O
- DB2 10 dependency indicator, not from
MRM tape
- N
- Not from MRM tape, no dependency
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 values that "Use" can assume are as follows:
- 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 for which "Use" is N or I, the name of the column and its description do not appear in the explanation of the column.
| Table space | Table | Indexes (Type2 ) | Description |
|---|---|---|---|
| SYSALTER | SYSOBDS
1 |
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 Software Support. |
| SYSCONTX | SYSIBM.SYSCONTEXT table | DSNCTX01 (UC)
DSNCTX02 (U) DSNCTX03 (U) DSNCTX04 (N) |
Contains one row for each trusted context. |
| SYSIBM.SYSCTXTTRUSTATTRS table | DSNCAX01 (UC) | Contains the attributes for a given trusted context | |
| SYSIBM.SYSCONTEXTAUTHIDS table | DSNCDX01 (UC)
DSNCDX02 (N) |
Contains the authorization ID under which a trusted context can be used. | |
| SYSCOPY | SYSIBM.SYSCOPY table | DSNUCH01 (N)
DSNUCX01 (N) |
|
| SYSDDF | SYSIBM.IPLIST table | DSNDUX01 (U) | Contains a row for each IP address that corresponds to a remote DRDA server |
| SYSIBM.IPNAMES table | DSNFPX01 (UC) | Contains a row for each remote DRDA server that DB2 can access using TCP/IP | |
| SYSIBM.LOCATIONS table | DSNFCX01 (UC) | Contains a row for every accessible remote server | |
| SYSIBM.LULIST table | DSNFLX01
DSNFLX02 |
Contains a row for each real LU name that is associated with the dummy LU name for a data sharing group | |
| SYSIBM.LUNAMES table | DSNFNX01 (UC) | Contains a row for each remote SNA client or server | |
| SYSIBM.LUMODES table | DSNFMX01 (UC) | Contains a row for the conversation limit for each combination of LU name and VTAM® logon mode description | |
| SYSIBM.MODESELECT table | DSNFDX01 (UC) | Contains a row for each VTAM logon mode and combination of authorization ID, plan name, and LU name | |
| SYSIBM.USERNAMES table | DSNFEX01 (U) | Contains a row for each authorization ID to be translated or checked as it is sent to or from this DB2 | |
| SYSEBCDC | SYSIBM.SYSDUMMY1 table | — | Contains one row. This table is used by SQL statements that do not use any tables but must specify a table name. |
| |
SYSIBM.SYSDUMMYE table |
— |
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. |
| SYSGPAUT | SYSIBM.SYSRESAUTH table | DSNAGH01 (N)
DSNAGX01 (N) |
Records the privileges that are held by users over buffer pools, storage groups, table spaces, and collections |
| SYSGRTNS | SYSIBM.SYSROUTINES_OPTS table | DSNROX01 (UC) | Contains one row to record the build options for each generated routine |
| SYSIBM.SYSROUTINES_SRC table | DSNRSX01 (N)
DSNRSX02 (U) |
Contains one or more rows for the source code for each generated routine | |
| SYSHIST | SYSIBM.SYSCOLDIST_HIST table | DSNHFX01 (N) | Contains accumulated rows from SYSCOLDIST |
| SYSIBM.SYSCOLUMNS_HIST table | DSNHEX01 (N) | Contains accumulated rows from SYSCOLUMNS | |
| SYSIBM.SYSINDEXES_HIST table | DSNHHX01 (NC)
DSNHHX02 (N) |
Contains accumulated rows from SYSINDEXES | |
| SYSIBM.SYSINDEXPART_HIST table | DSNHGX01 (N) | Contains accumulated rows from SYSINDEXPART | |
| SYSIBM.SYSINDEXSTATS_HIST table | DSNHIX01 (NC) | Contains accumulated rows from SYSINDEXSTATS | |
| SYSIBM.SYSKEYTARGETS_HIST table | DSNHKX01 (N) | Contains accumulated rows from SYSKEYTARGETS | |
| SYSIBM.SYSKEYTGTDIST_HIST table | DSNTDX02 (N) | Contains accumulated rows from SYSKEYTGTDIST | |
| SYSIBM.SYSLOBSTATS_HIST table | DSNHJX01 (NC) | Contains accumulated rows from SYSLOBSTATS | |
| SYSIBM.SYSTABLEPART_HIST table | DSNHCX01 (N) | Contains accumulated rows from SYSTABLEPART | |
| SYSIBM.SYSTABLES_HIST table | DSNHDX01 (N) | Contains accumulated rows from SYSTABLES | |
| SYSIBM.SYSTABSTATS_HIST table | DSNHBX01 (NC) | Contains accumulated rows from SYSTABSTATS | |
| SYSJAUXA | SYSIBM.SYSJARDATA table | DSNJDX01 (A) | Contains the contents of the JAR file for each Java stored procedure |
| SYSJAUXB | SYSIBM.SYSJARCLASS_SOURCE table | DSNJSX01 (A) | Contains the source code for a Java stored procedure |
| SYSJAVA | SYSIBM.SYSJARCONTENTS table | DSNJCX01 (NC) | Records the classes for each JAR file for a Java stored procedure |
| SYSIBM.SYSJAROBJECTS table | DSNJOX01 (UC) | Records the contents of each JAR file for a Java stored procedure | |
| SYSIBM.SYSJAVAOPTS table | DSNJVX01 (UC) | Records the build options for a Java stored procedure | |
| SYSIBM.SYSJAVAPATHS table | 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. | |
| SYSPLUXA | SYSIBM.SYSROUTINESTEXT table | DSNPLX01 (A) | Contains LOB data for the column SYSIBM.SYSROUTINES.TEXT |
| SYSPLUXB |
SYSIBM.SYSROUTINES_TREE table |
DSNPLX02 (A) |
Contains the LOB data for the PARSETREE column of SYSIBM.SYSROUTINES. |
| SYSROLES | SYSIBM.SYSROLES table | DSNRLX01 (UC) | Contains one row for each role |
| SYSIBM.SYSOBJROLEDEP table | DSNRDX01 (UC)
DSNRDX02 (N) |
Contains one row for each dependent role | |
| SYSRTSTS |
SYSIBM.SYSTABLESPACESTATS table |
DSNRTX01 (U) |
Contains real-time statistics for table spaces. |
| |
SYSIBM.SYSINDEXSPACESTATS table |
DSNRTX02 (U)
DSNRTX03 (N) |
Contains real-time statistics for index spaces. |
| SYSSEQ | SYSIBM.SYSSEQUENCES table | DSNSQX01 (U)
DSNSQX02 (UD) DSNSQX03 (N) |
Contains one row for each identity column |
| SYSSEQ2 | SYSIBM.SYSSEQUENCEAUTH table | DSNWCX01 (N)
DSNWCX02 (N) DSNWCX03 (N) |
Records the privileges that users hold on sequences |
| SYSIBM.SYSSEQUENCESDEP table | DSNSRX01 (N)
DSNSRX02 (N) |
Records the dependencies of identity columns on the corresponding entries in SYSIBM.SYSSEQUENCES | |
| SYSSTATS | SYSIBM.SYSCOLDIST table | DSNTNX01 (NC) | Contains cardinality, frequency, and histogram statistics for a single column or a column group. |
| SYSIBM.SYSCOLDISTSTATS table | DSNTPX01 (NC) | Contains cardinality, frequency, and histogram statistics for a single column or a column group. Each partition can have 0 or more rows. | |
| SYSIBM.SYSCOLSTATS table | DSNTCX01 (NC) | Contains partition statistics for selected columns. Each column contains a row for each partition in the table | |
| SYSIBM.SYSINDEXSTATS table | DSNTXX01 (UC) | Contains one row for each partition of a partitioning index or data-partitioned secondary index (DPSI) | |
| SYSIBM.SYSKEYTARGETSTATS table | DSNTKX01 (U) | Contains partition statistics for selected key-targets | |
| SYSIBM.SYSKEYTGTDIST table | DSNTDX01 (N) | Contains one or more rows for the first key-target of an extended index key | |
| SYSIBM.SYSKEYTGTDISTSTATS table | DSNTSX01 (N) | Contains zero or more rows per partition for the first key-target of a data-partitioned secondary index (DPSI) | |
| SYSIBM.SYSLOBSTATS table | DSNLNX01 (UC) | Contains one row for each LOB table space | |
| SYSIBM.SYSTABSTATS table | DSNTTX01 (U)
DSNTTX02 (N) |
Contains one row for each partition of a partitioned table space and no rows for nonpartitioned table spaces | |
| SYSSTR |
SYSIBM.SYSCHECKDEP table |
DSNSDX01 (U) |
Contains one row for each reference to a column in a table check
constraint |
| |
SYSIBM.SYSCHECKS table |
DSNSCX01 (UC) |
Contains one row for each table check constraint |
| |
SYSIBM.SYSCHECKS2 table |
DSNCHX01 (UC) |
Contains one row for each table check constraint |
| SYSIBM.SYSSTRINGS table | DSNSSX01 (U) | Contains information necessary to perform string translations | |
| SYSTARG | SYSIBM.SYSKEYTARGETS table | DSNRKX01 (UC)
DSNRKX02 (N) |
Contains one row for each key-target participating in an extended index definition |
| SYSTSADT |
SYSIBM.SYSAUDITPOLICIES table |
DSNAPX03 (UC) |
Each row represents an audit policy. |
| SYSTSASC |
SYSIBM.SYSDUMMYA table |
— |
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. |
| SYSTSATS |
SYSIBM.SYSAUTOALERTS table |
DSNALX01 (UC)
DSNALX02 (N) DSNALX03 (N) DSNALX04 (N) DSNALX05 (N) DSNALX06 (N) |
Contains a row for each recommendation from the autonomic procedures |
| SYSTSATW |
SYSIBM.SYSAUTOTIMEWINDOWS table |
DSNTWX01 (UC) |
Contains a row for each time period during which autonomic procedures can be
run |
| SYSTSATX |
SYSIBM.SYSAUTOALERTS_OUT table |
DSNALX07 (A) |
Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTOALERTS |
| SYSTSAUX | SYSIBM.SYSAUXRELS table | DSNOXX01 (NC)
DSNOXX02 (N) |
Contains one row for each auxiliary table for a LOB column |
| SYSTSCOL | SYSIBM.SYSCOLUMNS table | DSNDCX01 (U)
DSNDCX02 (N) DSNDCX05 (N) |
Contains one row for every column of each table and view |
| SYSTSCON | SYSIBM.SYSCONSTDEP table | DSNCCX01 (N)
DSNCCX02 (N) |
Records dependencies on check constraints or user-defined defaults for a column |
| SYSTSCPY | SYSIBM.SYSCOPY table | DSNUCH01 (N)
DSNUCX01 (U) |
Contains information that is needed for recovery |
| SYSTSCTD |
SYSCONTROLS_DESC |
DSNTRX02 (A) |
Contains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLS |
| SYSTSCTL |
SYSIBM.SYSCONTROLS table |
DSNCLX01 (U)
DSNCLX02 (U) DSNCLX03 (N) DSNCLX04 (N) DSNCLX05 (N) |
Contains one row for each row permission and column mask. |
| SYSTSCTR |
SYSCONTROLS_RTXT |
DSNTRX01 (A) |
Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS. |
| SYSTSDAT | SYSIBM.SYSDATATYPES table | DSNODX01 (U)
DSNODX02 (U) |
Contains one row for each distinct data type |
| SYSTSDBA | SYSIBM.SYSDATABASE table | DSNDDH01 (U)
DSNDDX02 (N) |
Contains one row for each database, except for database DSNDB01 |
| SYSTSDBR | SYSIBM.SYSDBRM table | DSNDBX01 (N)
DSNDBX02 (U) |
Contains one row for each DBRM of each application plan |
| SYSTSDBU | SYSIBM.SYSDBAUTH table | DSNADH01 (N)
DSNADX01 (N) DSNADH02 (N) |
Records the privileges held by users over databases |
| SYSTSDEP | SYSIBM.SYSDEPENDENCIES table | DSNONX01 (U)
DSNONX02 (N) |
Records the dependencies between objects |
| SYSTSENV | SYSIBM.SYSENVIRONMENT table | DSNOEX01 (U) | Records the environment variables when an object is created |
| SYSTSFAU | SYSIBM.SYSCOLAUTH table | 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 |
| SYSTSFLD | SYSIBM.SYSFIELDS table | DSNDFX01 (N) | Contains one row for every column that has a field procedure |
| SYSTSFOR | SYSIBM.SYSFOREIGNKEYS table | DSNDRH01 (N) | Contains one row for every column of every foreign key |
| SYSTSIPT | SYSIBM.SYSINDEXPART table | 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 |
| SYSTSIXR |
SYSIBM.SYSINDEXES_RTSECT table |
DSNDXX06 (A) |
Contains the LOB data for the RTSECTION column of SYSIBM.SYSINDEXES. |
| SYSTSIXS | SYSIBM.SYSINDEXES table | DSNDXX01 (U)
DSNDXX02 (U) DSNDXX03 (U) DSNDXX04 (N) DSNDXX07 |
Contains one row for every index |
| SYSTSIXT |
SYSIBM.SYSINDEXES_TREE table |
DSNDXX05 (A) |
Contains the LOB data for the PARSETREE column of SYSIBM.SYSINDEXES. |
| SYSTSKEY | SYSIBM.SYSKEYS table | DSNDKX01 (U)
DSNDKX02 (N) DSNDKX03 (U) |
Contains one row for each column of an index key |
| SYSTSKYC | SYSIBM.SYSKEYCOLUSE table | DSNCUX01 (N) | Contains a row for every column in a unique constraint (primary key or unique key) |
| SYSTSPDO |
SYSIBM.SYSPENDINGOBJECTS table |
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. |
| SYSTSPDT |
SYSPENDINGDDLTEXT |
DSNPDX03 (A) |
Contains the LOB data for the STATEMENT_TEXT column of
SYSIBM.SYSPENDINGDDL. |
| SYSTSPEN |
SYSIBM.SYSPENDINGDDL table |
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. |
| SYSTSPHX |
SYSIBM.SYSAUTORUNS_HISTOU table |
DSNPHX04 (A) |
Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTORUNS_HIST |
| SYSTSPKA | SYSIBM.SYSPACKAUTH table | DSNKAX01 (N)
DSNKAX02 (N) DSNKAX03 (N) |
Contains the privileges that are held by users over packages |
| SYSTSPKC | SYSIBM.SYSPACKCOPY table | DSNPCX01 (UC) | |
| SYSTSPKD | SYSIBM.SYSPACKDEP table | DSNKDX01 (N)
DSNKDX02 (N) DSNKDX03 (N) |
Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, and triggers |
| SYSTSPKG | SYSIBM.SYSPACKAGE table | DSNKKX01 (U)
DSNKKX02 (U) |
Contains one row for each package |
| SYSTSPKL | SYSIBM.SYSPACKLIST table | DSNKLX01 (N)
DSNKLX02 (U) |
Contains one row for every package list entry for a plan |
| SYSTSPKS | SYSIBM.SYSPACKSTMT table | DSNKSX01 (UC) | Contains one row for every SQL statement that belongs to a package |
| SYSTSPKX |
SYSIBM.SYSPACKSTMT_STMT table |
DSNPKX01 (A) |
Contains the LOB data for the STATEMENT column of SYSIBM.SYSPACKSTMT. |
| SYSTSPKY |
SYSIBM.SYSPKSYSTEM table |
DSNKYX01 (N) |
Contain one row of system information for each package |
| SYSTSPLA |
SYSIBM.SYSPLANAUTH table |
DSNAPH01 (N)
DSNAPX01 (N) DSNAPX02 (N) |
Records the privileges that are held by users over application plans |
| SYSTSPLD | SYSIBM.SYSPLANDEP table | DSNGGX01 (N)
DSNGGX05 (N) |
Records the dependencies of plans on tables, views, aliases, synonyms, table spaces, and indexes |
| SYSTSPLN | SYSIBM.SYSPLAN table | DSNPPH01 (U)
|
Contains one row for each application plan |
| SYSTSPLY | SYSIBM.SYSPLSYSTEM table | DSNKPX01 (N) | Contains one row of system information for each plan |
| SYSTSPRH |
SYSIBM.SYSAUTORUNS_HIST table |
DSNPHX01 (UC)
DSNPHX02 (N) DSNPHX03 (N) |
Contains a row for each execution of an autonomic procedure. |
| SYSTSPRM | SYSIBM.SYSPARMS table | 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 |
| SYSTSPTX |
SYSIBM.SYSTABLES_PROFILE_TEXT table |
DSNPRX02 (UC) |
Contains the LOB data for the PROFILE_TEXT column of
SYSIBM.SYSTABLES_PROFILES |
| SYSTSPVR |
SYSIBM.SYSPACKSTMT_STMB table |
DSNKSX02 (A) |
Contains the LOB data for the STMTBLOB column of SYSIBM.SYSPACKSTMT. |
| SYSTSQRA |
SYSIBM.SYSQUERY_AUX table |
DSNQSX01 (A) |
Contains the LOB data for the STMTTEXT column of SYSIBM.SYSQUERY |
| SYSTSQRO |
SYSIBM.SYSQUERYOPTS table |
DSNQPX01 (N) |
Contains optimization parameters for the queries in SYSIBM.SYSQUERY. |
| SYSTSQRP |
SYSIBM.SYSQUERYPLAN table |
DSNQNX01 (N) |
Contains the plan hint information for the queries in the SYSIBM.SYSQUERY
table |
| SYSTSQRY |
SYSIBM.SYSQUERY table |
DSNQYX01 (N)
DSNQYX02 (U) DSNQYX03 (N) |
Contains a set of queries |
| SYSTSRAU | SYSIBM.SYSROUTINEAUTH table | DSNOAX01 (N)
DSNOAX02 (U) DSNOAX03 (N) |
Records the privileges that users hold on routines |
| SYSTSREL | SYSIBM.SYSRELS table | DSNDLX01 (N)
DSNDLX02 (N) DSNDLX03 (N) DSNDLX04 (U) |
Contains one row for every relationship |
| SYSTSROU | SYSIBM.SYSROUTINES table | DSNOFX01 (U)
DSNOFX02 (U) DSNOFX03 (N) DSNOFX04 (U) DSNOFX05 (N) DSNOFX06 (N) DSNOFX07 (U) DSNOFX08 (N) |
Contains a row for every routine |
| SYSTSSCM | SYSIBM.SYSSCHEMAAUTH table | DSNSKX01 (N)
DSNSKX02 (N) |
Contains one or more rows for each grantee of a privilege on a schema |
| SYSTSSTG | SYSIBM.SYSSTOGROUP table | DSNSSH01 (U) | Contains one row for each storage group |
| SYSTSSTM | SYSIBM.SYSSTMT table | DSNPSX01 (N)
DSNPSX02 (N) |
Contains one or more rows for each SQL statement of each DBRM |
| SYSTSSYN | SYSIBM.SYSSYNONYMS table | DSNDYX01 (U)
DSNDYX02 (N) |
Contains one row for each synonym of a table or view |
| SYSTSTAB | SYSIBM.SYSTABLES table | DSNDTX01 (U)
DSNDTX02 (N) DSNDTX03 (N) DSNDTX05 |
Contains one row for each table, view, and alias |
| SYSTSTAH | SYSCTXTTRUSTATTR_H | Not used. | |
| SYSTSTAU | SYSIBM.SYSTABAUTH table | DSNATX01 (N)
DSNATX02 (N) DSNATX03 (N) DSNATX04 (N) DSNATX05 (U) |
Records the privileges that are held by users on tables, views, and triggers |
| SYSTSTBC | SYSIBM.SYSTABCONST table | DSNCNX01 (U)
DSNCNX02 (N) |
Contains one row for each unique constraint that was created in DB2 for z/OS DB2 Version 7 or later |
| SYSTSTPF |
SYSIBM.SYSTABLES_PROFILES table |
DSNPRX01 (UC) |
Contains a row for each profile that is associated with a table in
SYSIBM.SYSTABLES |
| SYSTSTPT | SYSIBM.SYSTABLEPART table | 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 |
| SYSTSTRG | SYSIBM.SYSTRIGGERS table | DSNOTX01 (UC)
DSNOTX02 (N) DSNOTX03 (N) |
Contains one row for each trigger |
| SYSTSTRT |
SYSIBM.SYSTRIGGERS_STMT table |
DSNOTX04 (A) |
Contains the LOB data for the STATEMENT column of SYSIBM.SYSTRIGGERS |
| SYSTSTSP | SYSIBM.SYSTABLESPACE table | DSNDSX01 (U) | Contains one row for each table space |
| SYSTSUNI |
SYSIBM.SYSDUMMYU table |
— |
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. |
| SYSTSVEW | SYSIBM.SYSVIEWS table | DSNVVX01 (U) | Contains one or more rows for each view |
| SYSTSVOL | SYSIBM.SYSVOLUMES table | DSNSSH02 (N) | Contains one row for each volume of each storage group |
| SYSTSVTR |
SYSIBM.SYSVIEWS_TREE table |
DSNVWX02 (A) |
Contains the LOB data for the PARSETREE column of SYSIBM.SYSVIEWS |
| SYSTSVWD | SYSIBM.SYSVIEWDEP table | DSNGGX02 (N)
DSNGGX03 (N) DSNGGX04 (N) DSNGGX06 |
Records the dependencies of views on tables and other views |
| SYSTSVWT |
SYSIBM.SYSVIEWS_STMT table |
DSNVWX01 (A) |
Contains the LOB data for the STATEMENT column of SYSIBM.SYSVIEWS |
| SYSTSXTM |
SYSIBM.SYSXMLTYPMOD table |
DSNTMX01 (U) |
Contains rows about the XML type modifiers of XML columns. Rows in this table can
be inserted, updated, and deleted. |
| SYSTSXTS |
SYSIBM.SYSXMLTYPMSCHEMA table |
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. |
| SYSUSER |
SYSIBM.SYSUSERAUTH table |
DSNAUH01 (N)
DSNAUX02 (N) |
Records the system privileges that are held by users |
| SYSXML | SYSIBM.SYSXMLRELS table | DSNXRX01 (N)
DSNXRX02 (N) |
Contains one row for each XML table that is created for an XML column |
| SYSIBM.SYSXMLSTRINGS table | 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. |
Notes:
- The descriptions of the SYSIBM.SYSOBDS and SYSIBM.SYSOBD_AUX
catalog tables are available only to users who work in enterprises with a DB2 10 license. For more information see Obtaining DB2 Diagnosis Guide and Reference.
- The following index types are indicated:
- A
- Auxiliary
- N
- Nonunique
- U
- Unique
- UC
- Unique clustering
- UD
- Unique descending