O indicador de dependência da liberação, que está listado nas colunas IBMREQD, RELCREATED e RELBOUND das tabelas do catálogo, mostra a liberação do Db2 da qual
os objetos dependem.
Indicadores de dependência de liberação em IBMREQD, RELCREATED e RELBOUND são definidos pelos seguintes valores:
Nem todas as colunas da tabela do catálogo fazem parte da interface de programação de uso geral.
Se uma coluna faz parte desta interface, é indicado em uma coluna rotulada como Usar na tabela que descreve a coluna.
.
Os valores que Use pode assumir são os seguintes:
Para colunas para as quais Use é N ou I, o nome da coluna e sua descrição não aparecem na explicação da coluna.
| Tabelas |
Table space |
Indexes
(Type2 ) |
Descrição |
| IPLIST |
SYSDDF |
DSNDUX01 (U) |
Contains a row for each IP address that corresponds to a remote DRDA server |
| IPNAMES |
SYSDDF |
DSNFPX01 (UC) |
Contains a row for each remote DRDA server that Db2 can access using TCP/IP |
| LOCATIONS |
SYSDDF |
DSNFCX01 (UC) |
Contains a row for every accessible remote server |
| LULIST |
SYSDDF |
DSNFLX01
DSNFLX02
|
Contains a row for each real LU name that is associated with the dummy LU name for a data sharing group |
| LUMODES |
SYSDDF |
DSNFMX01 (UC) |
Contains a row for the conversation limit for each combination of LU name and VTAM® logon mode description |
| LUNAMES |
SYSDDF |
DSNFNX01 (UC) |
Contains a row for each remote SNA client or server |
| MODESELECT |
SYSDDF |
DSNFDX01 (UC) |
Contains a row for each VTAM logon mode and combination of authorization ID, plan name, and LU name |
| SYSAUDITPOLICIES |
SYSTSADT |
DSNAPX03 (UC) |
Each row represents an audit policy. |
| SYSAUDITPOLICIES_H |
SYSTSADH |
— |
Not used. |
| SYSAUTOALERTS |
SYSTSATS |
DSNALX01 (UC)
DSNALX02 (N)
DSNALX03 (N)
DSNALX04 (N)
DSNALX05 (N)
DSNALX06 (N) |
Contains a row for each recommendation from the autonomic procedures |
| SYSAUTOALERTS_OUT |
SYSTSATX |
DSNALX07 (A) |
Contains the LOB data for the OUTPUT column of sysibm_.SYSAUTOALERTS |
| SYSAUTORUNS_HIST |
SYSTSPRH |
DSNPHX01 (UC)
DSNPHX02 (N)
DSNPHX03 (N)
|
Contains a row for each execution of an autonomic procedure. |
| SYSAUTORUNS_HISTOU |
SYSTSPHX |
DSNPHX04 (A) |
Contains the LOB data for the OUTPUT column of sysibm_.SYSAUTORUNS_HIST |
| SYSAUTOTIMEWINDOWS |
SYSTSATW |
DSNTWX01 (UC) |
Contains a row for each time period during which autonomic procedures can be run |
| SYSAUXRELS |
SYSTSAUX |
DSNOXX01 (NC)
DSNOXX02 (N) |
Contains one row for each auxiliary table for a LOB column |
| SYSCHECKDEP |
SYSTSCKD |
DSNSDX01 (UC) |
Contains one row for each reference to a column in a table check constraint |
| SYSCHECKS2 |
SYSTSCHX |
DSNCHX01 (UC) |
Contains one row for each table check constraint |
| SYSCHECKS |
SYSTSCKS |
DSNSCX01 (UC) |
Contains one row for each table check constraint |
| SYSCOLAUTH |
SYSTSFAU |
DSNACX01 (N)
DSNACX02 (N)
DSNACX03 (N)
DSNACX04 (N) |
Records the UPDATE privileges that are held by users on individual columns of a table or view |
| SYSCOLAUTH_H |
SYSTSFAH |
|
Not used. |
| SYSCOLDIST |
SYSSTATS |
DSNTNX01 (NC) |
Contains cardinality, frequency, and histogram statistics for a single column or a column group. |
| SYSCOLDIST_HIST |
SYSHIST |
DSNHFX01 (N) |
Contains accumulated rows from SYSCOLDIST |
| SYSCOLDISTSTATS |
SYSSTATS |
DSNTPX01 (NC) |
Contains cardinality, frequency, and histogram statistics for a single column or a column group.
Each partition can have 0 or more rows. |
| SYSCOLSTATS |
SYSSTATS |
DSNTCX01 (NC) |
Contains partition statistics for selected columns.
Each column contains a row for each partition in the table |
| SYSCOLUMNS |
SYSTSCOL |
DSNDCX01 (U)
DSNDCX02 (N)
DSNDCX05 (N)
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. |
| SYSCONTEXTAUTHID_H |
SYSTSCXH |
|
Not used. |
| SYSCONTEXT |
SYSCONTX |
DSNCTX01 (UC)
DSNCTX02 (U)
DSNCTX03 (U)
DSNCTX04 (N) |
Contains one row for each trusted context. |
| SYSCONTEXT_H |
SYSTSCNH |
— |
Not used. |
| SYSCONTROLS |
SYSTSCTL |
DSNCLX01 (U)
DSNCLX02 (U)
DSNCLX03 (N)
DSNCLX04 (N)
DSNCLX05 (N) |
Contains one row for each row permission and column mask. |
| SYSCONTROLS_DESC |
SYSTSCTD |
DSNTRX02 (A) |
Contains the LOB data for the DESCRIPTOR column of sysibm_.SYSCONTROLS |
| SYSCONTROLS_DESC_H |
SYSTSCHD |
DSNTRX04 (A) |
Contains the LOB data for the DESCRIPTOR column of sysibm_.SYSCONTROLS_H |
| SYSCONTROLS_H |
SYSTSCTH |
|
|
| SYSCONTROLS_RTXT |
SYSTSCTR |
DSNTRX01 (A) |
Contains the LOB data for the RULETEXT column of sysibm_.SYSCONTROLS. |
| SYSCONTROLS_RTXT_H |
SYSTSCHR |
DSNTRX03 (A) |
Contains the LOB data for the RULETEXT column of sysibm_.SYSCONTROLS_H |
| SYSCOPY |
SYSTSCPY |
DSNUCH01 (N)
DSNUCX01 (U) |
Contains information that is needed for recovery |
| SYSCTXTTRUSTATTRS |
SYSCONTX |
DSNCAX01 (UC) |
Contains the attributes for a given trusted context |
| SYSCTXTTRUSTATTR_H |
SYSTSTAH |
|
Not used. |
| SYSDATABASE |
SYSTSDBA |
DSNDDH01 (U)
DSNDDX02 (N) |
Contains one row for each database, except for database DSNDB01 |
| SYSDATATYPES |
SYSTSDAT |
DSNODX01 (U)
DSNODX02 (U) |
Contains one row for each distinct data type |
| SYSDBAUTH |
SYSTSDBU |
DSNADH01 (N)
DSNADX01 (N)
DSNADH02 (N) |
Records the privileges held by users over databases |
| SYSDBAUTH_H |
SYSTSDBH |
— |
Not used. |
| SYSDBRM |
SYSTSDBR |
DSNDBX01 (N)
DSNDBX02 (U) |
Contains one row for each DBRM of each application plan |
| SYSDEPENDENCIES |
SYSTSDEP |
DSNONX01 (U)
DSNONX02 (N) |
Records the dependencies between objects |
| SYSDUMMY1 |
SYSEBCDC |
— |
Contains one row. This table is used by SQL statements that do not use any tables but must specify a table name. |
| SYSDUMMYA |
SYSTSASC |
— |
Contains one row and is used for SQL statements in which a table reference is required, but the contents of
the table are not important. SYSTSASC is an ASCII table space. |
| SYSDUMMYE |
SYSEBCDC |
— |
Contains one row and is used for SQL statements in which a table reference is required, but the contents of
the table are not important.
SYSEBCDIC is an EBCDIC table space. |
| SYSDUMMYU |
SYSTSUNI |
— |
Contains one row and is used for SQL statements in which a table reference is required, but the contents of
the table are not important.
SYSTSUNI is a UNICODE table space. |
| SYSDYNQRY |
SYSTSDQY |
DSNDQX01 (U)
DSNDQX02 (UC)
DSNDQX11 (U) |
Contains one row for each stabilized dynamic query. |
| SYSDYNQRYDEP |
SYSTSDQD |
DSNDQX03 (N)
DSNDQX04 (N)
DSNDQX05 (N)
DSNDQX12 (N) |
Records the dependencies of stabilized dynamic queries. |
| SYSDYNQRY_EXPL |
SYSTSDQE |
DSNDQX08 (A) |
Internal use for stabilized dynamic queries. |
| SYSDYNQRY_OPL |
SYSTSDQO |
DSNDQX10 (A) |
Internal use for stabilized dynamic queries. |
| SYSDYNQRY_SHTEL |
SYSTSDQH |
DSNDQX09 (A) |
Internal use for stabilized dynamic queries. |
| SYSDYNQRY_SPAL |
SYSTSDQS |
DSNDQX07 (A) |
Internal use for stabilized dynamic queries. |
| SYSDYNQRY_TXTL |
SYSTSDQT |
DSNDQX06 (A) |
Internal use for stabilized dynamic queries. |
| SYSENVIRONMENT |
SYSTSENV |
DSNOEX01 (U) |
Records the environment variables when an object is created |
| SYSFIELDS |
SYSTSFLD |
DSNDFX01 (N) |
Contains one row for every column that has a field procedure |
| SYSFOREIGNKEYS |
SYSTSFOR |
DSNDRH01 (N) |
Contains one row for every column of every foreign key |
| SYSINDEXCLEANUP |
SYSTSIXC |
DSNICX01 (N) |
Contains time window data to control index cleanup processing. |
| SYSINDEXCONTROL |
SYSTSICO |
|
Contains rows that specify time windows to control the use of memory allocated for an index. |
| SYSINDEXES |
SYSTSIXS |
DSNDXX01 (U)
DSNDXX02 (U)
DSNDXX03 (U)
DSNDXX04 (N)
DSNDXX07 |
Contains one row for every index |
| SYSINDEXES_RTSECT |
SYSTSIXR |
DSNDXX06 (A) |
Contains the LOB data for the RTSECTION column of sysibm_.SYSINDEXES. |
| SYSINDEXES_TREE |
SYSTSIXT |
DSNDXX05 (A) |
Contains the LOB data for the PARSETREE column of sysibm_.SYSINDEXES. |
| SYSINDEXES_HIST |
SYSHIST |
DSNHHX01 (NC)
DSNHHX02 (N) |
Contains accumulated rows from SYSINDEXES |
| SYSINDEXPART |
SYSTSIPT |
DSNDRX01 (U)
DSNDRX02 (N)
DSNDRX03 (N) |
Contains one row for each nonpartitioned index and one row for each partition of a partitioning index or DPSI |
| SYSINDEXPART_HIST |
SYSHIST |
DSNHGX01 (N) |
Contains accumulated rows from SYSINDEXPART |
| SYSINDEXSPACESTATS |
SYSTSISS |
DSNRTX02 (U)
DSNRTX03 (N) |
Contains Real-time Statistics for index spaces. |
| SYSIXSPACESTATS_H |
SYSTSISH |
|
A history table for temporal versioning of
the SYSINDEXSPACESTATS catalog table table.
For more information, see Temporal versioning for Db2 catalog tables. |
| 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) |
| SYSLEVELUPDATES |
SYSTSLVH |
DSNLVX01 (N)
DSNLVX02 (N) |
Contains information about the function levels, catalog levels, and code levels of the Db2 subsystem or data
sharing group. |
| SYSLOBSTATS |
SYSSTATS |
DSNLNX01 (UC) |
Contains one row for each LOB table space |
| SYSLOBSTATS_HIST |
SYSHIST |
DSNHJX01 (NC) |
Contains accumulated rows from SYSLOBSTATS |
| SYSOBDS 1 |
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: Do not manipulate data in the sysibm_.SYSOBDS catalog table, except at the direction of IBM® Support. |
| SYSOBD_AUX 1 |
SYSTSOBX |
DSNOB03 (A) |
Contains the LOB data for the OBD_IMAGE column of sysibm_.SYSOBDS. |
| SYSOBJROLEDEP |
SYSROLES |
DSNRDX01 (UC)
DSNRDX02 (N) |
Contains one row for each dependent role |
| SYSPACKAGE |
SYSTSPKG |
DSNKKX01 (U)
DSNKKX02 (U) |
Contains one row for each package |
| SYSPACKAUTH |
SYSTSPKA |
DSNKAX01 (N)
DSNKAX02 (N)
DSNKAX03 (N) |
Contains the privileges that are held by users over packages |
| SYSPACKAUTH_H |
SYSTSPKH |
— |
Not used. |
| SYSPACKCOPY |
SYSTSPKC |
DSNPCX01 (UC) |
|
| SYSPACKDEP |
SYSTSPKD |
DSNKDX01 (N)
DSNKDX02 (N)
DSNKDX03 (N) |
Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, and
triggers |
| SYSPACKLIST |
SYSTSPKL |
DSNKLX01 (N)
DSNKLX02 (U) |
Contains one row for every package list entry for a plan |
| SYSPACKSTMT |
SYSTSPKS |
DSNKSX01 (UC) |
Contains one row for every SQL statement that belongs to a package |
| SYSPACKSTMT_STMB |
SYSTSPVR |
DSNKSX02 (A) |
Contains the LOB data for the STMTBLOB column of sysibm_.SYSPACKSTMT. |
| SYSPACKSTMT_STMT |
SYSTSPKX |
DSNPKX01 (A) |
Contains the LOB data for the STATEMENT column of sysibm_.SYSPACKSTMT. |
| SYSPARMS |
SYSTSPRM |
DSNOPX01 (U)
DSNOPX02 (N)
DSNOPX03 (N)
DSNOPX04 (N) |
Contains a row for each parameter of a routine or a row for each column of a table that is passed as a
parameter to a routine |
| SYSPENDINGDDL |
SYSTSPEN |
DSNPDX01 (N)
DSNPDX02 (N) |
Contains information about which objects have pending definition changes.
The entries exist only during the window between when the pending option is run and when the utility materializes these pending options. |
| SYSPENDINGDDLTEXT |
SYSTSPDT |
DSNPDX03 (A) |
Contains the LOB data for the STATEMENT_TEXT column of sysibm_.SYSPENDINGDDL. |
| SYSPENDINGOBJECTS |
SYSTSPDO |
DSNPOX01 (N)
DSNPOX02 (N)
DSNPOX03 (N) |
Contains name and OBID information about the pending-CREATE objects, whose data sets are created but object
definitions have not been materialized to the real catalog. |
| SYSPKSYSTEM |
SYSTSPKY |
DSNKYX01 (N) |
Contain one row of system information for each package |
| SYSPLAN |
SYSTSPLN |
DSNPPH01 (U) |
Contains one row for each application plan |
| SYSPLANAUTH |
SYSTSPLA |
DSNAPH01 (N)
DSNAPX01 (N)
DSNAPX02 (N) |
Records the privileges that are held by users over application plans |
| SYSPLANAUTH_H |
SYSTSPLH |
— |
Not used. |
| SYSPLANDEP |
SYSTSPLD |
DSNGGX01 (N)
DSNGGX05 (N) |
Records the dependencies of plans on tables, views, aliases, synonyms, table spaces, and indexes |
| SYSPLSYSTEM |
SYSTSPLY |
DSNKPX01 (N) |
Contains one row of system information for each plan |
| SYSQUERY |
SYSTSQRY |
DSNQYX01 (N)
DSNQYX02 (U)
DSNQYX03 (N)
DSNQYX04 (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 |
| SYSQUERYPREDICATE |
SYSTSQRE |
DSNQEX01 (UC)
DSNQEX02 (N) |
Contains rows that describe the predicates within a query.
Rows are added to this table by using the BIND QUERY command.
Rows are removed from this table by using the FREE QUERY command. |
| SYSQUERYSEL |
SYSTSQRS |
— |
Contains rows that describe the selectivity of predicates.
Rows are added to this table by using the BIND QUERY command.
Rows are removed from this table by using the FREE QUERY command. |
| SYSRELS |
SYSTSREL |
DSNDLX01 (N)
DSNDLX02 (N)
DSNDLX03 (N)
DSNDLX04 (U) |
Contains one row for every relationship |
| SYSRESAUTH |
SYSGPAUT |
DSNAGH01 (N)
DSNAGX01 (N) |
Records the privileges that are held by users over buffer pools, storage groups, table spaces, and collections |
| SYSRESAUTH_H |
SYSGPAUH |
— |
Not used. |
| SYSROLES |
SYSROLES |
DSNRLX01 (UC) |
Contains one row for each role |
| SYSROUTINES |
SYSTSROU |
DSNOFX01 (U)
DSNOFX02 (U)
DSNOFX03 (N)
DSNOFX04 (U)
DSNOFX05 (N)
DSNOFX06 (N)
DSNOFX07 (U)
DSNOFX08 (N) |
Contains a row for every routine |
| SYSROUTINESTEXT |
SYSPLUXA |
DSNPLX01 (A) |
Contains LOB data for the column sysibm_.SYSROUTINES.TEXT |
| SYSROUTINES_TREE |
SYSPLUXB |
DSNPLX02 (A) |
Contains the LOB data for the PARSETREE column of sysibm_.SYSROUTINES. |
| SYSROUTINEAUTH |
SYSTSRAU |
DSNOAX01 (N)
DSNOAX02 (U)
DSNOAX03 (N)
|
Records the privileges that users hold on routines |
| SYSROUTINEAUTH_H |
SYSTSRAH |
— |
Not used. |
| SYSROUTINES_OPTS |
SYSGRTNS |
DSNROX01 (UC) |
Contains one row to record the build options for each generated routine |
| SYSROUTINES_SRC |
SYSGRTNS |
DSNRSX01 (N)
DSNRSX02 (U) |
Contains one or more rows for the source code for each generated routine |
| SYSSCHEMAAUTH |
SYSTSSCM |
DSNSKX01 (N)
DSNSKX02 (N) |
Contains one or more rows for each grantee of a privilege on a schema |
| SYSSCHEMAAUTH_H |
SYSTSSCH |
— |
Not used. |
| SYSSEQUENCEAUTH |
SYSSEQ2 |
DSNWCX01 (N)
DSNWCX02 (N)
DSNWCX03 (N) |
Records the privileges that users hold on sequences |
| SYSSEQUENCEAUTH_H |
SYSTSSAH |
— |
Not used. |
| SYSSEQUENCES |
SYSSEQ |
DSNSQX01 (U)
DSNSQX02 (UD)
DSNSQX03 (N) |
Contains one row for each identity column or user-defined sequence. |
| SYSSEQUENCESDEP |
SYSSEQ2 |
DSNSRX01 (N)
DSNSRX02 (N) |
Records the dependencies of identity columns on the corresponding entries in sysibm_.SYSSEQUENCES |
| SYSSESSION |
SYSTSSES |
DSNSNX02 (N) |
Contains session tokens that are generated by the server and associated session data. |
| SYSSESSION_EX |
SYSTSSNX |
DSNSNX04 (U)
DSNSNX05 (U) |
Contains the global variable data of LOB or array type that corresponds to the locator stored in the
GLOBAL_VARIABLES column of SYSSESSION table. |
| SYSSESSION_GV |
SYSTSSNL |
DSNSNX01 (U) |
Contains the LOB data for the GLOBAL_VARIABLES column of sysibm_.SYSSESSION table. |
| SYSSESSION_DATA |
SYSTSSXL |
DSNSNX03 (U) |
Contains LOB data for the DATA column of the SYSSESSION_EX table. |
| SYSSESSION_STATUS |
SYSTSSTA |
DSNSNX06 (U) |
Contains the session token and timestamp value when the corresponding session data was last referenced. |
| SYSSTATFEEDBACK |
SYSTSSFB |
DSNSFX01 (UC) |
Contains one row for every missing or conflicting statistic that is identified during query optimization. |
| SYSSTMT |
SYSTSSTM |
DSNPSX01 (N)
DSNPSX02 (N) |
Contains one or more rows for each SQL statement of each DBRM |
| SYSSTOGROUP |
SYSTSSTG |
DSNSSH01 (U) |
Contains one row for each storage group |
| SYSSTRINGS |
SYSTSSRG |
DSNSSX01 (U) |
Contains information necessary to perform string translations |
| SYSSYNONYMS |
SYSTSSYN |
DSNDYX01 (U)
DSNDYX02 (N) |
Contains one row for each synonym of a table or view |
| SYSTABAUTH |
SYSTSTAU |
DSNATX01 (N)
DSNATX02 (N)
DSNATX03 (N)
DSNATX04 (N)
DSNATX05 (U) |
Records the privileges that are held by users on tables, views, and triggers |
| SYSTABAUTH_H |
SYSTSTBH |
— |
Not used. |
| SYSTABCONST |
SYSTSTBC |
DSNCNX01 (U)
DSNCNX02 (N) |
Contains one row for each unique constraint that was created in Db2 for z/OS DB2 Version 7 or later |
| SYSTABLES |
SYSTSTAB |
DSNDTX01 (U)
DSNDTX02 (N)
DSNDTX03 (N)
DSNDTX05 |
Contains one row for each table, view, and alias |
| SYSTABLES_HIST |
SYSHIST |
DSNHDX01 (N) |
Contains accumulated rows from SYSTABLES |
| SYSTABLES_PROFILES |
SYSTSTPF |
DSNPRX01 (UC) |
Contains a row for each profile that is associated with a table in sysibm_.SYSTABLES |
| SYSTABLES_PROFILE_TEXT |
SYSTSPTX |
DSNPRX02 (UC) |
Contains the LOB data for the PROFILE_TEXT column of sysibm_.SYSTABLES_PROFILES |
| SYSTABLEPART |
SYSTSTPT |
DSNDPX01 (U)
DSNDPX02 (N)
DSNDPX03 (N)
DSNDPX04 (N)
DSNDPX05 (N) |
Contains one row for each nonpartitioned table space and one row for each partition of a partitioned table space |
| SYSTABLEPART_HIST |
SYSHIST |
DSNHCX01 (N) |
Contains accumulated rows from SYSTABLEPART |
| SYSTABLESPACE |
SYSTSTSP |
DSNDSX01 (U) |
Contains one row for each table space |
| SYSTABLESPACESTATS |
SYSTSTSS |
DSNRTX01 (U) |
Contains Real Time Statistics for table spaces. |
| SYSTABSPACESTATS_H |
SYSTSTSH |
|
A history table for temporal versioning of the
SYSTABLESPACESTATS catalog table table.
For more information, see Temporal versioning for Db2 catalog tables. |
| SYSTABSTATS |
SYSSTATS |
DSNTTX01 (U)
DSNTTX02 (N) |
Contains one row for each partition of a partitioned table space and no rows for nonpartitioned table spaces |
| SYSTABSTATS_HIST |
SYSHIST |
DSNHBX01 (NC) |
Contains accumulated rows from SYSTABSTATS |
| SYSTRIGGERS |
SYSTSTRG |
DSNOTX01 (UC)
DSNOTX02 (N)
DSNOTX03 (N) |
Contains one row for each trigger |
| SYSTRIGGERS_STMT |
SYSTSTRT |
DSNOTX04 (A) |
Contains the LOB data for the STATEMENT column of sysibm_.SYSTRIGGERS |
| SYSUSERAUTH |
SYSUSER |
DSNAUH01 (N)
DSNAUX02 (N) |
Records the system privileges that are held by users |
| SYSUSERAUTH_H |
SYSTSUAH |
— |
Not used. |
| SYSVARIABLEAUTH |
SYSTSVAU |
DSNVAX01 (N)
DSNVAX02 (N)
DSNVAX03 (N) |
Contains one row for each authorization ID that has privileges for each global variable. |
| SYSVARIABLES |
SYSTSVAR |
DSNOVX01 (U) |
Contains one row for each global variable that has been created. |
| SYSVARIABLES_DESC |
SYSTSVAD |
DSNOVX03 (A) |
Contains the LOB data for the DESCRIPTOR column of sysibm_.SYSVARIABLES. |
| SYSVARIABLES_TEXT |
SYSTSVAT |
DSNOVX02 (A) |
Contains the LOB data for the DEFAULTTEXT column of sysibm_.SYSVARIABLES. |
| SYSVIEWS |
SYSTSVEW |
DSNVVX01 (U) |
Contains one or more rows for each view |
| SYSVIEWS_STMT |
SYSTSVWT |
DSNVWX01 (A) |
Contains the LOB data for the STATEMENT column of sysibm_.SYSVIEWS |
| SYSVIEWS_TREE |
SYSTSVTR |
DSNVWX02 (A) |
Contains the LOB data for the PARSETREE column of sysibm_.SYSVIEWS |
| SYSVIEWDEP |
SYSTSVWD |
DSNGGX02 (N)
DSNGGX03 (N)
DSNGGX04 (N)
DSNGGX06 |
Records the dependencies of views on tables and other views |
| SYSVIEWDEP_H |
SYSTSVDH |
— |
Not used. |
| 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 |
