DB2 for z: system catalog tables
http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_catalogtablesintro.htmlTable spaceTableIndexes (Type1 )DescriptionSYSALTERSYSOBDS
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 generatedSYSCONTXSYSIBM.SYSCONTEXT table
DSNCTX01 (UC)
DSNCTX02 (U)
DSNCTX03 (U)
DSNCTX04 (N)Contains one row for each trusted context. SYSIBM.SYSCTXTTRUSTATTRS tableDSNCAX01 (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.SYSCOPYSYSIBM.SYSCOPY table
DSNUCH01 (N)
DSNUCX01 (N) SYSDDFSYSIBM.IPLIST tableDSNDUX01 (U)Contains a row for each IP address that corresponds to a remote DRDA® server SYSIBM.IPNAMES tableDSNFPX01 (UC)Contains a row for each remote DRDA server that DB2 can access using TCP/IP SYSIBM.LOCATIONS tableDSNFCX01 (UC)Contains a row for every accessible remote server SYSIBM.LULIST table
DSNFLX01
DSNFLX02Contains a row for each real LU name that is associated with the dummy LU name for a data sharing group SYSIBM.LUNAMES tableDSNFNX01 (UC)Contains a row for each remote SNA client or server SYSIBM.LUMODES tableDSNFMX01 (UC)Contains a row for the conversation limit for each combination of LU name and VTAM logon mode description SYSIBM.MODESELECT tableDSNFDX01 (UC)Contains a row for each VTAM logon mode and combination of authorization ID, plan name, and LU name SYSIBM.USERNAMES tableDSNFEX01 (U)Contains a row for each authorization ID to be translated or checked as it is sent to or from this DB2SYSEBCDCSYSIBM.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.SYSGPAUTSYSIBM.SYSRESAUTH table
DSNAGH01 (N)
DSNAGX01 (N)Records the privileges that are held by users over buffer pools, storage groups, table spaces, and collectionsSYSGRTNSSYSIBM.SYSROUTINES_OPTS tableDSNROX01 (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 routineSYSHISTSYSIBM.SYSCOLDIST_HIST tableDSNHFX01 (N)Contains accumulated rows from SYSCOLDIST SYSIBM.SYSCOLUMNS_HIST tableDSNHEX01 (N)Contains accumulated rows from SYSCOLUMNS SYSIBM.SYSINDEXES_HIST table
DSNHHX01 (NC)
DSNHHX02 (N)Contains accumulated rows from SYSINDEXES SYSIBM.SYSINDEXPART_HIST tableDSNHGX01 (N)Contains accumulated rows from SYSINDEXPART SYSIBM.SYSINDEXSTATS_HIST tableDSNHIX01 (NC)Contains accumulated rows from SYSINDEXSTATS SYSIBM.SYSKEYTARGETS_HIST tableDSNHKX01 (N)Contains accumulated rows from SYSKEYTARGETS SYSIBM.SYSKEYTGTDIST_HIST tableDSNTDX02 (N)Contains accumulated rows from SYSKEYTGTDIST SYSIBM.SYSLOBSTATS_HIST tableDSNHJX01 (NC)Contains accumulated rows from SYSLOBSTATS SYSIBM.SYSTABLEPART_HIST tableDSNHCX01 (N)Contains accumulated rows from SYSTABLEPART SYSIBM.SYSTABLES_HIST tableDSNHDX01 (N)Contains accumulated rows from SYSTABLES SYSIBM.SYSTABSTATS_HIST tableDSNHBX01 (NC)Contains accumulated rows from SYSTABSTATSSYSJAUXASYSIBM.SYSJARDATA tableDSNJDX01 (A)Contains the contents of the JAR file for each Java stored procedureSYSJAUXBSYSIBM.SYSJARCLASS_SOURCE tableDSNJSX01 (A)Contains the source code for a Java stored procedureSYSJAVASYSIBM.SYSJARCONTENTS tableDSNJCX01 (NC)Records the classes for each JAR file for a Java stored procedure SYSIBM.SYSJAROBJECTS tableDSNJOX01 (UC)Records the contents of each JAR file for a Java stored procedure SYSIBM.SYSJAVAOPTS tableDSNJVX01 (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.SYSPLUXASYSIBM.SYSROUTINESTEXT tableDSNPLX01 (A)Contains LOB data for the column SYSIBM.SYSROUTINES.TEXTSYSPLUXBSYSIBM.SYSROUTINES_TREE tableDSNPLX02 (A)Contains the LOB data for the PARSETREE column of SYSIBM.SYSROUTINES.SYSROLESSYSIBM.SYSROLES tableDSNRLX01 (UC)Contains one row for each role SYSIBM.SYSOBJROLEDEP table
DSNRDX01 (UC)
DSNRDX02 (N)Contains one row for each dependent roleSYSRTSTSSYSIBM.SYSTABLESPACESTATS tableDSNRTX01 (U)Contains real-time statistics for table spaces. SYSIBM.SYSINDEXSPACESTATS table
DSNRTX02 (U)
DSNRTX03 (N)Contains real-time statistics for index spaces.SYSSEQSYSIBM.SYSSEQUENCES table
DSNSQX01 (U)
DSNSQX02 (UD)
DSNSQX03 (N)Contains one row for each identity columnSYSSEQ2SYSIBM.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.SYSSEQUENCESSYSSTATSSYSIBM.SYSCOLDIST tableDSNTNX01 (NC)Contains cardinality, frequency, and histogram statistics for a single column or a column group. SYSIBM.SYSCOLDISTSTATS tableDSNTPX01 (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 tableDSNTCX01 (NC)Contains partition statistics for selected columns. Each column contains a row for each partition in the table SYSIBM.SYSINDEXSTATS tableDSNTXX01 (UC)Contains one row for each partition of a partitioning index or data-partitioned secondary index (DPSI) SYSIBM.SYSKEYTARGETSTATS tableDSNTKX01 (U)Contains partition statistics for selected key-targets SYSIBM.SYSKEYTGTDIST tableDSNTDX01 (N)Contains one or more rows for the first key-target of an extended index key SYSIBM.SYSKEYTGTDISTSTATS tableDSNTSX01 (N)Contains zero or more rows per partition for the first key-target of a data-partitioned secondary index (DPSI) SYSIBM.SYSLOBSTATS tableDSNLNX01 (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 spacesSYSSTRSYSIBM.SYSCHECKDEP tableDSNSDX01 (U)Contains one row for each reference to a column in a table check constraint SYSIBM.SYSCHECKS tableDSNSCX01 (UC)Contains one row for each table check constraint SYSIBM.SYSCHECKS2 tableDSNCHX01 (UC)Contains one row for each table check constraint SYSIBM.SYSSTRINGS tableDSNSSX01 (U)Contains information necessary to perform string translationsSYSTARGSYSIBM.SYSKEYTARGETS table
DSNRKX01 (UC)
DSNRKX02 (N)Contains one row for each key-target participating in an extended index definitionSYSTSADTSYSIBM.SYSAUDITPOLICIES tableDSNAPX03 (UC)Each row represents an audit policy. SYSTSASCSYSIBM.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.SYSTSATSSYSIBM.SYSAUTOALERTS table
DSNALX01 (UC)
DSNALX02 (N)
DSNALX03 (N)
DSNALX04 (N)
DSNALX05 (N)
DSNALX06 (N)Contains a row for each recommendation from the autonomic proceduresSYSTSATWSYSIBM.SYSAUTOTIMEWINDOWS tableDSNTWX01 (UC)Contains a row for each time period during which autonomic procedures can be runSYSTSATXSYSIBM.SYSAUTOALERTS_OUT tableDSNALX07 (A)Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTOALERTSSYSTSAUXSYSIBM.SYSAUXRELS table
DSNOXX01 (NC)
DSNOXX02 (N)Contains one row for each auxiliary table for a LOB columnSYSTSCOLSYSIBM.SYSCOLUMNS table
DSNDCX01 (U)
DSNDCX02 (N)
DSNDCX05 (N)Contains one row for every column of each table and viewSYSTSCONSYSIBM.SYSCONSTDEP table
DSNCCX01 (N)
DSNCCX02 (N)Records dependencies on check constraints or user-defined defaults for a columnSYSTSCPYSYSIBM.SYSCOPY table
DSNUCH01 (N)
DSNUCX01 (U)Contains information that is needed for recoverySYSTSCTDSYSCONTROLS_DESCDSNTRX02 (A)Contains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLSSYSTSCTLSYSIBM.SYSCONTROLS table
DSNCLX01 (U)
DSNCLX02 (U)
DSNCLX03 (N)
DSNCLX04 (N)
DSNCLX05 (N)Contains one row for each row permission and column mask. SYSTSCTRSYSCONTROLS_RTXTDSNTRX01 (A)Contains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS.SYSTSDATSYSIBM.SYSDATATYPES table
DSNODX01 (U)
DSNODX02 (U)Contains one row for each distinct data typeSYSTSDBASYSIBM.SYSDATABASE table
DSNDDH01 (U)
DSNDDX02 (N)Contains one row for each database, except for database DSNDB01SYSTSDBRSYSIBM.SYSDBRM table
DSNDBX01 (N)
DSNDBX02 (U)Contains one row for each DBRM of each application planSYSTSDBUSYSIBM.SYSDBAUTH table
DSNADH01 (N)
DSNADX01 (N)
DSNADH02 (N)Records the privileges held by users over databasesSYSTSDEPSYSIBM.SYSDEPENDENCIES table
DSNONX01 (U)
DSNONX02 (N)Records the dependencies between objectsSYSTSENVSYSIBM.SYSENVIRONMENT tableDSNOEX01 (U)Records the environment variables when an object is createdSYSTSFAUSYSIBM.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 viewSYSTSFLDSYSIBM.SYSFIELDS tableDSNDFX01 (N)Contains one row for every column that has a field procedureSYSTSFORSYSIBM.SYSFOREIGNKEYS tableDSNDRH01 (N)Contains one row for every column of every foreign keySYSTSIPTSYSIBM.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 DPSISYSTSIXRSYSIBM.SYSINDEXES_RTSECT tableDSNDXX06 (A)Contains the LOB data for the RTSECTION column of SYSIBM.SYSINDEXES.SYSTSIXSSYSIBM.SYSINDEXES table
DSNDXX01 (U)
DSNDXX02 (U)
DSNDXX03 (U)
DSNDXX04 (N)
DSNDXX07Contains one row for every indexSYSTSIXTSYSIBM.SYSINDEXES_TREE tableDSNDXX05 (A)Contains the LOB data for the PARSETREE column of SYSIBM.SYSINDEXES.SYSTSKEYSYSIBM.SYSKEYS table
DSNDKX01 (U)
DSNDKX02 (N)
DSNDKX03 (U)Contains one row for each column of an index keySYSTSKYCSYSIBM.SYSKEYCOLUSE tableDSNCUX01 (N)Contains a row for every column in a unique constraint (primary key or unique key)SYSTSPDOSYSIBM.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. SYSTSPDTSYSPENDINGDDLTEXTDSNPDX03 (A)Contains the LOB data for the STATEMENT_TEXT column of SYSIBM.SYSPENDINGDDL.SYSTSPENSYSIBM.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. SYSTSPHXSYSIBM.SYSAUTORUNS_HISTOU tableDSNPHX04 (A)Contains the LOB data for the OUTPUT column of SYSIBM.SYSAUTORUNS_HISTSYSTSPKASYSIBM.SYSPACKAUTH table
DSNKAX01 (N)
DSNKAX02 (N)
DSNKAX03 (N)Contains the privileges that are held by users over packagesSYSTSPKCSYSIBM.SYSPACKCOPY tableDSNPCX01 (UC) SYSTSPKDSYSIBM.SYSPACKDEP table
DSNKDX01 (N)
DSNKDX02 (N)
DSNKDX03 (N)Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, and triggersSYSTSPKGSYSIBM.SYSPACKAGE table
DSNKKX01 (U)
DSNKKX02 (U)Contains one row for each packageSYSTSPKLSYSIBM.SYSPACKLIST table
DSNKLX01 (N)
DSNKLX02 (U)Contains one row for every package list entry for a planSYSTSPKSSYSIBM.SYSPACKSTMT tableDSNKSX01 (UC)Contains one row for every SQL statement that belongs to a packageSYSTSPKXSYSIBM.SYSPACKSTMT_STMT tableDSNPKX01 (A)Contains the LOB data for the STATEMENT column of SYSIBM.SYSPACKSTMT.SYSTSPKYSYSIBM.SYSPKSYSTEM tableDSNKYX01 (N)Contain one row of system information for each packageSYSTSPLASYSIBM.SYSPLANAUTH table
DSNAPH01 (N)
DSNAPX01 (N)
DSNAPX02 (N)Records the privileges that are held by users over application plansSYSTSPLDSYSIBM.SYSPLANDEP table
DSNGGX01 (N)
DSNGGX05 (N)Records the dependencies of plans on tables, views, aliases, synonyms, table spaces, and indexesSYSTSPLNSYSIBM.SYSPLAN table
DSNPPH01 (U)Contains one row for each application planSYSTSPLYSYSIBM.SYSPLSYSTEM tableDSNKPX01 (N)Contains one row of system information for each planSYSTSPRHSYSIBM.SYSAUTORUNS_HIST table
DSNPHX01 (UC)
DSNPHX02 (N)
DSNPHX03 (N)Contains a row for each execution of an autonomic procedure.SYSTSPRMSYSIBM.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 routineSYSTSPTXSYSIBM.SYSTABLES_PROFILE_TEXT tableDSNPRX02 (UC)Contains the LOB data for the PROFILE_TEXT column of SYSIBM.SYSTABLES_PROFILESSYSTSPVRSYSIBM.SYSPACKSTMT_STMB tableDSNKSX02 (A)Contains the LOB data for the STMTBLOB column of SYSIBM.SYSPACKSTMT.SYSTSQRASYSIBM.SYSQUERY_AUX tableDSNQSX01 (A)Contains the LOB data for the STMTTEXT column of SYSIBM.SYSQUERYSYSTSQROSYSIBM.SYSQUERYOPTS tableDSNQPX01 (N)Contains optimization parameters for the queries in SYSIBM.SYSQUERY.SYSTSQRPSYSIBM.SYSQUERYPLAN tableDSNQNX01 (N)Contains the plan hint information for the queries in the SYSIBM.SYSQUERY tableSYSTSQRYSYSIBM.SYSQUERY table
DSNQYX01 (N)
DSNQYX02 (U)
DSNQYX03 (N)Contains a set of queriesSYSTSRAUSYSIBM.SYSROUTINEAUTH table
DSNOAX01 (N)
DSNOAX02 (U)
DSNOAX03 (N)Records the privileges that users hold on routinesSYSTSRELSYSIBM.SYSRELS table
DSNDLX01 (N)
DSNDLX02 (N)
DSNDLX03 (N)
DSNDLX04 (U)Contains one row for every relationshipSYSTSROUSYSIBM.SYSROUTINES table
DSNOFX01 (U)
DSNOFX02 (U)
DSNOFX03 (N)
DSNOFX04 (U)
DSNOFX05 (N)
DSNOFX06 (N)
DSNOFX07 (U)
DSNOFX08 (N)Contains a row for every routineSYSTSSCMSYSIBM.SYSSCHEMAAUTH table
DSNSKX01 (N)
DSNSKX02 (N)Contains one or more rows for each grantee of a privilege on a schemaSYSTSSTGSYSIBM.SYSSTOGROUP tableDSNSSH01 (U)Contains one row for each storage groupSYSTSSTMSYSIBM.SYSSTMT table
DSNPSX01 (N)
DSNPSX02 (N)Contains one or more rows for each SQL statement of each DBRMSYSTSSYNSYSIBM.SYSSYNONYMS table
DSNDYX01 (U)
DSNDYX02 (N)Contains one row for each synonym of a table or viewSYSTSTABSYSIBM.SYSTABLES table
DSNDTX01 (U)
DSNDTX02 (N)
DSNDTX03 (N)
DSNDTX05Contains one row for each table, view, and aliasSYSTSTAUSYSIBM.SYSTABAUTH table
DSNATX01 (N)
DSNATX02 (N)
DSNATX03 (N)
DSNATX04 (N)
DSNATX05 (U)Records the privileges that are held by users on tables, views, and triggersSYSTSTBCSYSIBM.SYSTABCONST table
DSNCNX01 (U)
DSNCNX02 (N)Contains one row for each unique constraint that was created in DB2 for z/OS Version 7 or laterSYSTSTPFSYSIBM.SYSTABLES_PROFILES tableDSNPRX01 (UC)Contains a row for each profile that is associated with a table in SYSIBM.SYSTABLESSYSTSTPTSYSIBM.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 spaceSYSTSTRGSYSIBM.SYSTRIGGERS table
DSNOTX01 (UC)
DSNOTX02 (N)
DSNOTX03 (N)Contains one row for each triggerSYSTSTRTSYSIBM.SYSTRIGGERS_STMT tableDSNOTX04 (A)Contains the LOB data for the STATEMENT column of SYSIBM.SYSTRIGGERSSYSTSTSPSYSIBM.SYSTABLESPACE tableDSNDSX01 (U)Contains one row for each table spaceSYSTSUNISYSIBM.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.SYSTSVEWSYSIBM.SYSVIEWS tableDSNVVX01 (U)Contains one or more rows for each viewSYSTSVOLSYSIBM.SYSVOLUMES tableDSNSSH02 (N)Contains one row for each volume of each storage groupSYSTSVTRSYSIBM.SYSVIEWS_TREE tableDSNVWX02 (A)Contains the LOB data for the PARSETREE column of SYSIBM.SYSVIEWSSYSTSVWDSYSIBM.SYSVIEWDEP table
DSNGGX02 (N)
DSNGGX03 (N)
DSNGGX04 (N)
DSNGGX06Records the dependencies of views on tables and other viewsSYSTSVWTSYSIBM.SYSVIEWS_STMT tableDSNVWX01 (A)Contains the LOB data for the STATEMENT column of SYSIBM.SYSVIEWSSYSTSXTMSYSIBM.SYSXMLTYPMOD tableDSNTMX01 (U)Contains rows about the XML type modifiers of XML columns. Rows in this table can be inserted, updated, and deleted.SYSTSXTSSYSIBM.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.SYSUSERSYSIBM.SYSUSERAUTH table
DSNAUH01 (N)
DSNAUX02 (N)Records the system privileges that are held by usersSYSXMLSYSIBM.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.
页:
[1]