Catalog indexes
Indexes are defined on most catalog tables to improve catalog access.
The following table identifies the Db2 catalog tables on which indexes are defined, the columns that are in each of the indexes, and the data types of those columns.
| Table | Index (type1 ) | Columns (data type) |
|---|---|---|
| IPLIST |
DSNDUX01 (U)
|
LINKNAME (CHAR(8))
IPADDR (VARCHAR(254)) |
| IPNAMES |
DSNFPX01 (UC)
|
LINKNAME (CHAR(8))
|
| LOCATIONS |
DSNFCX01 (UC)
|
LOCATION (VARCHAR(128))
|
| LULIST |
DSNFLX01 (UC)
|
LINKNAME (CHAR(8))
LUNAME (VARCHAR(24)) |
|
DSNFLX02 (U)
|
LINKNAME (CHAR(8))
|
|
| LUNAMES | DSNFNX01 (UC) |
LUNAME (VARCHAR(24))
|
| LUMODES | DSNFMX01 (UC) |
LUNAME (VARCHAR(24))
MODENAME (VARCHAR(24)) |
| MODESELECT | DSNFDX01 (UC) |
LUNAME (VARCHAR(24))
AUTHID (VARCHAR(128)) PLANNAME (CHAR(8)) |
| SYSAUDITPOLICIES |
DSNAPX03 (UC)
|
AUDITPOLICYNAME (VARCHAR(128))
|
| SYSAUTOALERTS |
DSNALX01 (UC)
|
ALERT_ID (BIGINT)
|
|
DSNALX02 (N)
|
HISTORY_ENTRY_ID (BIGINT)
|
|
|
DSNALX03 (N)
|
RETURN_CODE (INTEGER)
ACTION (VARCHAR(32)) |
|
|
DSNALX04 (N)
|
TARGET_QUALIFIER (VARCHAR(128))
TARGET_OBJECT (VARCHAR(128)) TARGET_PARTITION (SMALLINT) |
|
|
DSNALX05 (N)
|
CREATEDTS (TIMESTAMP)
|
|
|
DSNALX06 (N)
|
STARTTS (TIMESTAMP)
RETURN_CODE (INTEGER) ACTION (VARCHAR(32)) |
|
| SYSAUTOALERTS_OUT |
DSNALX07 (A)
|
OUTPUT (CLOB(2M)) |
| SYSAUTORUNS_HIST |
DSNPHX01 (UC)
|
HISTORY_ENTRY_ID (BIGINT)
|
|
DSNPHX03
|
STARTTS (TIMESTAMP)
|
|
| SYSAUTORUNS_HISTOU | DSNPHX04 (A) |
OUTPUT (CLOB(2M))
|
| SYSAUTOTIMEWINDOWS |
DSNTWX01 (UC)
|
WINDOW_ID (BIGINT)
|
| SYSAUXRELS |
DSNOXX01 (NC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
DSNOXXO2 (N)
|
AUXTBOWNER (VARCHAR(128))
AUXTBNAME (VARCHAR(128)) |
|
| SYSCHECKDEP |
DSNSDX01 (UC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) CHECKNAME (VARCHAR(128)) COLNAME (VARCHAR(128)) |
| SYSCHECKS |
DSNSCX01 (UC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) CHECKNAME (VARCHAR(128)) |
| SYSCHECKS2 |
DSNCHX01 (UC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) CHECKNAME (VARCHAR(128)) |
| SYSCOLAUTH |
DSNACX01 (N)
|
CREATOR (VARCHAR(128))
TNAME (VARCHAR(128)) COLNAME (VARCHAR(128)) |
|
DSNACX02 (N)
|
CREATOR (VARCHAR(128))
TNAME (VARCHAR(128)) TIMESTAMP (TIMESTAMP) |
|
|
DSNACX03 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) CREATOR (VARCHAR(128)) TNAME (VARCHAR(128)) TIMESTAMP (CHAR(12)) |
|
|
DSNACX04 (N)
|
GRANTEE (VARCHAR(128))
GRANTEETYPE (CHAR(1)) CREATOR (VARCHAR(128)) TNAME (VARCHAR(128)) TIMESTAMP (CHAR(12)) |
|
| SYSCOLDIST |
DSNTNX01 (NC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) |
| SYSCOLDISTSTATS |
DSNTPX01 (NC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) PARTITION (SMALLINT) |
| SYSCOLDIST_HIST | DSNHFX01 (N) |
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) STATSTIME (TIMESTAMP) |
| SYSCOLSTATS |
DSNTCX01 (NC)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) PARTITION (SMALLINT) |
| SYSCOLUMNS |
DSNDCX01 (U)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) |
|
DSNDCX02 (N)
|
TYPESCHEMA (VARCHAR(128))
TYPENAME (VARCHAR(128)) |
|
|
DSNDCX05 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
| DSNDCX06 (N) |
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) COLNO (SMALLINT) |
|
| SYSCOLUMNS_HIST | DSNHEX01 (N) |
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) STATSTIME (TIMESTAMP) |
| SYSCONSTDEP |
DSNCCX01 (N)
|
BSCHEMA (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) |
|
DSNCCX02 (N)
|
DTBSCHEMA (VARCHAR(128))
DTBNAME (VARCHAR(128)) |
|
| SYSCONTEXT |
DSNCTX01 (UC)
|
NAME (VARCHAR(128))
|
|
DSNCTX02 (U) |
SYSTEMAUTHID (VARCHAR(128))
|
|
|
DSNCTX03 (U)
|
CONTEXTID (INTEGER)
|
|
|
DSNCTX04 (N)
|
DEFAULTROLE (VARCHAR(128))
|
|
| SYSCONTEXTAUTHIDS |
DSNCDX01 (UC)
|
CONTEXTID (INTEGER)
AUTHID (VARCHAR(128)) |
|
DSNCDX02 (N)
|
ROLE (VARCHAR(128))
|
|
| SYSCONTROLS |
DSNCLX01 (U)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNCLX02 (U)
|
CONTROL_ID (INTEGER)
|
|
|
DSNCLX03 (N)
|
TBSCHEMA (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
|
DSNCLX04 (N)
|
TBSCHEMA (VARCHAR(128))
TBNAME (VARCHAR(128)) ENABLE (CHAR(1)) |
|
|
DSNCLX05 (N)
|
TBSCHEMA (VARCHAR(128))
TBNAME (VARCHAR(128)) ENABLE (CHAR(1)) CONTROL_TYPE (CHAR(1)) |
|
| SYSCONTROLS_DESC |
DSNTRX02 (A)
|
DESCRIPTOR (BLOB(2M))
|
| SYSCONTROLS_DESC_H |
DSNTRX04 (A)
|
DESCRIPTOR (BLOB(2M))
|
| SYSCONTROLS_RTXT |
DSNTRX01 (A)
|
RULETEXT (CLOB(2M))
|
| SYSCONTROLS_RTXT_H |
DSNTRX03 (A)
|
RULETEXT (CLOB(2M))
|
| SYSCOPY |
DSNUCH01 (N)
|
DBNAME (CHAR(8))
TSNAME (CHAR(8)) START_RBA (CHAR(6)) TIMESTAMP (TIMESTAMP) |
|
DSNUCX01 (U)
|
DSNAME (CHAR(44))
|
|
| SYSCTXTTRUSTATTRS |
DSNCAX01 (UC)
|
CONTEXTID (INTEGER)
NAME (VARCHAR(128)) VALUE (VARCHAR(256)) |
| SYSDATABASE |
DSNDDH01 (U)
|
NAME (VARCHAR(24))
|
|
DSNDDX02 (N)
|
GROUP_MEMBER (VARCHAR(24))
|
|
| SYSDATATYPES |
DSNODX01 (U)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNODX02 (U)
|
DATATYPEID (INTEGER)
|
|
| SYSDBAUTH |
DSNADH01 (N)
|
GRANTEE (VARCHAR(128))
NAME (VARCHAR(24)) GRANTEETYPE (CHAR(1)) |
|
DSNADX01 (N)
|
GRANTOR (VARCHAR(128))
NAME (VARCHAR(24)) GRANTORTYPE (CHAR(1)) |
|
|
DSNADH02 (N)
|
NAME (VARCHAR(24))
|
|
| SYSDBRM |
DSNDBX01 (N)
|
PLNAME (VARCHAR(24))
|
|
DSNDBX02 (U)
|
PLNAME (VARCHAR(24))
NAME (VARCHAR(24)) |
|
| SYSDEPENDENCIES |
DSNONX01 (U)
|
BSCHEMA (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) BCOLNAME (VARCHAR(128)) |
|
DSNONX02 (N)
|
DSCHEMA (VARCHAR(128))
DNAME (VARCHAR(128)) DTYPE (CHAR(1)) DCOLNAME (VARCHAR(128)) |
|
| SYSDYNQRY |
DSNDQX01 (PU)
|
SDQ_STMT_ID (BIGINT)
COPYID (SMALLINT) |
|
DSNDQX02 (N)
|
SCHEMA
CURSCHEMA (VARCHAR(128)) QUERY_HASH (CHAR(16)) COPYID (SMALLINT) RELBOUND (CHAR(1)) |
|
|
DSNDQX11 (U)
|
STBLGRP (VARCHAR(128))
SDQ_STMT_ID (BIGINT) COPYID (SMALLINT) |
|
| SYSDYNQRYDEP |
DSNDQX03 (N)
|
SDQ_STMT_ID (BIGINT)
COPYID (SMALLINT) |
|
DSNDQX04 (N)
|
BQUALIFIER (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) SDQ_STMT_ID (BIGINT) COPYID (SMALLINT) |
|
|
DSNDQX05 (N)
|
CLASS (CHAR(1))
AUTHID (VARCHAR(128)) AUTHID_TYPE (CHAR(1)) |
|
|
DSNDQX12 (N)
|
CLASS (CHAR(1))
BTYPE (CHAR(1)) BAUTH (SMALLINT) AUTHID_TYPE (CHAR(1)) AUTHID (VARCHAR(128)) BQUALIFIER (VARCHAR(128)) BNAME (VARCHAR(128)) |
|
| SYSDYNQRY_EXPL |
DSNDQX08 (A)
|
DATA2 (BLOB(2147483647))
|
| SYSDYNQRY_OPL |
DSNDQX10 (A)
|
DATA4 (BLOB(2147483647))
|
| SYSDYNQRY_SHTEL |
DSNDQX09 (A)
|
DATA3 (BLOB(2147483647))
|
| SYSDYNQRY_SPAL |
DSNDQX07 (A)
|
DATA1 (BLOB(2147483647))
|
| SYSDYNQRY_TXTL |
DSNDQX06 (A)
|
STMTTEXT (CLOB(2M))
|
| SYSENVIRONMENT |
DSNOEX01 (U)
|
ENVID (INTEGER)
|
| SYSFIELDS |
DSNDFX01 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) |
| SYSFOREIGNKEYS |
DSNDRH01 (N)
|
CREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) RELNAME (VARCHAR(128)) |
| SYSINDEXCLEANUP |
DSNICX01 (N)
|
DBNAME (VARCHAR(24))
INDEXSPACE (VARCHAR(24)) |
| SYSINDEXES |
DSNDXX01 (U)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNDXX02 (U)
|
DBNAME (VARCHAR(24))
INDEXSPACE (VARCHAR(24)) |
|
|
DSNDXX03 (U)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) CREATOR (VARCHAR(128)) NAME (VARCHAR(128)) |
|
|
DSNDXX04 (N)
|
INDEXTYPE (CHAR(1))
|
|
|
DSNDXX07 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
| SYSINDEXES_HIST |
DSNHHX01 (NC)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) NAME (VARCHAR(128)) STATSTIME (TIMESTAMP) |
|
DSNHHX02 (N)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) |
|
| SYSINDEXES_RTSECT |
DSNDXX06 (A)
|
RTSECTION (BLOB(1G))
|
| SYSINDEXES_TREE |
DSNDXX05 (A)
|
PARSETREE (BLOB(1G))
|
| SYSINDEXPART |
DSNDRX01 (U)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) PARTITION (SMALLINT) |
|
DSNDRX02 (N)
|
STORNAME (VARCHAR(128))
|
|
|
DSNDRX03 (N)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
| SYSINDEXPART_HIST |
DSNHGX01 (N)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) PARTITION (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSINDEXSPACESTATS |
DSNRTX02 (U)
|
DBID (SMALLINT)
ISOBID (SMALLINT) PARTITION (SMALLINT) INSTANCE (SMALLINT) |
|
DSNRTX03 (N)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) |
|
| SYSINDEXSTATS |
DSNTXX01 (UC)
|
OWNER (VARCHAR(128))
NAME (VARCHAR(128)) PARTITION (SMALLINT) |
| SYSINDEXSTATS_HIST |
DSNHIX01 (NC)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) PARTITION (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSJARDATA |
DSNJDX01 (A)
|
JARDATA (BLOB(100M))
|
| SYSJARCLASS_SOURCE |
DSNJSX01 (A)
|
CLASS_SOURCE (CLOB(10M))
|
| SYSJARCONTENTS |
DSNJCX01 (NC)
|
JARSCHEMA (VARCHAR(128))
JAR_ID (VARCHAR(128)) |
| SYSJAROBJECTS |
DSNJOX01 (UC)
|
JARSCHEMA (VARCHAR(128))
JAR_ID (VARCHAR(128)) |
| SYSJAVAOPTS |
DSNJVX01 (UC)
|
JARSCHEMA (VARCHAR(128))
JAR_ID (VARCHAR(128)) |
| SYSJAVAPATHS |
DSNJPX01 (U)
|
JARSCHEMA (VARCHAR(128))
JAR_ID (VARCHAR(128)) ORDINAL (SMALLINT) |
|
DSNJPX02 (N)
|
PE_JARSCHEMA (VARCHAR(128))
PE_JAR_ID (VARCHAR(128)) |
|
| SYSKEYCOLUSE |
DSNCUX01 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) CONSTNAME (VARCHAR(128)) COLSEQ (SMALLINT) |
| SYSKEYS |
DSNDKX01 (U)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) COLNAME (VARCHAR(128)) |
|
DSNDKX02 (N)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
|
DSNDKX03 (U)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) COLSEQ (SMALLINT) |
|
| SYSKEYTARGETS |
DSNRKX01 (UC)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) |
|
DSNRKX02 (N)
|
DATATYPEID (INTEGER)
KEYSPEC_INTERNAL (VARCHAR(512)) |
|
| SYSKEYTARGETSTATS |
DSNTKX01 (U)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) PARTITION (SMALLINT) |
| SYSKEYTARGETS_HIST |
DSNHKX01 (N)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSKEYTGTDIST |
DSNTDX01 (N)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) |
| SYSKEYTGTDISTSTATS |
DSNTSX01 (N)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) PARTITION (SMALLINT) |
| SYSKEYTGTDIST_HIST |
DSNTDX02 (N)
|
IXSCHEMA (VARCHAR(128))
IXNAME (VARCHAR(128)) KEYSEQ (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSLOBSTATS |
DSNLNX01 (UC)
|
DBNAME (VARCHAR(24))
NAME (VARCHAR(24)) |
| SYSLEVELSUPDATED | DSNLVX01 (N) | OPERATION_TYPE (CHAR(1)), EFFECTIVE_TIME (TIMESTAMP(12)) |
| DSNLVX02 (N) | EFFECTIVE TIME (TIMESTAMP(12)) | |
| SYSLOBSTATS_HIST |
DSNHJX01 (NC)
|
DBNAME (CHAR(8))
NAME (CHAR(8)) STATSTIME (TIMESTAMP) |
| SYSOBDS |
DSNDOB01 (N)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) OBDTYPE (CHAR(1)) |
|
DSNDOB02 (N)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) OBDTYPE (CHAR(1)) |
|
| SYSOBD_AUX |
DSNOB03 (A)
|
OBD_IMAGE (BLOB(1G))
|
| SYSOBJROLEDEP |
DSNRDX01 (UC)
|
DSCHEMA (VARCHAR(128))
DNAME (VARCHAR(128)) DTYPE (CHAR(1)) |
|
DSNRDX02 (N)
|
ROLENAME (VARCHAR(128))
|
|
| SYSPACKAUTH |
DSNKAX01 (N)
|
GRANTOR (VARCHAR(128))
LOCATION (VARCHAR(128)) COLLID (VARCHAR(128)) NAME (VARCHAR(128)) GRANTORTYPE (CHAR(1)) |
|
DSNKAX02 (N)
|
GRANTEE (VARCHAR(128))
LOCATION (VARCHAR(128)) COLLID (VARCHAR(128)) NAME (VARCHAR(128)) BINDAUTH (CHAR(1)) COPYAUTH (CHAR(1)) EXECUTEAUTH (CHAR(1)) GRANTEETYPE (CHAR(1)) |
|
|
DSNKAX03 (N)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) |
|
| SYSPACKAGE |
DSNKKX01 (U)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) VERSION (VARCHAR(122)) |
|
DSNKKX02 (U)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) CONTOKEN (CHAR(8)) |
|
| SYSPACKCOPY |
DSNPCX01 (UC)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) CONTOKEN (CHAR(8)) COPYID (INTEGER) |
| SYSPACKDEP |
DSNKDX01 (N)
|
DLOCATION (VARCHAR(128))
DCOLLID (VARCHAR(128)) DNAME (VARCHAR(128)) DCONTOKEN (CHAR(8)) |
|
DSNKDX03 (N)
|
BQUALIFIER (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) DTYPE (CHAR(1)) |
|
| SYSPACKLIST |
DSNKLX01 (N)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) |
|
DSNKLX02 (U)
|
PLANNAME (VARCHAR(24))
SEQNO (SMAILLINT) LOCATION (VARCHAR(128)) COLLID (VARCHAR(128)) NAME (VARCHAR(128)) |
|
| SYSPACKSTMT |
DSNKSX01 (UC)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) CONTOKEN (CHAR(8)) SEQNO (INTEGER) |
| SYSPACKSTMT_STMB |
DSNKSX02 (A)
|
STMTBLOB (BLOB(2M))
|
| SYSPACKSTMT_STMT |
DSNPKX01 (A)
|
STATEMENT (CLOB(2M))
|
 SYSPACKSTMTCOPY |
