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.html

 

Table spaceTableIndexes (Type1 )Description
SYSALTER SYSOBDS
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
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.
Start of change End of change Start of changeSYSIBM.SYSDUMMYE tableEnd of change Start of change—End of change Start of changeContains 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.End of change
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
Start of changeSYSPLUXBEnd of change Start of changeSYSIBM.SYSROUTINES_TREE tableEnd of change Start of changeDSNPLX02 (A)End of change Start of changeContains the LOB data for the PARSETREE column of SYSIBM.SYSROUTINES.End of change
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
Start of changeSYSRTSTSEnd of change Start of changeSYSIBM.SYSTABLESPACESTATS tableEnd of change Start of changeDSNRTX01 (U)End of change Start of changeContains real-time statistics for table spaces.End of change
Start of change End of change Start of changeSYSIBM.SYSINDEXSPACESTATS tableEnd of change Start of change
DSNRTX02 (U)
DSNRTX03 (N)
End of change		 Start of changeContains real-time statistics for index spaces.End of change
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
Start of changeSYSSTREnd of change Start of changeSYSIBM.SYSCHECKDEP tableEnd of change Start of changeDSNSDX01 (U)End of change Start of changeContains one row for each reference to a column in a table check constraintEnd of change
Start of change End of change Start of changeSYSIBM.SYSCHECKS tableEnd of change Start of changeDSNSCX01 (UC)End of change Start of changeContains one row for each table check constraintEnd of change
Start of change End of change Start of changeSYSIBM.SYSCHECKS2 tableEnd of change Start of changeDSNCHX01 (UC)End of change Start of changeContains one row for each table check constraintEnd of change
  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
Start of changeSYSTSADTEnd of change Start of changeSYSIBM.SYSAUDITPOLICIES tableEnd of change Start of changeDSNAPX03 (UC)End of change Start of changeEach row represents an audit policy. End of change
Start of changeSYSTSASCEnd of change Start of changeSYSIBM.SYSDUMMYA tableEnd of change Start of change—End of change Start of changeContains 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.End of change
Start of changeSYSTSATSEnd of change Start of changeSYSIBM.SYSAUTOALERTS tableEnd of change Start of change
DSNALX01 (UC)
DSNALX02 (N)
DSNALX03 (N)
DSNALX04 (N)
DSNALX05 (N)
DSNALX06 (N)
End of change		 Start of changeContains a row for each recommendation from the autonomic proceduresEnd of change
Start of changeSYSTSATWEnd of change Start of changeSYSIBM.SYSAUTOTIMEWINDOWS tableEnd of change Start of changeDSNTWX01 (UC)End of change Start of changeContains a row for each time period during which autonomic procedures can be runEnd of change
Start of changeSYSTSATXEnd of change Start of changeSYSIBM.SYSAUTOALERTS_OUT tableEnd of change Start of changeDSNALX07 (A)End of change Start of changeContains the LOB data for the OUTPUT column of SYSIBM.SYSAUTOALERTSEnd of change
SYSTSAUX SYSIBM.SYSAUXRELS table Start of change
DSNOXX01 (NC)
DSNOXX02 (N)
End of change		 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
Start of changeSYSTSCTDEnd of change Start of changeSYSCONTROLS_DESCEnd of change Start of changeDSNTRX02 (A)End of change Start of changeContains the LOB data for the DESCRIPTOR column of SYSIBM.SYSCONTROLSEnd of change
Start of changeSYSTSCTLEnd of change Start of changeSYSIBM.SYSCONTROLS tableEnd of change Start of change
DSNCLX01 (U)
DSNCLX02 (U)
DSNCLX03 (N)
DSNCLX04 (N)
DSNCLX05 (N)
End of change		 Start of changeContains one row for each row permission and column mask. End of change
Start of changeSYSTSCTREnd of change Start of changeSYSCONTROLS_RTXTEnd of change Start of changeDSNTRX01 (A)End of change Start of changeContains the LOB data for the RULETEXT column of SYSIBM.SYSCONTROLS.End of change
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
Start of changeSYSTSIXREnd of change Start of changeSYSIBM.SYSINDEXES_RTSECT tableEnd of change Start of changeDSNDXX06 (A)End of change Start of changeContains the LOB data for the RTSECTION column of SYSIBM.SYSINDEXES.End of change
SYSTSIXS SYSIBM.SYSINDEXES table
DSNDXX01 (U)
DSNDXX02 (U)
DSNDXX03 (U)
DSNDXX04 (N)
DSNDXX07
 Contains one row for every index
