DSNDB01: DB2 directoty database
DSNDB04: Store objects that users create without explicitly indicating the database the objects belong to
DSNDB06: DB2 catalog database
DSNDB07: Work file database but contains no permanent data, and can be deleted and redefined with the new qualifier
http://www.muraleedharan.com/mainframe_db2_catalog.html
DSNDB06:
- Table spaces and indexes
DB2 catalog tables are contained in certain table spaces and have indexes. - New and changed catalog tables
DB2 Version 9.1 for z/OS includes many new catalog tables as well as many catalog tables that have new or changed content. - SYSIBM.IPLIST table
The SYSIBM.IPLIST table allows multiple IP addresses to be specified for a given LOCATION. - SYSIBM.IPNAMES table
The SYSIBM.IPNAMES table defines the remote DRDA® servers DB2 can access using TCP/IP. - SYSIBM.LOCATIONS table
The SYSIBM.LOCATIONS table contains a row for every accessible remote server. The row associates a LOCATION name with the TCP/IP or SNA network attributes for the remote server. Requesters are not defined in this table. - SYSIBM.LULIST table
The SYSIBM.LULIST table allows multiple LU names to be specified for a given LOCATION. - SYSIBM.LUMODES table
Each row of the SYSIBM.LUMODES table provides VTAM® with conversation limits for a specific combination of LUNAME and MODENAME. The table is accessed only during the initial conversation limit negotiation between DB2 and a remote LU. This negotiation is called change-number-of-sessions (CNOS) processing. - SYSIBM.LUNAMES table
The SYSIBM.LUNAMES table must contain a row for each remote SNA client or server that communicates with DB2. - SYSIBM.MODESELECT table
The SYSIBM.MODESELECT table associates a mode name with any conversation created to support an outgoing SQL request. Each row represents one or more combinations of LUNAME, authorization ID, and application plan name. - SYSIBM.SYSAUXRELS table
The SYSIBM.SYSAUXRELS table contains one row for each auxiliary table created for a LOB column. A base table space that is partitioned must have one auxiliary table for each partition of each LOB column. - SYSIBM.SYSCHECKDEP table
The SYSIBM.SYSCHECKDEP table contains one row for each reference to a column in a check constraint. - SYSIBM.SYSCHECKS table
The SYSIBM.SYSCHECKS table contains one row for each check constraint. - SYSIBM.SYSCHECKS2 table
The SYSIBM.SYSCHECKS2 table contains one row for each check constraint for catalog tables created in or after Version 7. Check constraints for catalog tables created before Version 7 are not included in this table. - SYSIBM.SYSCOLAUTH table
The SYSIBM.SYSCOLAUTH table records the UPDATE or REFERENCES privileges that are held by users on individual columns of a table or view. - SYSIBM.SYSCOLDIST table
The SYSIBM.SYSCOLDIST table contains one or more rows for the first key column of an index key. - SYSIBM.SYSCOLDISTSTATS table
The SYSIBM.SYSCOLDISTSTATS table contains zero or more rows per partition for the first key column of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSCOLDIST_HIST table
The SYSIBM.SYSCOLDIST_HIST table contains rows from SYSCOLDIST. - SYSIBM.SYSCOLSTATS table
The SYSIBM.SYSCOLSTATS table contains partition statistics for selected columns. For each column, a row exists for each partition in the table. - SYSIBM.SYSCOLUMNS table
The SYSIBM.SYSCOLUMNS table contains one row for every column of each table and view. - SYSIBM.SYSCOLUMNS_HIST table
The SYSIBM.SYSCOLUMNS_HIST table contains rows from SYSCOLUMNS. - SYSIBM.SYSCONSTDEP table
The SYSIBM.SYSCONSTDEP table records dependencies on check constraints or user-defined defaults for a column. - SYSIBM.SYSCONTEXT table
The SYSIBM.SYSCONTEXT table contains one row for each trusted context. - SYSIBM.SYSCONTEXTAUTHIDS table
The SYSIBM.SYSCONTEXTAUTHIDS table contains one row for each authorization ID with which the trusted context can be used. - SYSIBM.SYSCOPY table
The SYSIBM.SYSCOPY table contains information needed for recovery. - SYSIBM.SYSCTXTTRUSTATTRS table
The SYSIBM.SYSCTXTTRUSTATTRS table contains one row for each list of attributes for a given trusted context. - SYSIBM.SYSDATABASE table
The SYSIBM.SYSDATABASE table contains one row for each database, except for database DSNDB01. - SYSIBM.SYSDATATYPES table
The SYSIBM.SYSDATATYPES table contains one row for each distinct type defined to the system. - SYSIBM.SYSDBAUTH table
The SYSIBM.SYSDBAUTH table records the privileges that are held by users over databases. - SYSIBM.SYSDBRM table
The SYSIBM.SYSDBRM table contains one row for each DBRM of each application plan. - SYSIBM.SYSDEPENDENCIES table
The SYSIBM.SYSDEPENDENCIES table records the dependencies between objects. - SYSIBM.SYSDUMMY1 table
The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important. - SYSIBM.SYSENVIRONMENT table
The SYSIBM.SYSENVIRONMENT table records the environment variables when an object is created. - SYSIBM.SYSFIELDS table
The SYSIBM.SYSFIELDS table contains one row for every column that has a field procedure. - SYSIBM.SYSFOREIGNKEYS table
The SYSIBM.SYSFOREIGNKEYS table contains one row for every column of every foreign key. - SYSIBM.SYSINDEXES table
The SYSIBM.SYSINDEXES table contains one row for every index. - SYSIBM.SYSINDEXES_HIST table
The SYSIBM.SYSINDEXES_HIST table contains rows from SYSINDEXES. - SYSIBM.SYSINDEXPART table
The SYSIBM.SYSINDEXPART table contains one row for each nonpartitioned secondary index (NPSI) and one row for each partition of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSINDEXPART_HIST table
The SYSIBM.SYSINDEXPART_HIST table contains rows from SYSINDEXPART. - SYSIBM.SYSINDEXSPACESTATS table
The SYSIBM.SYSINDEXSPACESTATS table contains real time statistics for index spaces. - SYSIBM.SYSINDEXSTATS table
The SYSIBM.SYSINDEXSTATS table contains one row for each partition of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSINDEXSTATS_HIST table
The SYSIBM.SYSINDEXSTATS_HIST table contains rows from SYSINDEXSTATS. - SYSIBM.SYSJARCLASS_SOURCE table
The SYSIBM.SYSJARCLASS_SOURCE table is an auxiliary table for SYSIBM.SYSJARCONTENTS. - SYSIBM.SYSJARCONTENTS table
The SYSIBM.SYSJARCONTENTS table contains Java™ class source for an installed JAR file. - SYSIBM.SYSJARDATA table
The SYSIBM.SYSJARDATA table is an auxiliary table for SYSIBM.SYSJAROBJECTS. - SYSIBM.SYSJAROBJECTS table
The SYSIBM.SYSJAROBJECTS table contains binary large object representing the installed JAR file. - SYSIBM.SYSJAVAOPTS table
The SYSIBM.SYSJAVAOPTS table contains build options used during INSTALL_JAR. - SYSIBM.SYSJAVAPATHS table
The SYSIBM.SYSJAVAPATHS table contains the complete class resolution path of a JAR file, and records the dependencies that one JAR file has on the JAR files in its Java path. - SYSIBM.SYSKEYCOLUSE table
The SYSIBM.SYSKEYCOLUSE table contains a row for every column in a unique constraint (primary key or unique key) from the SYSIBM.SYSTABCONST table. - SYSIBM.SYSKEYS table
The SYSIBM.SYSKEYS table contains one row for each column of an index key. - SYSIBM.SYSKEYTARGETS table
The SYSIBM.SYSKEYTARGETS table contains one row for each key-target that is participating in an extended index definition. - SYSIBM.SYSKEYTARGETSTATS table
The SYSIBM.SYSKEYTARGETSTATS table contains partition statistics for selected key-targets. For each key-target, a row exists for each partition in the table. - SYSIBM.SYSKEYTARGETS_HIST table
The SYSIBM.SYSKEYTARGETS_HIST table contains rows from the SYSKEYTARGETS table. - SYSIBM.SYSKEYTGTDIST table
The SYSIBM.SYSKEYTGTDIST table contains one or more rows for the first key-target of an extended index key. - SYSIBM.SYSKEYTGTDISTSTATS table
The SYSIBM.SYSKEYTGTDISTSTATS table contains zero or more rows per partition for the first key-target of a data-partitioned secondary index. - SYSIBM.SYSKEYTGTDIST_HIST table
The SYSIBM.SYSKEYTGTDIST_HIST table contains rows from the SYSKEYTGTDIST table. Whenever rows are added or changed in SYSKEYTGTDIST, the rows are also written to this table. - SYSIBM.SYSLOBSTATS table
The SYSIBM.SYSLOBSTATS table contains one row for each LOB table space. - SYSIBM.SYSLOBSTATS_HIST table
The SYSIBM.SYSLOBSTATS_HIST table contains rows from SYSIBM.SYSLOBSTATS. - SYSIBM.SYSOBJROLEDEP table
The SYSIBM.SYSOBJROLEDEP table lists the dependent objects for each role. - SYSIBM.SYSPACKAGE table
The SYSIBM.SYSPACKAGE table contains a row for every package. - SYSIBM.SYSPACKAUTH table
The SYSIBM.SYSPACKAUTH table records the privileges that are held by users over packages. - SYSIBM.SYSPACKDEP table
The SYSIBM.SYSPACKDEP table records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, functions, and stored procedures. - SYSIBM.SYSPACKLIST table
The SYSIBM.SYSPACKLIST table contains one or more rows for every local application plan bound with a package list. Each row represents a unique entry in the plan's package list. - SYSIBM.SYSPACKSTMT table
The SYSIBM.SYSPACKSTMT table contains one or more rows for each statement in a package. - SYSIBM.SYSPARMS table
The SYSIBM.SYSPARMS table contains a row for each parameter of a routine or multiple rows for table parameters (one for each column of the table). - SYSIBM.SYSPKSYSTEM table
The SYSIBM.SYSPKSYSTEM table contains zero or more rows for every package. Each row for a given package represents one or more connections to an environment in which the package could be executed. - SYSIBM.SYSPLAN table
The SYSIBM.SYSPLAN table contains one row for each application plan. - SYSIBM.SYSPLANAUTH table
The SYSIBM.SYSPLANAUTH table records the privileges that are held by users over application plans. - SYSIBM.SYSPLANDEP table
The SYSIBM.SYSPLANDEP table records the dependencies of plans on tables, views, aliases, synonyms, table spaces, indexes, functions, and stored procedures. - SYSIBM.SYSPLSYSTEM table
The SYSIBM.SYSPLSYSTEM table contains zero or more rows for every plan. Each row for a given plan represents one or more connections to an environment in which the plan could be used. - SYSIBM.SYSRELS table
The SYSIBM.SYSRELS table contains one row for every referential constraint. - SYSIBM.SYSRESAUTH table
The SYSIBM.SYSRESAUTH table records CREATE IN and PACKADM ON privileges for collections; USAGE privileges for distinct types; and USE privileges for buffer pools, storage groups, and table spaces. - SYSIBM.SYSROLES table
The SYSIBM.SYSROLES table contains one row for each role. - SYSIBM.SYSROUTINEAUTH table
The SYSIBM.SYSROUTINEAUTH table records the privileges that are held by users on routines. (A routine can be a user-defined function, cast function, or stored procedure.) - SYSIBM.SYSROUTINES table
The SYSIBM.SYSROUTINES table contains a row for every routine. (A routine can be a user-defined function, cast function, or stored procedure.) - SYSIBM.SYSROUTINESTEXT table
The SYSIBM.SYSROUTINESTEXT is an auxiliary table for the TEXT column of SYSIBM.SYSROUTINES and is required to hold the LOB data. - SYSIBM.SYSROUTINES_OPTS table
The SYSIBM.SYSROUTINES_OPTS table Contains a row for each generated routine, such as one created by DB2 for z/OS Procedure Processor DSNTPSMP, that records the build options for the routine. - SYSIBM.SYSROUTINES_SRC table
The SYSIBM.SYSROUTINES_SRC table contains source for generated routines, such as those created by DB2 for z/OS Procedure Processor DSNTPSMP. - SYSIBM.SYSSCHEMAAUTH table
The SYSIBM.SYSSCHEMAAUTH table contains one or more rows for each user that is granted a privilege on a particular schema in the database. - SYSIBM.SYSSEQUENCEAUTH table
The SYSIBM.SYSSEQUENCEAUTH table records the privileges that are held by users over sequences. - SYSIBM.SYSSEQUENCES table
The SYSIBM.SYSSEQUENCES table contains one row for each identity column or user-defined sequence. - SYSIBM.SYSSEQUENCESDEP table
The SYSIBM.SYSSEQUENCESDEP table records the dependencies of identity columns and sequences. - SYSIBM.SYSSTMT table
The SYSIBM.SYSSTMT table contains one or more rows for each SQL statement of each DBRM. - SYSIBM.SYSSTOGROUP table
The SYSIBM.SYSSTOGROUP table contains one row for each storage group. - SYSIBM.SYSSTRINGS table
The SYSIBM.SYSSTRINGS table contains information about character conversion. Each row describes a conversion from one coded character set to another. - SYSIBM.SYSSYNONYMS table
The SYSIBM.SYSSYNONYMS table contains one row for each synonym of a table or view. - SYSIBM.SYSTABAUTH table
The SYSIBM.SYSTABAUTH table records the privileges that users hold on tables and views. - SYSIBM.SYSTABCONST table
The SYSIBM.SYSTABCONST table contains one row for each unique constraint (primary key or unique key) created in DB2 Version 7 or later. - SYSIBM.SYSTABLEPART table
The SYSIBM.SYSTABLEPART table contains one row for each nonpartitioned table space and one row for each partition of a partitioned table space. - SYSIBM.SYSTABLEPART_HIST table
The SYSIBM.SYSTABLEPART_HIST table contains rows from SYSTABLEPART. - SYSIBM.SYSTABLES table
The SYSIBM.SYSTABLES table contains one row for each table, view, or alias. - SYSIBM.SYSTABLESPACE table
The SYSIBM.SYSTABLESPACE table contains one row for each table space. - SYSIBM.SYSTABLESPACESTATS table
The SYSIBM.SYSTABLESPACESTATS table contains real time statistics for table spaces. - SYSIBM.SYSTABLES_HIST table
The SYSIBM.SYSTABLES_HIST table contains rows from SYSTABLES. - SYSIBM.SYSTABSTATS table
The SYSIBM.SYSTABSTATS table contains one row for each partition of a partitioned table space. - SYSIBM.SYSTABSTATS_HIST table
The SYSIBM.SYSTABSTATS_HIST table contains rows from SYSTABSTATS. - SYSIBM.SYSTRIGGERS table
The SYSIBM.SYSTRIGGERS table contains one row for each trigger. - SYSIBM.SYSUSERAUTH table
The SYSIBM.SYSUSERAUTH table records the system privileges that are held by users. - SYSIBM.SYSVIEWDEP table
The SYSIBM.SYSVIEWDEP table records the dependencies of views on tables, functions, and other views. - SYSIBM.SYSVIEWS table
The SYSIBM.SYSVIEWS table contains one or more rows for each view, materialized query table, or user-defined SQL function. - SYSIBM.SYSVOLUMES table
The SYSIBM.SYSVOLUMES table contains one row for each volume of each storage group. - SYSIBM.SYSXMLRELS table
The SYSIBM.SYSXMLRELS table contains one row for each XML table that is created for an XML column. - SYSIBM.SYSXMLSTRINGS table
Each row of the SYSIBM.SYSXMLSTRINGS table contains a single string and its unique ID that are used to condense XML data. The string can be an element name, attribute name, name space prefix, or a namespace URI. - SYSIBM.USERNAMES table
Each row in the SYSIBM.USERNAMES table is used to carry out one outbound ID translation or inbound ID translation and "come from" checking. - SYSIBM.XSRCOMPONENT table
The SYSIBM.XSRCOMPONENT table is an auxiliary table for the BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS. It is in LOB table space SYSXSRA3. - SYSIBM.XSROBJECTS table
The SYSIBM.XSROBJECTS table contains one row for each registered XML schema. - SYSIBM.XSROBJECTCOMPONENTS table
The SYSIBM.XSROBJECTCOMPONENTS table contains one row for each component (document) in an XML schema. - SYSIBM.XSROBJECTGRAMMAR table
SYSIBM.XSROBJECTGRAMMAR is an auxiliary table for the BLOB column GRAMMAR in SYSIBM.SYSXSROBJECTS. It is in LOB table space SYSXSRA1. - SYSIBM.XSROBJECTHIERARCHIES table
The SYSIBM.XSROBJECTHIERARCHIES table contains one row for each component (document) in an XML schema to record the XML schema document hierarchy relationship. - SYSIBM.XSROBJECTPROPERTY table
SYSIBM.XSROBJECTPROPERTY is an auxiliary table for the BLOB column PROPERTIES in SYSIBM.SYSXSROBJECTS. It is in LOB table space SYSXSRA2. - SYSIBM.XSRPROPERTY table
The SYSIBM.XSRPROPERTY table is an auxiliary table for the BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS. It is in LOB table space SYSXSRA3. - Table spaces and indexes
DB2 catalog tables are contained in certain table spaces and have indexes. - New and changed catalog tables
DB2 Version 9.1 for z/OS includes many new catalog tables as well as many catalog tables that have new or changed content. - SYSIBM.IPLIST table
The SYSIBM.IPLIST table allows multiple IP addresses to be specified for a given LOCATION. - SYSIBM.IPNAMES table
The SYSIBM.IPNAMES table defines the remote DRDA servers DB2 can access using TCP/IP. - SYSIBM.LOCATIONS table
The SYSIBM.LOCATIONS table contains a row for every accessible remote server. The row associates a LOCATION name with the TCP/IP or SNA network attributes for the remote server. Requesters are not defined in this table. - SYSIBM.LULIST table
The SYSIBM.LULIST table allows multiple LU names to be specified for a given LOCATION. - SYSIBM.LUMODES table
Each row of the SYSIBM.LUMODES table provides VTAM with conversation limits for a specific combination of LUNAME and MODENAME. The table is accessed only during the initial conversation limit negotiation between DB2 and a remote LU. This negotiation is called change-number-of-sessions (CNOS) processing. - SYSIBM.LUNAMES table
The SYSIBM.LUNAMES table must contain a row for each remote SNA client or server that communicates with DB2. - SYSIBM.MODESELECT table
The SYSIBM.MODESELECT table associates a mode name with any conversation created to support an outgoing SQL request. Each row represents one or more combinations of LUNAME, authorization ID, and application plan name. - SYSIBM.SYSAUXRELS table
The SYSIBM.SYSAUXRELS table contains one row for each auxiliary table created for a LOB column. A base table space that is partitioned must have one auxiliary table for each partition of each LOB column. - SYSIBM.SYSCHECKDEP table
The SYSIBM.SYSCHECKDEP table contains one row for each reference to a column in a check constraint. - SYSIBM.SYSCHECKS table
The SYSIBM.SYSCHECKS table contains one row for each check constraint. - SYSIBM.SYSCHECKS2 table
The SYSIBM.SYSCHECKS2 table contains one row for each check constraint for catalog tables created in or after Version 7. Check constraints for catalog tables created before Version 7 are not included in this table. - SYSIBM.SYSCOLAUTH table
The SYSIBM.SYSCOLAUTH table records the UPDATE or REFERENCES privileges that are held by users on individual columns of a table or view. - SYSIBM.SYSCOLDIST table
The SYSIBM.SYSCOLDIST table contains one or more rows for the first key column of an index key. - SYSIBM.SYSCOLDISTSTATS table
The SYSIBM.SYSCOLDISTSTATS table contains zero or more rows per partition for the first key column of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSCOLDIST_HIST table
The SYSIBM.SYSCOLDIST_HIST table contains rows from SYSCOLDIST. - SYSIBM.SYSCOLSTATS table
The SYSIBM.SYSCOLSTATS table contains partition statistics for selected columns. For each column, a row exists for each partition in the table. - SYSIBM.SYSCOLUMNS table
The SYSIBM.SYSCOLUMNS table contains one row for every column of each table and view. - SYSIBM.SYSCOLUMNS_HIST table
The SYSIBM.SYSCOLUMNS_HIST table contains rows from SYSCOLUMNS. - SYSIBM.SYSCONSTDEP table
The SYSIBM.SYSCONSTDEP table records dependencies on check constraints or user-defined defaults for a column. - SYSIBM.SYSCONTEXT table
The SYSIBM.SYSCONTEXT table contains one row for each trusted context. - SYSIBM.SYSCONTEXTAUTHIDS table
The SYSIBM.SYSCONTEXTAUTHIDS table contains one row for each authorization ID with which the trusted context can be used. - SYSIBM.SYSCOPY table
The SYSIBM.SYSCOPY table contains information needed for recovery. - SYSIBM.SYSCTXTTRUSTATTRS table
The SYSIBM.SYSCTXTTRUSTATTRS table contains one row for each list of attributes for a given trusted context. - SYSIBM.SYSDATABASE table
The SYSIBM.SYSDATABASE table contains one row for each database, except for database DSNDB01. - SYSIBM.SYSDATATYPES table
The SYSIBM.SYSDATATYPES table contains one row for each distinct type defined to the system. - SYSIBM.SYSDBAUTH table
The SYSIBM.SYSDBAUTH table records the privileges that are held by users over databases. - SYSIBM.SYSDBRM table
The SYSIBM.SYSDBRM table contains one row for each DBRM of each application plan. - SYSIBM.SYSDEPENDENCIES table
The SYSIBM.SYSDEPENDENCIES table records the dependencies between objects. - SYSIBM.SYSDUMMY1 table
The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important. - SYSIBM.SYSENVIRONMENT table
The SYSIBM.SYSENVIRONMENT table records the environment variables when an object is created. - SYSIBM.SYSFIELDS table
The SYSIBM.SYSFIELDS table contains one row for every column that has a field procedure. - SYSIBM.SYSFOREIGNKEYS table
The SYSIBM.SYSFOREIGNKEYS table contains one row for every column of every foreign key. - SYSIBM.SYSINDEXES table
The SYSIBM.SYSINDEXES table contains one row for every index. - SYSIBM.SYSINDEXES_HIST table
The SYSIBM.SYSINDEXES_HIST table contains rows from SYSINDEXES. - SYSIBM.SYSINDEXPART table
The SYSIBM.SYSINDEXPART table contains one row for each nonpartitioned secondary index (NPSI) and one row for each partition of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSINDEXPART_HIST table
The SYSIBM.SYSINDEXPART_HIST table contains rows from SYSINDEXPART. - SYSIBM.SYSINDEXSPACESTATS table
The SYSIBM.SYSINDEXSPACESTATS table contains real time statistics for index spaces. - SYSIBM.SYSINDEXSTATS table
The SYSIBM.SYSINDEXSTATS table contains one row for each partition of a partitioning index or a data-partitioned secondary index. - SYSIBM.SYSINDEXSTATS_HIST table
The SYSIBM.SYSINDEXSTATS_HIST table contains rows from SYSINDEXSTATS. - SYSIBM.SYSJARCLASS_SOURCE table
The SYSIBM.SYSJARCLASS_SOURCE table is an auxiliary table for SYSIBM.SYSJARCONTENTS. - SYSIBM.SYSJARCONTENTS table
The SYSIBM.SYSJARCONTENTS table contains Java class source for an installed JAR file. - SYSIBM.SYSJARDATA table
The SYSIBM.SYSJARDATA table is an auxiliary table for SYSIBM.SYSJAROBJECTS. - SYSIBM.SYSJAROBJECTS table
The SYSIBM.SYSJAROBJECTS table contains binary large object representing the installed JAR file. - SYSIBM.SYSJAVAOPTS table
The SYSIBM.SYSJAVAOPTS table contains build options used during INSTALL_JAR. - SYSIBM.SYSJAVAPATHS table
The SYSIBM.SYSJAVAPATHS table contains the complete class resolution path of a JAR file, and records the dependencies that one JAR file has on the JAR files in its Java path. - SYSIBM.SYSKEYCOLUSE table
The SYSIBM.SYSKEYCOLUSE table contains a row for every column in a unique constraint (primary key or unique key) from the SYSIBM.SYSTABCONST table. - SYSIBM.SYSKEYS table
The SYSIBM.SYSKEYS table contains one row for each column of an index key. - SYSIBM.SYSKEYTARGETS table
The SYSIBM.SYSKEYTARGETS table contains one row for each key-target that is participating in an extended index definition. - SYSIBM.SYSKEYTARGETSTATS table
The SYSIBM.SYSKEYTARGETSTATS table contains partition statistics for selected key-targets. For each key-target, a row exists for each partition in the table. - SYSIBM.SYSKEYTARGETS_HIST table
The SYSIBM.SYSKEYTARGETS_HIST table contains rows from the SYSKEYTARGETS table. - SYSIBM.SYSKEYTGTDIST table
The SYSIBM.SYSKEYTGTDIST table contains one or more rows for the first key-target of an extended index key. - SYSIBM.SYSKEYTGTDISTSTATS table
The SYSIBM.SYSKEYTGTDISTSTATS table contains zero or more rows per partition for the first key-target of a data-partitioned secondary index. - SYSIBM.SYSKEYTGTDIST_HIST table
The SYSIBM.SYSKEYTGTDIST_HIST table contains rows from the SYSKEYTGTDIST table. Whenever rows are added or changed in SYSKEYTGTDIST, the rows are also written to this table. - SYSIBM.SYSLOBSTATS table
The SYSIBM.SYSLOBSTATS table contains one row for each LOB table space. - SYSIBM.SYSLOBSTATS_HIST table
The SYSIBM.SYSLOBSTATS_HIST table contains rows from SYSIBM.SYSLOBSTATS. - SYSIBM.SYSOBJROLEDEP table
The SYSIBM.SYSOBJROLEDEP table lists the dependent objects for each role. - SYSIBM.SYSPACKAGE table
The SYSIBM.SYSPACKAGE table contains a row for every package. - SYSIBM.SYSPACKAUTH table
The SYSIBM.SYSPACKAUTH table records the privileges that are held by users over packages. - SYSIBM.SYSPACKDEP table
The SYSIBM.SYSPACKDEP table records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, functions, and stored procedures. - SYSIBM.SYSPACKLIST table
The SYSIBM.SYSPACKLIST table contains one or more rows for every local application plan bound with a package list. Each row represents a unique entry in the plan's package list. - SYSIBM.SYSPACKSTMT table
The SYSIBM.SYSPACKSTMT table contains one or more rows for each statement in a package. - SYSIBM.SYSPARMS table
The SYSIBM.SYSPARMS table contains a row for each parameter of a routine or multiple rows for table parameters (one for each column of the table). - SYSIBM.SYSPKSYSTEM table
The SYSIBM.SYSPKSYSTEM table contains zero or more rows for every package. Each row for a given package represents one or more connections to an environment in which the package could be executed. - SYSIBM.SYSPLAN table
The SYSIBM.SYSPLAN table contains one row for each application plan. - SYSIBM.SYSPLANAUTH table
The SYSIBM.SYSPLANAUTH table records the privileges that are held by users over application plans. - SYSIBM.SYSPLANDEP table
The SYSIBM.SYSPLANDEP table records the dependencies of plans on tables, views, aliases, synonyms, table spaces, indexes, functions, and stored procedures. - SYSIBM.SYSPLSYSTEM table
The SYSIBM.SYSPLSYSTEM table contains zero or more rows for every plan. Each row for a given plan represents one or more connections to an environment in which the plan could be used. - SYSIBM.SYSRELS table
The SYSIBM.SYSRELS table contains one row for every referential constraint. - SYSIBM.SYSRESAUTH table
The SYSIBM.SYSRESAUTH table records CREATE IN and PACKADM ON privileges for collections; USAGE privileges for distinct types; and USE privileges for buffer pools, storage groups, and table spaces. - SYSIBM.SYSROLES table
The SYSIBM.SYSROLES table contains one row for each role. - SYSIBM.SYSROUTINEAUTH table
The SYSIBM.SYSROUTINEAUTH table records the privileges that are held by users on routines. (A routine can be a user-defined function, cast function, or stored procedure.) - SYSIBM.SYSROUTINES table
The SYSIBM.SYSROUTINES table contains a row for every routine. (A routine can be a user-defined function, cast function, or stored procedure.) - SYSIBM.SYSROUTINESTEXT table
The SYSIBM.SYSROUTINESTEXT is an auxiliary table for the TEXT column of SYSIBM.SYSROUTINES and is required to hold the LOB data. - SYSIBM.SYSROUTINES_OPTS table
The SYSIBM.SYSROUTINES_OPTS table Contains a row for each generated routine, such as one created by DB2 for z/OS Procedure Processor DSNTPSMP, that records the build options for the routine. - SYSIBM.SYSROUTINES_SRC table
The SYSIBM.SYSROUTINES_SRC table contains source for generated routines, such as those created by DB2 for z/OS Procedure Processor DSNTPSMP. - SYSIBM.SYSSCHEMAAUTH table
The SYSIBM.SYSSCHEMAAUTH table contains one or more rows for each user that is granted a privilege on a particular schema in the database. - SYSIBM.SYSSEQUENCEAUTH table
The SYSIBM.SYSSEQUENCEAUTH table records the privileges that are held by users over sequences. - SYSIBM.SYSSEQUENCES table
The SYSIBM.SYSSEQUENCES table contains one row for each identity column or user-defined sequence. - SYSIBM.SYSSEQUENCESDEP table
The SYSIBM.SYSSEQUENCESDEP table records the dependencies of identity columns and sequences. - SYSIBM.SYSSTMT table
The SYSIBM.SYSSTMT table contains one or more rows for each SQL statement of each DBRM. - SYSIBM.SYSSTOGROUP table
The SYSIBM.SYSSTOGROUP table contains one row for each storage group. - SYSIBM.SYSSTRINGS table
The SYSIBM.SYSSTRINGS table contains information about character conversion. Each row describes a conversion from one coded character set to another. - SYSIBM.SYSSYNONYMS table
The SYSIBM.SYSSYNONYMS table contains one row for each synonym of a table or view. - SYSIBM.SYSTABAUTH table
The SYSIBM.SYSTABAUTH table records the privileges that users hold on tables and views. - SYSIBM.SYSTABCONST table
The SYSIBM.SYSTABCONST table contains one row for each unique constraint (primary key or unique key) created in DB2 Version 7 or later. - SYSIBM.SYSTABLEPART table
The SYSIBM.SYSTABLEPART table contains one row for each nonpartitioned table space and one row for each partition of a partitioned table space. - SYSIBM.SYSTABLEPART_HIST table
The SYSIBM.SYSTABLEPART_HIST table contains rows from SYSTABLEPART. - SYSIBM.SYSTABLES table
The SYSIBM.SYSTABLES table contains one row for each table, view, or alias. - SYSIBM.SYSTABLESPACE table
The SYSIBM.SYSTABLESPACE table contains one row for each table space. - SYSIBM.SYSTABLESPACESTATS table
The SYSIBM.SYSTABLESPACESTATS table contains real time statistics for table spaces. - SYSIBM.SYSTABLES_HIST table
The SYSIBM.SYSTABLES_HIST table contains rows from SYSTABLES. - SYSIBM.SYSTABSTATS table
The SYSIBM.SYSTABSTATS table contains one row for each partition of a partitioned table space. - SYSIBM.SYSTABSTATS_HIST table
The SYSIBM.SYSTABSTATS_HIST table contains rows from SYSTABSTATS. - SYSIBM.SYSTRIGGERS table
The SYSIBM.SYSTRIGGERS table contains one row for each trigger. - SYSIBM.SYSUSERAUTH table
The SYSIBM.SYSUSERAUTH table records the system privileges that are held by users. - SYSIBM.SYSVIEWDEP table
The SYSIBM.SYSVIEWDEP table records the dependencies of views on tables, functions, and other views. - SYSIBM.SYSVIEWS table
The SYSIBM.SYSVIEWS table contains one or more rows for each view, materialized query table, or user-defined SQL function. - SYSIBM.SYSVOLUMES table
The SYSIBM.SYSVOLUMES table contains one row for each volume of each storage group. - SYSIBM.SYSXMLRELS table
The SYSIBM.SYSXMLRELS table contains one row for each XML table that is created for an XML column. - SYSIBM.SYSXMLSTRINGS table
Each row of the SYSIBM.SYSXMLSTRINGS table contains a single string and its unique ID that are used to condense XML data. The string can be an element name, attribute name, name space prefix, or a namespace URI. - SYSIBM.USERNAMES table
Each row in the SYSIBM.USERNAMES table is used to carry out one outbound ID translation or inbound ID translation and "come from" checking. - SYSIBM.XSRCOMPONENT table
The SYSIBM.XSRCOMPONENT table is an auxiliary table for the BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS. It is in LOB table space SYSXSRA3. - SYSIBM.XSROBJECTS table
The SYSIBM.XSROBJECTS table contains one row for each registered XML schema. - SYSIBM.XSROBJECTCOMPONENTS table
The SYSIBM.XSROBJECTCOMPONENTS table contains one row for each component (document) in an XML schema. - SYSIBM.XSROBJECTGRAMMAR table
SYSIBM.XSROBJECTGRAMMAR is an auxiliary table for the BLOB column GRAMMAR in SYSIBM.SYSXSROBJECTS. It is in LOB table space SYSXSRA1. - SYSIBM.XSROBJECTHIERARCHIES table
The SYSIBM.XSROBJECTHIERARCHIES table contains one row for each component (document) in an XML schema to record the XML schema document hierarchy relationship. - SYSIBM.XSROBJECTPROPERTY table
SYSIBM.XSROBJECTPROPERTY is an auxiliary table for the BLOB column PROPERTIES in SYSIBM.SYSXSROBJECTS. It is in LOB table space SYSXSRA2. - SYSIBM.XSRPROPERTY table
The SYSIBM.XSRPROPERTY table is an auxiliary table for the BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS. It is in LOB table space SYSXSRA3.
DSNDB01:
Table space name | Description |
---|---|
SCT02 | Contains the internal form of SQL statements that are contained in an application. When you bind a plan, DB2 creates a structure in SCT02. |
SPT01 | Contains the internal form of SQL statements that are contained in a package. |
SYSLGRNX | Tracks the opening and closing of table spaces, indexes, or partitions. By tracking this information and associating it with relative byte addresses (RBAs) as contained in the DB2 log, DB2 can reduce recovery time by reducing the amount of log that must be scanned for a particular table space, index, or partition. |
SYSUTILX | Contains a row for every utility job that is running. The row persists until the utility is finished. If the utility terminates without completing, DB2 uses the information in the row when you restart the utility. |
DBD01 | Contains internal information, called database descriptors (DBDs), about the databases that exist within the DB2 subsystem. Each database has exactly one corresponding DBD that describes the database, table spaces, tables, table check constraints, indexes, and referential relationships. A DBD also contains other information about accessing tables in the database. DB2 creates and updates DBDs whenever their corresponding databases are created or updated. |