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.

Start of change

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.

Db2 12 function levels use the following Db2 catalog levels:
  • V12R1M509
  • V12R1M507
  • V12R1M505
  • V12R1M503
  • V12R1M502
  • V12R1M500
Tip: When you update the Db2 catalog level, you can specify either the target function level or the catalog level. If you specify the function level, Db2 determines the appropriate target catalog level, and the CATMAINT utility completes any required catalog level updates in sequential order. For more information, see CATMAINT.

For a summary of the changes, see Catalog changes in Db2 12.

End of change
Start of changeEnd of change
Start of change

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.

End of change

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.

Important: The IBMREQD column is not a reliable indicator for indicating release dependencies. Where possible, the RELCREATED and RELBOUND columns should be used instead.

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.

Table 1. Db2 catalog tables. The qualifier for all catalog table names is SYSIBM.
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)
Start of changeDSNDCX06 (N)End of change
 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
Start of changeSYSCONTROLS_DESC_HEnd of change Start of changeSYSTSCHDEnd of change Start of changeDSNTRX04 (A)End of change Start of changeContains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLS_HEnd of change
SYSCONTROLS_RTXT SYSTSCTR DSNTRX01 (A) Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS.
Start of changeSYSCONTROLS_RTXT_HEnd of change Start of changeSYSTSCHREnd of change Start of changeDSNTRX03 (A)End of change Start of changeContains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS_HEnd of change
SYSCOPY SYSTSCPY
DSNUCH01 (N)
Start of changeDSNUCX01 (N)End of change
 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.
Start of changeSYSDYNQRYEnd of change Start of changeSYSTSDQYEnd of change Start of change
DSNDQX01 (U)
DSNDQX02 (UC)
DSNDQX11 (U)
End of change		 Start of changeContains one row for each stabilized dynamic query.End of change
Start of changeSYSDYNQRYDEPEnd of change Start of changeSYSTSDQDEnd of change Start of change
DSNDQX03 (N)
DSNDQX04 (N)
DSNDQX05 (N)
DSNDQX12 (N)
End of change		 Start of changeRecords the dependencies of stabilized dynamic queries.End of change
Start of changeSYSDYNQRY_EXPLEnd of change Start of changeSYSTSDQEEnd of change Start of changeDSNDQX08 (A)End of change Start of changeInternal use for stabilized dynamic queries.End of change
Start of changeSYSDYNQRY_OPLEnd of change Start of changeSYSTSDQOEnd of change Start of changeDSNDQX10 (A)End of change Start of changeInternal use for stabilized dynamic queries.End of change
Start of changeSYSDYNQRY_SHTELEnd of change Start of changeSYSTSDQHEnd of change Start of changeDSNDQX09 (A)End of change Start of changeInternal use for stabilized dynamic queries.End of change
Start of changeSYSDYNQRY_SPALEnd of change Start of changeSYSTSDQSEnd of change Start of changeDSNDQX07 (A)End of change Start of changeInternal use for stabilized dynamic queries.End of change
Start of changeSYSDYNQRY_TXTLEnd of change Start of changeSYSTSDQTEnd of change Start of changeDSNDQX06 (A)End of change Start of changeInternal use for stabilized dynamic queries.End of change
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.
Start of changeSYSIXSPACESTATS_HEnd of change Start of changeSYSTSISHEnd of change Start of change End of change Start of changeA history table for temporal versioning of the SYSINDEXSPACESTATS catalog table table. For more information, see Temporal versioning for Db2 statistics-related catalog tables.End of change
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)
Start of changeSYSLEVELUPDATESEnd of change Start of changeSYSTSLVHEnd of change Start of change
DSNLVX01 (N)
DSNLVX02 (N)
End of change		 Start of changeContains information about the function levels, catalog levels, and code levels of the Db2 subsystem or data sharing group.End of change
SYSLOBSTATS SYSSTATS DSNLNX01 (UC) Contains one row for each LOB table space
SYSLOBSTATS_HIST SYSHIST DSNHJX01 (NC) Contains accumulated rows from SYSLOBSTATS
SYSOBDS Start of change1End of change 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: Start of changeDo not manipulate data in the SYSIBM.SYSOBDS catalog table, except at the direction of IBM® Support.End of change
SYSOBD_AUX Start of change1End of change 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)
Start of changeDSNQYX04 (N)End of change
 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
Start of changeSYSSESSIONEnd of change Start of changeSYSTSSESEnd of change Start of changeDSNSNX02 (N)End of change Start of changeContains session tokens that are generated by the server and associated session data.End of change
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.
Start of changeSYSSESSION_GVEnd of change Start of changeSYSTSSNLEnd of change Start of changeDSNSNX01 (U)End of change Start of changeContains the LOB data for the GLOBAL_VARIABLES column of SYSIBM.SYSSESSION table.End of change
Start of changeSYSSESSION_DATAEnd of change Start of changeSYSTSSXLEnd of change Start of changeDSNSNX03 (U)End of change Start of changeContains LOB data for the DATA column of the SYSSESSION_EX table.End of change
Start of changeSYSSESSION_STATUSEnd of change Start of changeSYSTSSTAEnd of change Start of changeDSNSNX06 (U)End of change Start of changeContains the session token and timestamp value when the corresponding session data was last referenced.End of change
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.
Start of changeSYSTABSPACESTATS_HEnd of change Start of changeSYSTSTSHEnd of change Start of change End of change Start of changeA history table for temporal versioning of the SYSTABLESPACESTATS catalog table table. For more information, see Temporal versioning for Db2 statistics-related catalog tables.End of change
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
Start of changeSYSVIEWDEP_HEnd of change Start of changeSYSTSVDHEnd of change Start of change—End of change Start of changeNot used.End of change
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
Notes:
  1. Start of changeDescriptions 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.End of change
  2. 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
PDF file icon SQL Reference