Start of changeSYSTSIXTEnd of change Start of changeSYSIBM.SYSINDEXES_TREE tableEnd of change Start of changeDSNDXX05 (A)End of change Start of changeContains the LOB data for the PARSETREE column of SYSIBM.SYSINDEXES.End of change
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)
Start of changeSYSTSPDOEnd of change Start of changeSYSIBM.SYSPENDINGOBJECTS tableEnd of change Start of change
DSNPOX01 (N)
DSNPOX02 (N)
DSNPOX03 (N)
End of change		 Start of changeContains 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. End of change
Start of changeSYSTSPDTEnd of change Start of changeSYSPENDINGDDLTEXTEnd of change Start of changeDSNPDX03 (A)End of change Start of changeContains the LOB data for the STATEMENT_TEXT column of SYSIBM.SYSPENDINGDDL.End of change
Start of changeSYSTSPENEnd of change Start of changeSYSIBM.SYSPENDINGDDL tableEnd of change Start of change
DSNPDX01 (N)
DSNPDX02 (N)
End of change		 Start of changeContains 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. End of change
Start of changeSYSTSPHXEnd of change Start of changeSYSIBM.SYSAUTORUNS_HISTOU tableEnd of change Start of changeDSNPHX04 (A)End of change Start of changeContains the LOB data for the OUTPUT column of SYSIBM.SYSAUTORUNS_HISTEnd of change
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
Start of changeSYSTSPKXEnd of change Start of changeSYSIBM.SYSPACKSTMT_STMT tableEnd of change Start of changeDSNPKX01 (A)End of change Start of changeContains the LOB data for the STATEMENT column of SYSIBM.SYSPACKSTMT.End of change
Start of changeSYSTSPKYEnd of change Start of changeSYSIBM.SYSPKSYSTEM tableEnd of change Start of changeDSNKYX01 (N)End of change Start of changeContain one row of system information for each packageEnd of change
Start of changeSYSTSPLAEnd of change Start of changeSYSIBM.SYSPLANAUTH tableEnd of change Start of change
DSNAPH01 (N)
DSNAPX01 (N)
DSNAPX02 (N)
End of change		 Start of changeRecords the privileges that are held by users over application plansEnd of change
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
Start of changeSYSTSPRHEnd of change Start of changeSYSIBM.SYSAUTORUNS_HIST tableEnd of change Start of change
DSNPHX01 (UC)
DSNPHX02 (N)
DSNPHX03 (N)
End of change		 Start of changeContains a row for each execution of an autonomic procedure.End of change
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
Start of changeSYSTSPTXEnd of change Start of changeSYSIBM.SYSTABLES_PROFILE_TEXT tableEnd of change Start of changeDSNPRX02 (UC)End of change Start of changeContains the LOB data for the PROFILE_TEXT column of SYSIBM.SYSTABLES_PROFILESEnd of change
Start of changeSYSTSPVREnd of change Start of changeSYSIBM.SYSPACKSTMT_STMB tableEnd of change Start of changeDSNKSX02 (A)End of change Start of changeContains the LOB data for the STMTBLOB column of SYSIBM.SYSPACKSTMT.End of change
Start of changeSYSTSQRAEnd of change Start of changeSYSIBM.SYSQUERY_AUX tableEnd of change Start of changeDSNQSX01 (A)End of change Start of changeContains the LOB data for the STMTTEXT column of SYSIBM.SYSQUERYEnd of change
Start of changeSYSTSQROEnd of change Start of changeSYSIBM.SYSQUERYOPTS tableEnd of change Start of changeDSNQPX01 (N)End of change Start of changeContains optimization parameters for the queries in SYSIBM.SYSQUERY.End of change
Start of changeSYSTSQRPEnd of change Start of changeSYSIBM.SYSQUERYPLAN tableEnd of change Start of changeDSNQNX01 (N)End of change Start of changeContains the plan hint information for the queries in the SYSIBM.SYSQUERY tableEnd of change
Start of changeSYSTSQRYEnd of change Start of changeSYSIBM.SYSQUERY tableEnd of change Start of change
DSNQYX01 (N)
DSNQYX02 (U)
DSNQYX03 (N)
End of change		 Start of changeContains a set of queriesEnd of change
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
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 Version 7 or later
Start of changeSYSTSTPFEnd of change Start of changeSYSIBM.SYSTABLES_PROFILES tableEnd of change Start of changeDSNPRX01 (UC)End of change Start of changeContains a row for each profile that is associated with a table in SYSIBM.SYSTABLESEnd of change
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
Start of changeSYSTSTRTEnd of change Start of changeSYSIBM.SYSTRIGGERS_STMT tableEnd of change Start of changeDSNOTX04 (A)End of change Start of changeContains the LOB data for the STATEMENT column of SYSIBM.SYSTRIGGERSEnd of change
SYSTSTSP SYSIBM.SYSTABLESPACE table DSNDSX01 (U) Contains one row for each table space
Start of changeSYSTSUNIEnd of change Start of changeSYSIBM.SYSDUMMYU tableEnd of change Start of change—End of change Start of changeContains 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.End of change
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
Start of changeSYSTSVTREnd of change Start of changeSYSIBM.SYSVIEWS_TREE tableEnd of change Start of changeDSNVWX02 (A)End of change Start of changeContains the LOB data for the PARSETREE column of SYSIBM.SYSVIEWSEnd of change
SYSTSVWD SYSIBM.SYSVIEWDEP table
DSNGGX02 (N)
DSNGGX03 (N)
DSNGGX04 (N)
DSNGGX06
 Records the dependencies of views on tables and other views
Start of changeSYSTSVWTEnd of change Start of changeSYSIBM.SYSVIEWS_STMT tableEnd of change Start of changeDSNVWX01 (A)End of change Start of changeContains the LOB data for the STATEMENT column of SYSIBM.SYSVIEWSEnd of change
Start of changeSYSTSXTMEnd of change Start of changeSYSIBM.SYSXMLTYPMOD tableEnd of change Start of changeDSNTMX01 (U)End of change Start of changeContains rows about the XML type modifiers of XML columns. Rows in this table can be inserted, updated, and deleted.End of change
Start of changeSYSTSXTSEnd of change Start of changeSYSIBM.SYSXMLTYPMSCHEMA tableEnd of change Start of change
DSNMSX01 (U)
DSNMSX02 (N)
End of change		 Start of changeContain 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.End of change
Start of changeSYSUSEREnd of change Start of changeSYSIBM.SYSUSERAUTH tableEnd of change Start of change
DSNAUH01 (N)
DSNAUX02 (N)
End of change		 Start of changeRecords the system privileges that are held by usersEnd of change
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.
posted @ 2016-06-17 10:32  盛小胖  阅读(584)  评论(0)  编辑  收藏  举报