DSNKTX01 (U)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128) CONTOKEN(CHAR(8)) COPYID (INTEGER) SEQNO (INTEGER) |
| |
DSNKTX02 (U)
|
STMT_ID (BIGINT)
COPYID (INTEGER) |
| SYSPACKSTMTDEP |
DSNKNX01 (N)
|
DLOCATION (VARCHAR(128))
DCOLLID (VARCHAR(128)) DNAME (VARCHAR(128)) DCONTOKEN (CHAR(8)) DCOPYID (INTEGER) DSEQNO (INTEGER) BSCHEMA (VARCHAR(128)) BNAME (VARCHAR(128)) BTYPE (CHAR(1)) |
| |
DSNKNX02 (N)
|
BSCHEMA (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) DTYPE (CHAR(1)) |
| SYSPARMS |
DSNOPX01 (U)
|
SCHEMA (VARCHAR(128))
SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) ROWTYPE (CHAR(1)) ORDINAL (SMALLINT) VERSION (VARCHAR(122)) |
|
DSNOPX02 (N)
|
TYPESCHEMA (VARCHAR(128))
TYPENAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) CAST_FUNCTION (CHAR(1)) OWNER (VARCHAR(128)) SCHEMA (VARCHAR(128)) SPECIFICNAME (VARCHAR(128)) |
|
|
DSNOPX03 (N)
|
TYPESCHEMA (VARCHAR(128))
TYPENAME (VARCHAR(128)) |
|
|
DSNOPX04 (N)
|
SCHEMA (VARCHAR(128))
SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) VERSION (VARCHAR(122)) |
|
| SYSPENDINGDDL |
DSNPDX01 (N)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) CREATEDTS (TIMESTAMP) OPTION_SEQNO (SMALLINT) |
|
DSNPDX02 (N)
|
OBJSCHEMA (VARCHAR(128))
OBJNAME (VARCHAR(128)) OBJTYPE (CHAR(1)) CREATEDTS (TIMESTAMP) OPTION_SEQNO (SMALLINT) |
|
| SYSPENDINGDDLTEXT | DSNPDX03 (A) |
STATEMENT_TEXT (CLOB(2M))
|
| SYSPENDINGOBJECTS |
DSNPOX01 (N)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) PARTITION (SMALLINT) COLNAME (VARCHAR(128)) |
|
DSNPOX02 (N)
|
OBJSCHEMA (VARCHAR(128))
OBJNAME (VARCHAR(128)) OBJTYPE (CHAR(1)) |
|
|
DSNPOX03 (N)
|
DBNAME (VARCHAR(24))
INDEXSPACE (CHAR(8)) |
|
| SYSPKSYSTEM |
DSNKYX01 (N)
|
LOCATION (VARCHAR(128))
COLLID (VARCHAR(128)) NAME (VARCHAR(128)) CONTOKEN (CHAR(8)) SYSTEM (VARCHAR(24)) ENABLE (CHAR(1)) |
| SYSPLAN |
DSNPPH01 (U)
|
NAME (VARCHAR(24))
|
| SYSPLANAUTH |
DSNAPH01 (N)
|
GRANTEE (VARCHAR(128))
NAME (VARCHAR(24)) EXECUTEAUTH (CHAR(1)) GRANTEETYPE (CHAR(1)) |
|
DSNAPX01 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) |
|
|
DSNAPX02 (N)
|
NAME (VARCHAR(24))
|
|
| SYSPLANDEP |
DSNGGX01 (N)
|
BCREATOR (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) |
|
DSNGGX05 (N)
|
DNAME (VARCHAR(24))
|
|
| SYSPLSYSTEM |
DSNKPX01 (N)
|
NAME (VARCHAR(24))
SYSTEM (VARCHAR(24)) ENABLE (CHAR(1)) |
| SYSPROFILE_TEXT |
DSNPRX02 (A)
|
PROFILE_TEXT (CLOB(1M))
|
| SYSQUERY |
DSNQYX01 (N)
|
QUERY_HASH (CHAR(16))
SCHEMA (VARCHAR(128)) SOURCE (SMALLINT) QUERY_SEC_HASH (CHAR(16)) |
|
DSNQYX02 (U)
|
QUERYID (BIGINT)
|
|
|
DSNQYX03 (N)
|
LOCATION (VARCHAR(128))
COLLECTION (VARCHAR(128)) PACKAGE (VARCHAR(128)) VERSION (VARCHAR(128)) SECTNO (INTEGER) |
|
|
DSNQYX04 (N)
|
QUERY_SEC_HASH (CHAR(16))
SCHEMA (VARCHAR(128)) SOURCE (SMALLINT) |
|
| SYSQUERYPREDICATE |
DSNQEX01 (UC)
|
QUERYID (BIGINT)
PREDNO (INTEGER) |
|
DSNQEX02 (N)
|
QUERYID (BIGINT)
|
|
| SYSQUERYOPTS |
DSNQPX01 (N)
|
QUERYID (BIGINT)
COPYID (SMALLINT) |
| SYSQUERYPLAN |
DSNQNX01 (N)
|
QUERYID (BIGINT)
COPYID (SMALLINT) |
| SYSQUERYSEL |
DSNQLX01 (PU)
|
QUERYID (BIGINT)
PREDNO (INTEGER) INSTANCE (SMALLINT) |
|
DSNQLX02 (N)
|
QUERYID (BIGINT)
PREDNO (INTEGER) |
|
| SYSQUERY_AUX |
DSNQSX01 (A)
|
STMTTEXT (CLOB(2M))
|
| SYSRELS |
DSNDLX01 (N)
|
REFTBCREATOR (VARCHAR(128))
REFTBNAME (VARCHAR(128)) |
|
DSNDLX02 (N)
|
CREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
|
DSNDLX03 (N)
|
IXOWNER (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
|
DSNDLX04 (U)
|
CREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) RELNAME (VARCHAR(128)) |
|
| SYSRESAUTH |
DSNAGH01 (N)
|
GRANTEE (VARCHAR(128))
QUALIFIER (VARCHAR(128)) NAME (VARCHAR(128)) OBTYPE (CHAR(1)) GRANTEETYPE (CHAR(1)) |
|
DSNAGX01 (N)
|
GRANTOR (VARCHAR(128))
QUALIFIER (VARCHAR(128)) NAME (VARCHAR(128)) OBTYPE (CHAR(1)) GRANTORTYPE (CHAR(1)) |
|
| SYSROLES | DSNRLX01 (UC) |
NAME (VARCHAR(128))
|
| SYSROUTINEAUTH |
DSNOAX01 (N)
|
GRANTOR (VARCHAR(128))
SCHEMA (VARCHAR(128)) SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) GRANTEETYPE (CHAR(1)) EXECUTEAUTH (CHAR(1)) GRANTORTYPE (CHAR(1)) |
|
DSNOAX02 (U)
|
GRANTEE (VARCHAR(128))
SCHEMA (VARCHAR(128)) SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) GRANTEETYPE (CHAR(1)) EXECUTEAUTH (CHAR(1)) GRANTEDTS (TIMESTAMP) |
|
|
DSNOAX03 (N)
|
SCHEMA (VARCHAR(128))
SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) |
|
| SYSROUTINES |
DSNOFX01 (UC)
|
NAME (VARCHAR(128))
PARM_COUNT (SMALLINT) PARM_SIGNATURE (VARCHAR(150)) ROUTINETYPE (CHAR(1)) SCHEMA (VARCHAR(128)) PARM1 (SMALLINT) PARM2 (SMALLINT) PARM3 (SMALLINT) PARM4 (SMALLINT) PARM5 (SMALLINT) PARM6 (SMALLINT) PARM7 (SMALLINT) PARM8 (SMALLINT) PARM9 (SMALLINT) PARM10 (SMALLINT) PARM11 (SMALLINT) PARM12 (SMALLINT) PARM13 (SMALLINT) PARM14 (SMALLINT) PARM15 (SMALLINT) PARM16 (SMALLINT) PARM17 (SMALLINT) PARM18 (SMALLINT) PARM19 (SMALLINT) PARM20 (SMALLINT) PARM21 (SMALLINT) PARM22 (SMALLINT) PARM23 (SMALLINT) PARM24 (SMALLINT) PARM25 (SMALLINT) PARM26 (SMALLINT) PARM27 (SMALLINT) PARM28 (SMALLINT) PARM29 (SMALLINT) PARM30 (SMALLINT) VERSION (VARCHAR(122)) |
| DSNOFX02 (PU) |
SCHEMA (VARCHAR(128))
SPECIFICNAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) VERSION (VARCHAR(122)) |
|
| DSNOFX03 (N) |
NAME (VARCHAR(128))
SCHEMA (VARCHAR(128)) CAST_FUNCTION (CHAR(1)) PARM_COUNT (SMALLINT) PARM_SIGNATURE (VARCHAR(150)) PARM1 (SMALLINT) |
|
| DSNOFX04 (U) |
ROUTINE_ID (INTEGER)
|
|
| DSNOFX05 (N) |
SOURCESCHEMA (VARCHAR(128))
SOURCESPECIFIC (VARCHAR(128)) ROUTINETYPE (CHAR(1)) |
|
| DSNOFX06 (N) |
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) ROUTINETYPE (CHAR(1)) PARM_COUNT (SMALLINT) |
|
|
DSNOFX07 (U)
|
NAME (VARCHAR(128))
PARM_COUNT (SMALLINT) ROUTINETYPE (CHAR(1)) SCHEMA (VARCHAR(128)) PARM_SIGNATURE (VARCHAR(150)) PARM1 (SMALLINT) PARM2 (SMALLINT) PARM3 (SMALLINT) PARM4 (SMALLINT) PARM5 (SMALLINT) PARM6 (SMALLINT) PARM7 (SMALLINT) PARM8 (SMALLINT) PARM9 (SMALLINT) PARM10 (SMALLINT) PARM11 (SMALLINT) PARM12 (SMALLINT) PARM13 (SMALLINT) PARM14 (SMALLINT) PARM15 (SMALLINT) PARM16 (SMALLINT) PARM17 (SMALLINT) PARM18 (SMALLINT) PARM19 (SMALLINT) PARM20 (SMALLINT) PARM21 (SMALLINT) PARM22 (SMALLINT) PARM23 (SMALLINT) PARM24 (SMALLINT) PARM25 (SMALLINT) PARM26 (SMALLINT) PARM27 (SMALLINT) PARM28 (SMALLINT) PARM29 (SMALLINT) PARM30 (SMALLINT) VERSION (VARCHAR(122)) |
|
|
DSNOFX08 (N)
|
JARSCHEMA (VARCHAR(128))
JAR_ID (VARCHAR(128)) |
|
| SYSROUTINESTEXT |
DSNPLX01 (A)
|
TEXT (CLOB(2M))
|
| SYSROUTINES_OPTS |
DSNROX01 (UC)
|
SCHEMA (VARCHAR(128))
ROUTINENAME (VARCHAR(128)) BUILDDATE (DATE) BUILDTIME (TIME) |
| SYSROUTINES_SRC |
DSNRSX01 (N)
|
ROUTINENAME (VARCHAR(128))
|
|
DSNRSX02 (UC)
|
SCHEMA (VARCHAR(128))
ROUTINENAME (VARCHAR(128)) BUILDDATE (DATE) SEQNO (INTEGER) |
|
| SYSROUTINES_TREE |
DSNPLX02 (A)
|
PTREE (BLOB(1G))
|
| SYSSCHEMAAUTH |
DSNSKX01 (N)
|
GRANTEE (VARCHAR(128))
SCHEMANAME (VARCHAR(128)) GRANTEETYPE (CHAR(1)) |
|
DSNSKX02 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) |
|
| SYSSEQUENCEAUTH |
DSNWCX01 (N)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNWCX02 (N)
|
GRANTOR (VARCHAR(128))
SCHEMA (VARCHAR(128)) NAME (VARCHAR(128)) GRANTORTYPE (VARCHAR(128)) |
|
|
DSNWCX03 (N)
|
GRANTEE (VARCHAR(128))
SCHEMA (VARCHAR(128)) NAME (VARCHAR(128)) GRANTEETYPE (VARCHAR(128)) |
|
| SYSSEQUENCES |
DSNSQX01 (U)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNSQX02 (UD)
|
SEQUENCEID (INTEGER)
|
|
|
DSNSQX03 (N)
|
SEQSCHEMA (VARCHAR(128))
SEQNAME (VARCHAR(128)) |
|
| SYSSEQUENCESDEP |
DSNSRX01 (N)
|
DCREATOR (VARCHAR(128))
DNAME (VARCHAR(128)) DCOLNAME (VARCHAR(128)) |
|
DSNSRX02 (N)
|
BSCHEMA (VARCHAR(128))
BNAME (VARCHAR(128)) DTYPE (CHAR(1)) |
|
| SYSSESSION |
DSNSNX02 (PU)
|
TOKEN (CHAR(40))
|
| SYSSESSION_DATA |
DSNSNX03 (A)
|
DATA (BLOB(2147483647))
|
| SYSSESSION_EX |
DSNSNX04 (N)
|
TOKEN (CHAR(40))
|
|
DSNSNX05 (U)
|
TOKEN (CHAR(40))
GVID (CHAR(8)) LOCATOR (CHAR(8)) |
|
| SYSSESSION_GV |
DSNSNX01 (A)
|
GLOBAL_VARIABLES (BLOB(2147483647)))
|
| SYSSESSION_STATUS |
DSNSNX06 (U)
|
TOKEN (CHAR(40))
|
| SYSSTATFEEDBACK |
DSNSFX01 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) IXCREATOR (VARCHAR(128)) IXNAME (VARCHAR(128)) COLNAME (VARCHAR(128)) COLGROUPNO (VARCHAR(254)) NUMCOLUMNS (SMALLINT) TYPE (CHAR(1)) |
|
DSNSFX02 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
|
DSNSFX03 (N)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
| SYSSTOGROUP |
DSNSSH01 (U)
|
NAME (VARCHAR(128))
|
| SYSSTMT |
DSNPSX01 (N)
|
PLNAME (VARCHAR(24))
NAME (VARCHAR(24)) |
|
DSNPSX02 (N)
|
PLNAME (VARCHAR(24))
NAME (VARCHAR(24)) SEQNO (INTEGER) |
|
| SYSSTRINGS |
DSNSSX01 (U)
|
OUTCCSID (INTEGER)
INCCSID (INTEGER) IBMREQD (CHAR(1)) |
| SYSSYNONYMS |
DSNDYX01 (U)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNDYX02 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
| SYSTABAUTH |
DSNATX01 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) |
|
DSNATX02 (N)
|
GRANTEE (VARCHAR(128))
TCREATOR (VARCHAR(128)) TTNAME (VARCHAR(128)) GRANTEETYPE (CHAR(1)) UPDATECOLS (CHAR(1)) ALTERAUTH (CHAR(1)) DELETEAUTH (CHAR(1)) INDEXAUTH (CHAR(1)) INSERTAUTH (CHAR(1)) SELECTAUTH (CHAR(1)) UPDATEAUTH (CHAR(1)) CAPTUREAUTH (CHAR(1)) REFERENCESAUTH (CHAR(1)) REFCOLS (CHAR(1)) TRIGGERAUTH (CHAR(1)) UNLOADAUTH (CHAR(1)) |
|
|
DSNATX03 (N)
|
GRANTEE (VARCHAR(128))
GRANTEETYPE (CHAR(1)) COLLID (VARCHAR(128)) CONTOKEN (CHAR(8)) |
|
|
DSNATX04 (N)
|
TCREATOR (VARCHAR(128))
TTNAME (VARCHAR(8)) |
|
|
DSNATX05 (PU)
|
TCREATOR (VARCHAR(128))
TTNAME (VARCHAR(128)) TIMESTAMP (CHAR(12)) |
|
| SYSTABCONST |
DSNCNX01 (U)
|
TBCREATOR (VARCHAR(128)) TBNAME (VARCHAR(128)) CONSTNAME (VARCHAR(128)) |
|
DSNCNX02 (N)
|
IXOWNER (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
| SYSTABLEPART |
DSNDPX01 (U)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) PARTITION (SMALLINT) |
|
DSNDPX02 (N)
|
STORNAME (VARCHAR(128))
|
|
|
DSNDPX03 (N)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) LOGICAL_PART (SMALLINT) |
|
|
DSNDPX04 (N)
|
IXCREATOR (VARCHAR(128))
IXNAME (VARCHAR(128)) |
|
|
DSNDPX05 (N)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) |
|
| SYSTABLEPART_HIST |
DSNHCX01 (N)
|
DBNAME (CHAR(8))
TSNAME (CHAR(8)) PARTITION (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSTABLES |
DSNDTX01 (PU)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNDTX02 (U)
|
DBID (SMALLINT)
OBID (SMALLINT) CREATOR (VARCHAR(128)) NAME (VARCHAR(128)) |
|
|
DSNDTX03 (N)
|
TBCREATOR (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
|
DSNDTX05 (N)
|
DBNAME (VARCHAR(24))
TSNAME (VARCHAR(24)) |
|
| SYSTABLESPACE |
DSNDSX01 (U)
|
DBNAME (VARCHAR(24))
NAME (VARCHAR(24)) |
| SYSTABLESPACESTATS |
DSNRTX01 (U)
|
DBID (SMALLINT)
PSID (SMALLINT) PARTITION (SMALLINT) INSTANCE (SMALLINT) |
| SYSTABLES_HIST |
DSNHDX01 (N)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) STATSTIME (TIMESTAMP) |
| SYSTABLES_PROFILES |
DSNPRX01 (UC)
|
SCHEMA (VARCHAR(128))
TBNAME (VARCHAR(128)) PROFILE_TYPE (VARCHAR(32)) |
| SYSTABSTATS |
DSNTTX01 (U)
|
OWNER (VARCHAR(128))
NAME (VARCHAR(128)) PARTITION (SMALLINT) |
|
DSNTTX02 (N)
|
DBNAME (VARCHAR(24))
NAME (VARCHAR(128)) |
|
| SYSTABSTATS_HIST |
DSNHBX01 (NC)
|
OWNER (VARCHAR(128))
NAME (VARCHAR(128)) PARTITION (SMALLINT) STATSTIME (TIMESTAMP) |
| SYSTRIGGERS |
DSNOTX01 (UC)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) SEQNO (SMALLINT) VERSION |
|
DSNOTX02 (N)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) |
|
|
DSNOTX03 (N)
|
SCHEMA (VARCHAR(128))
TRIGNAME (VARCHAR(128)) |
|
| SYSTRIGGERS_STMT |
DSNOTX04 (A)
|
STATEMENT (CLOB(2M)
|
| SYSUSERAUTH |
DSNAUH01 (N)
|
GRANTEE (VARCHAR(128))
GRANTEDTS (TIMESTAMP) GRANTEETYPE (CHAR(1)) |
|
DSNAUX02 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) |
|
| SYSUTILITIES |
DSNULX01 (U) |
EVENTID |
| |
DSNULX02 (N) |
NAME
STARTTS ENDTS |
| SYSVARIABLEAUTH |
DSNVAX01 (N)
|
GRANTEE (VARCHAR(128))
GRANTEETYPE (CHAR(1)) SCHEMA (VARCHAR(128)) NAME (VARCHAR(128)) |
|
DSNVAX02 (N)
|
GRANTOR (VARCHAR(128))
GRANTORTYPE (CHAR(1)) SCHEMA (VARCHAR(128)) NAME (VARCHAR(128)) |
|
|
DSNVAX03 (N)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
| SYSVARIABLES |
DSNOVX01 (PU)
|
SCHEMA (VARCHAR(128))
NAME (VARCHAR(128)) |
|
DSNOVX04 (N)
|
TYPESCHEMA (VARCHAR(128))
TYPENAME (VARCHAR(128)) |
|
| SYSVARIABLES_DESC |
DSNOVX03 (A)
|
DESCRIPTOR (CLOB(2M))
|
| SYSVARIABLES_TEXT |
DSNOVX02 (A)
|
DEFAULTTEXT (CLOB(2M))
|
| SYSVIEWDEP |
DSNGGX02 (N)
|
BCREATOR (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) |
|
DSNGGX03 (N)
|
BSCHEMA (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) |
|
|
DSNGGX04 (N)
|
BCREATOR (VARCHAR(128))
BNAME (VARCHAR(128)) BTYPE (CHAR(1)) DTYPE (CHAR(1)) |
|
|
DSNGGX06
|
DCREATOR (VARCHAR(128))
DNAME (VARCHAR(128)) DTYPE (CHAR(1)) |
|
| SYSVIEWS |
DSNVVX01 (U)
|
CREATOR (VARCHAR(128))
NAME (VARCHAR(128)) SEQNO (SMALLINT) TYPE (CHAR(1)) |
| SYSVIEWS_STMT |
DSNVWX01 (A)
|
STATEMENT (CLOB(2M))
|
| SYSVIEWS_TREE |
DSNVWX02 (A)
|
PARSETREE (BLOB(1G))
|
| SYSVOLUMES |
DSNSSH02 (N)
|
SGNAME (VARCHAR(128))
|
| SYSXMLRELS |
DSNXRX01 (N)
|
TBOWNER (VARCHAR(128))
TBNAME (VARCHAR(128)) COLNAME (VARCHAR(128)) |
|
DSNXRX02 (N)
|
XMLTBOWNER (VARCHAR(128))
XMLTBNAME (VARCHAR(128)) |
|
| SYSXMLSTRINGS |
DSNXSX01 (UC)
|
STRINGID (INTEGER)
|
|
DSNXSX02 (U)
|
STRING (VARCHAR(1000))
|
|
| SYSXMLTYPMOD |
DSNTMX01 (PU)
|
XML_TYPMODE_ID (INTEGER)
|
| SYSXMLTYPMSCHEMA |
DSNMSX01 (U)
|
XML_TYPMODE_ID (INTEGER)
XSROBJECTID (INTEGER) |
|
DSNMSX02 (N)
|
XSROBJECTID (INTEGER)
|
|
| USERNAMES | DSNFEX01 (U) |
TYPE (CHAR(1))
AUTHID (VARCHAR(128)) LINKNAME (CHAR(8)) |
|
Notes:
|
||