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.

Catalog changes in Db2 11

Db2 11 introduces new Db2 catalog objects and changes to existing catalog objects. For a summary of the changes, see Catalog changes in Db2 11.

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.

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
Start of changePEnd of change
Start of changeDb2 11 dependency indicator, not from MRM tapeEnd of change
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 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.
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 Start of change
DSNOXX01 (NC)
DSNOXX02 (N)
End of change
Contains one row for each auxiliary table for a LOB column
SYSCHECKDEP Start of changeSYSTSCKDEnd of change DSNSDX01 (UC) Contains one row for each reference to a column in a table check constraint
SYSCHECKS2 Start of changeSYSTSCHXEnd of change DSNCHX01 (UC) Contains one row for each table check constraint
SYSCHECKS Start of changeSYSTSCKSEnd of change 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
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.
SYSCONTEXT SYSCONTX
DSNCTX01 (UC)
DSNCTX02 (U)
DSNCTX03 (U)
DSNCTX04 (N)
Contains one row for each trusted context.
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_RTXT SYSTSCTR DSNTRX01 (A) Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS.
SYSCOPY Start of changeSYSTSCPYEnd of change
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
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.
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
Start of changeSYSINDEXCLEANUPEnd of change Start of changeSYSTSIXCEnd of change Start of changeDSNICX01 (N)End of change Start of changeContains time window data to control index cleanup processing.End of change
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 Start of changeSYSTSISSEnd of change
DSNRTX02 (U)
DSNRTX03 (N)
Contains Real-time Statistics for index spaces.
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)
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
Start of changeSYSOBD_AUX Start of change1End of changeEnd of change Start of changeSYSTSOBXEnd of change Start of changeDSNOB03 (A)End of change Start of changeContains the LOB data for the OBD_IMAGE column of SYSIBM.SYSOBDS.End of change
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
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
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)
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
Start of changeSYSQUERYPREDICATEEnd of change Start of changeSYSTSQREEnd of change Start of change
DSNQEX01 (UC)
DSNQEX02 (N)
End of change
Start of changeContains 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.End of change
Start of changeSYSQUERYSELEnd of change Start of changeSYSTSQRSEnd of change Start of changeEnd of change Start of changeContains 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.End of change
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
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
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
SYSSEQUENCEAUTH SYSSEQ2
DSNWCX01 (N)
DSNWCX02 (N)
DSNWCX03 (N)
Records the privileges that users hold on sequences
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 changeSYSSTATFEEDBACKEnd of change Start of changeSYSTSSFBEnd of change Start of changeDSNSFX01 (UC)End of change Start of changeContains one row for every missing or conflicting statistic that is identified during query optimization.End of change
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 Start of changeSYSTSSRGEnd of change 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
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.
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
Start of changeSYSVARIABLEAUTHEnd of change Start of changeSYSTSVAUEnd of change Start of change
DSNVAX01 (N)
DSNVAX02 (N)
DSNVAX03 (N)
End of change
Start of changeContains one row for each authorization ID that has privileges for each global variable.End of change
Start of changeSYSVARIABLESEnd of change Start of changeSYSTSVAREnd of change Start of change
DSNOVX01 (U)
End of change
Start of changeContains one row for each global variable that has been created.End of change
Start of changeSYSVARIABLES_DESCEnd of change Start of changeSYSTSVADEnd of change Start of changeDSNOVX03 (A)End of change Start of changeContains the LOB data for the DESCRIPTOR column of SYSIBM.SYSVARIABLES.End of change
Start of changeSYSVARIABLES_TEXTEnd of change Start of changeSYSTSVATEnd of change Start of changeDSNOVX02 (A)End of change Start of changeContains the LOB data for the DEFAULTTEXT column of SYSIBM.SYSVARIABLES.End of change
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
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 changeThe descriptions of the SYSIBM.SYSOBDS and SYSIBM.SYSOBD_AUX catalog tables are available only to users who work in enterprises with a Db2 11 license. For more information see Obtaining Db2 Diagnosis Guide and Reference.End of change
  2. The following index types are indicated:
    A
    Auxiliary
    N
    Nonunique
    U
    Unique
    UC
    Unique clustering
    UD
    Unique descending