Db2 12 for z/OS Catalog Tables - BMC Blogs

Records the privileges that are held by users on routines.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
SCHEMA	VARCHAR(128)
SPECIFICNAME	VARCHAR(128)
GRANTEDTS	TIMESTAMP
ROUTINETYPE	CHAR(1)
GRANTEETYPE	CHAR(1)
AUTHHOWGOT	CHAR(1)
EXECUTEAUTH	CHAR(1)
COLLID	VARCHAR(128)
CONTOKEN	CHAR(8)
IBMREQD	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSROUTINES_OPTS

A row for each generated routine.

SCHEMA	VARCHAR(128)
ROUTINENAME	VARCHAR(128)
BUILDDATE	DATE
BUILDTIME	TIME
BUILDSTATUS	CHAR(1)
BUILDSCHEMA	VARCHAR(128)
BUILDNAME	VARCHAR(128)
BUILDOWNER	VARCHAR(128)
IBMREQD	CHAR(1)
PRECOMPILE_OPTS	VARCHAR(765)
COMPILE_OPTS	VARCHAR(765)
PRELINK_OPTS	VARCHAR(765)
LINK_OPTS	VARCHAR(765)
BIND_OPTS	VARCHAR(3072
SOURCEDSN	VARCHAR(765)
DEBUG_MODE	CHAR(1)

SYSIBM.SYSROUTINES

A row for every routine.

SOURCE_SPECIFIC	VARCHAR(128)
DETERMINISTIC	CHAR(1)
EXTERNAL_ACTION	CHAR(1)
NULL_CALL	CHAR(1)
CAST_FUNCTION	CHAR(1)
SCRATCHPAD	CHAR(1)
SCRATCHPAD_LENGTH	INTEGER
FINAL_CALL	CHAR(1)
PARALLEL	CHAR(1)
PARAMETER_STYLE	CHAR(1)
FENCED	CHAR(1)
SQL_DATA_ACCESS	CHAR(1)
DBINFO	CHAR(1)
STAYRESIDENT	CHAR(1)
ASUTIME	INTEGER
WLM_ENVIRONMENT	VARCHAR(54)
WLM_ENV_FOR_NESTED	CHAR(1)
PROGRAM_TYPE	CHAR(1)
EXTERNAL_SECURITY	CHAR(1)
COMMIT_ON_RETURN	CHAR(1)
RESULT_SETS	SMALLINT
LOBCOLUMNS	SMALLINT
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
IBMREQD	CHAR(1)
PARM1-30	SMALLINT
IOS_PER_INVOC	FLOAT
INSTS_PER_INVOC	FLOAT
INITIAL_IOS	FLOAT
INITIAL_INSTS	FLOAT
CARDINALITY	FLOAT
RESULT_COLS	SMALLINT
EXTERNAL_NAME	VARCHAR(762)
PARM_SIGNATURE	VARCHAR(150)
RUNOPTS	VARCHAR(762)
REMARKS	VARCHAR(762)
JAVA_SIGNATURE	VARCHAR(3072
CLASS	VARCHAR(384)
JARSCHEMA	VARCHAR(128)
JAR_ID	VARCHAR(128)
SPECIAL_REGS	CHAR(1)
NUM_DEP_MQTS	SMALLINT
MAX_FAILURES	SMALLINT
PARAMETER_CCSID	INTEGER
VERSION	VARCHAR(122)
CONTOKEN	CHAR(8)
ACTIVE	CHAR(1)
DEBUG_MODE	CHAR(1)
TEXT_ENVID	INTEGER
TEXT_ROWID	ROWID
TEXT	CLOB(2M)
OWNERTYPE	CHAR(1)
PARAMETER_	INTEGER
VARCHARFORM
RELCREATED	CHAR(1)
PACKAGEPATH	VARCHAR(4096
SECURE	CHAR(1)
INLINE	CHAR(1)
SYSTEM_DEFINED	CHAR(1)
WRAPPED	CHAR(1)
REGENERATETS	TIMESTAMP(12

SYSIBM.SYSROUTINES_SRC

Source for generated routines.

SCHEMA	VARCHAR(128)
ROUTINENAME	VARCHAR(128)
BUILDDATE	DATE
BUILDTIME	TIME
BUILDSTATUS	CHAR(1)
SEQNO	INTEGER
IBMREQD	CHAR(1)
CREATESTMT	VARCHAR(7500)

SYSIBM.SYSAUTOTIMEWINDOWS

One row for each time period when autonomic procedures can be run.

WINDOW_ID	BIGINT
DB2_SSID	CHAR(4)
MONTH_WEEK	CHAR(1)
MONTH	INTEGER
DAY	INTEGER
FROM_TIME	TIME
TO_TIME	TIME
ACTION	VARCHAR(256)
MAX_TASKS	INTEGER

SYSIBM.SYSAUTOALERTS

One row for each recommendation from autonomic procedures.

ALERT_ID	BIGINT
HISTORY_ENTRY_ID	BIGINT
ACTION	VARCHAR(32)
TARGET_QUALIFER	VARCHAR(128)
TARGET_OBJECT	VARCHAR(128)
TARGET_PARTITION	SMALLINT
OPTIONS	VARCHAR(4000)
CREATEDTS	TIMESTAMP
DURATION	INTEGER
STATUS	VARCHAR(32)
STARTTS	TIMESTAMP
ENDTS	TIMESTAMP
RETURN_CODE	INTEGER
ERROR_MESSAGE	VARCHAR(1331)
OUTPUT	CLOB(2M)
ROWID	ROWID

SYSIBM.SYSAUXRELS

One row for each auxiliary table created for a LOB column.

TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
COLNAME	VARHCAR(128)
PARTITION	SMALLINT
AUXTBOWNER	VARCHAR(128)
AUXTBNAME	VARCHAR(128)
AUXRELOBID	INTEGER
IBMREQD	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSTRIGGERS

One row for each trigger.

NAME	VARCHAR(128)
SCHEMA	VARCHAR(128)
DBID	SMALLINT
OBID	SMALLINT
OWNER	VARCHAR(128)
CREATEDBY	VARCHAR(128)
TBNAME	VARCHAR(128)
TBOWNER	CHAR(1)
TRIGTIME	CHAR(1)
TRIGEVENT	CHAR(1)
GRANULARITY	CHAR(1)
CREATEDTS	TIMESTAMP
IBMREQD	CHAR(1)
REMARKS	VARCHAR(762)
TRIGNAME	VARCHAR(8)
OWNERTYPE	CHAR(1)
ENVID	INTEGER
RECREATED	CHAR(1)
SECURE	CHAR(1)
ALTEREDTS	TIMESTAMP
ROWID	ROWID
SQLPL	CHAR(1)
ALTEREDTS	TIMESTAMP
DEBUG_MODE	CHAR(1)
ASUTIME	INTEGER
WLM_ENVIRONMENT	VARCHAR(96)
STATEMENT	CLOB(2M)
REGENERATES	TIMESTAMP
VERSION	VARCHAR(122)
ORIGINAL_CONTOK	CHAR(8)
ACTIVE	CHAR(1)
WRAPPED	CHAR(1)

SYSIBM.SYSDATATYPES

One row for each user-defined type defined to the system.

SCHEMA	VARCHAR(128)
OWNER	VARCHAR(128)
NAME	VARCHAR(128)
CREATEDBY	VARCHA(128)
SOURCESSCHEMA	VARCHAR(128)
SOURCETYPE	VARCHAR(128)
METATYPE	CHAR(1)
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
LENGTH	INTEGER
SCALE	SMALLINT
SUBTYPE	CHAR(1)
CREATEDTS	TIMESTAMP
ENCODING_SCHEME	CHAR(1)
IBMREQD	CHAR(1)
REMARKS	VARCHAR(762)
OWNERTYPE	CHAR(1)
RELCREATED	CHAR(1)
INLINE_LENGTH	INTEGER
ARRAYLENGTH	BIGINT
ARRAYINDEXTYPEID	INTEGER
ARRAYINDEXTYPELEN	BIGINT
ARRAYINDEXSUBTYPE	CHAR(1)

SYSIBM.SYSENVIRONMENT

Environment variables when an object is created.

ENVID	INTEGER
CURRENT_SCHEMA	VARCHAR(128)
RELCREATED	CHAR(1)
PATHSCHEMAS	VARCHAR(2048)
APPLICATION_	INTEGER
ENCODING_CCSID
ORIGINAL_	INTEGER
ENCODING_CCSID
DECIMAL_POINT	CHAR(1)
MIN_DIVIDE_SCALE	CHAR(1)
STRING_DELIMITER	CHAR(1)
SQL_STRING_DELIMITER	CHAR(1)
MIXED_DATA	CHAR(1)
DECIMAL_ARITHMETIC	CHAR(1)
DATE_FORMAT	CHAR(1)
TIME_FORMAT	CHAR(1)
FLOAT_FORMAT	CHAR(1)
HOST_LANGUAGE	CHAR(8)
CHARSET	CHAR(1)
FOLD	CHAR(1)
IBMREQD	CHAR(1)
ROUNDING	CHAR(1)
CREATEDTS	TIMESTAMP
APPLCOMPAT	VARCHAR(10)

SYSIBM.SYSKEYCOLUSE

A row for every column in a unique constraint.

CONSTNAME	VARCHAR(128)
TBCREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
COLSEQ	SMALLINT
COLNO	SMALLINT
IBMREQD	CHAR(1)
PERIOD	CHAR(1)

SYSIBM.SYSDEPENDENCIES

Dependencies between objects.

BNAME	VARCHAR(128)
BSCHEMA	VARCHAR(128)
BCOLNAME	VARCHAR(128)
BCOLNO	SMALLINT
BTYPE	CHAR(1)
BOWNER	VARCHAR(128)
BOWNERTYPE	CHAR(1)
DNAME	VARCHAR(128)
DSCHEMA	VARCHAR(128)
DVERSION	VARCHAR(122)
DCOLNAME	VARCHAR(128)
DCOLNO	SMALLINT
DTYPE	CHAR(1)
DOWNER	VARCHAR(128)
DOWNERTYPE	CHAR(1)
IBMREQD	CHAR(1)
BAUTH	SMALLINT

SYSIBM.SYSSCHEMAAUTH

Row for each user granted a privilege on a schema.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
SCHEMANAME	VARCHAR(128)
AUTHHOWGOT	CHAR(1)
CREATEINAUTH	CHAR(1)
ALTERINAUTH	CHAR(1)
DROPINAUTH	CHAR(1)
GRANTEDTS	TIMESTAMP
IBMREQD	CHAR(1)
GRANTEETYPE	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSCONSTDEP

Dependencies on check constraints on user-defined defaults.

BNAME	VARCHAR(128)
BSCHEMA	VARCHAR(128)
BTYPE	CHAR(1)
DTBNAME	VARCHAR(128)
DTBCREATOR	CHAR(8)
DCONSTNAME	VARCHAR(128)
DTYPE	CHAR(1)
IBMREQD	CHAR(1)
DTBOWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)

SYSIBM.SYSTABCONST

One row for each unique constraint.

CONSTNAME	VARCHAR(128)
TBCREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
CREATOR	CHAR(8)
TYPE	CHAR(1)
IXOWNER	VARCHAR(128)
IXNAME	VARCHAR(128)
CREATEDTS	TIMESTAMP
IBMREQD	CHAR(1)
COLCOUNT	SMALLINT
RELCREATED	CHAR(1)

SYSIBM.SYSPARMS

A row for each parameter of a routine or table parameters.

SCHEMA	VARCHAR(128)
OWNER	VARCHAR(128)
NAME	VARCHAR(128)
SPECIFICNAME	VARCHAR(128)
ROUTINETYPE	CHAR(1)
CAST_FUNCTION	CHAR(1)
PARMNAME	VARCHAR(128)
ROUTINEID	INTEGER
ROWTYPE	CHAR(1)
ORDINAL	SMALLINT
TYPESCHEMA	CHAR(8)
TYPENAME	CHAR(18)
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
LOCATOR	CHAR(1)
TABLE	CHAR(1)
TABLE_COLNO	SMALLINT
LENGTH	INTEGER
SCALE	SMALLINT
SUBTYPE	CHAR(1)
CCSID	INTEGER
CAST_FUNCTION_ID	INTEGER
ENCODING_SCHEME	CHAR(1)
IBMREQD	CHAR(1)
VERSION	VARCHAR(122)
OWNERTYPE	CHAR(1)

SYSIBM.SYSRESAUTH

Records privileges.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
QUALIFIER	VARCHAR(128)
NAME	VARCHAR(128)
AUTHHOWGOT	CHAR(1)
OBTYPE	CHAR(1)
USEAUTH	CHAR(1)
IBMREQD	CHAR(1)
GRANTEDTS	TIMESTAMP
GRANTEETYPE	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSKEYTARGETS

One row for each key-target in an extended index definition.

IXNAME	VARCHAR(128)
IXSCHEMA	VARCHAR(128)
KEYSEQ	SMALLINT
COLNO	SMALLINT
ORDERING	CHAR(1)
TYPESCHEMA	VARCHAR(128)
TYPENAME	VARCHAR(128)
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
LENGTH	SMALLINT
LENGTH2	INTEGER
SCALE	SMALLINT
NULLS	CHAR(1)
CCSID	INTEGER
SUBTYPE	CHAR(1)
CREATEDTS	TIMESTAMP
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)
DERIVED_FROM	VARCHAR(4000)
STATSTIME	TIMESTAMP
CARDF	FLOAT
HIGH2KEY	VARCHAR(2000)
LOW2KEY	VARCHAR(2000)
STATS_FORMAT	CHAR(1)

SYSIBM.SYSSTRINGS

Information about character conversion.

INCCSID	INTEGER
OUTCCSID	INTEGER
TRANSTYPE	CHAR(2)
ERRORBYTE	CHAR(1)
SUBBYTE	CHAR(1)
TRANSPROC	VARCHAR(24)
IBMREQD	CHAR(1)
TRANSTAB	VARCHAR(256)

SYSIBM.SYSTABLESPACESTATS

Real time statistics for table spaces.

UPDATESTATSTIME	TIMESTAMP
NACTIVE	INTEGER
NPAGES	INTEGER
EXTENTS	SMALLINT
LOADRLASTTIME	TIMESTAMP
REORGLASTTIME	TIMESTAMP
REORGINSERTS	INTEGER
REORGDELETES	INTEGER
REORGUPDATES	INTEGER
REORGUNCLUSTINS	INTEGER
REORGDISORGLOB	INTEGER
REORGMASSDELETE	INTEGER
REORGNEARINDREF	INTEGER
REORGFARINDEF	INTEGER
STATSLASTTIME	TIMESTAMP
STATSINSERTS	INTEGER
STATSDELETES	INTEGER
STATSUPDATES	INTEGER
STATSMASSDELETE	INTEGER
COPYLASTTIME	TIMESTAMP
COPYUPDATEDPAGES	INTEGER
COPYCHANGES	INTEGER
COPYUPDATELRSN	CHAR(10)
COPYUPDATETIME	TIMESTAMP
IBMREQD	CHAR(1)
DBID	SMALLINT
PSID	SMALLINT
PARTITION	SMALLINT
INSTANCE	SMALLINT
SPACE	INTEGER
TOTALROWS	BIGINT
DATASIZE	BIGINT
UNCOMPRESSEDDATASIZE	BIGINT
DBNAME	CHAR(8)
NAME	CHAR(8)
REORGSCANACCESS	BIGINT
REORGHASHACCESS	BIGINT
HASHLASTUSED	TIMESTAMP
REORGCLUSTERSENS	BIGINT
DRIVETYPE	CHAR(3)
LPFACILITY	CHAR(1)
UPDATESIZE	BIGINT
LATDATACHANGE	TIMESTAMP
GETPAGES	BIGINT
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSJAVAOPTS

Build options used during INSTALL_JAR.

JARSCHEMA	VARCHAR(128)
JAR_ID	VARCHAR(128)
BUILDSCHEMA	VARCHAR(128)
BUILDNAME	VARCHAR(128)
BUILDOWNER	VARCHAR(128)
DBMLIB	VARCHAR(256)
HPJCOMPILE_OPTS	VARCHAR(512)
BIND_OPTS	VARCHAR(2048)
POBJECT_LIB	VARCHAR(256)
IBMREQD	CHAR(1)

SYSIBM.SYSJAVAPATHS

The complete JAR class resolution path.

JARSCHEMA	VARCHAR(128)
JAR_ID	VARCHAR(128)
OWNER	VARCHAR(128)
ORDINAL	SMALLINT
PE_CLASS_PATTERN	VARCHAR(2048)
PE_JARSCHEMA	VARCHAR(128)
PE_JAR_ID	VARCHAR(128)
IBMREQD	CHAR(1)

SYSIBM.SYSJARCONTENTS

Java class source for installed jar.

JARSCHEMA	VARCHAR(128)
JAR_ID	VARCHAR(128)
CLASS	VARCHAR(384)
CLASS_SOURCE_ROWID	ROWID
CLASS_SOURCE	CLOB(10M)
IBMREQD	CHAR(1)

SYSIBM.SYSJAROBJECTS

Binary large object representing the installed jar.

JARSCHEMA	VARCHAR(128)
JAR_ID	VARCHAR(128)
OWNER	VARCHAR(128)
JAR_DATA_ROWID	ROWID
JAR_DATA	BLOB(100M)
PATH	VARCHAR(2048)
IBMREQD	CHAR(1)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
OWNERTYPE	CHAR(1)

SYSIBM.SYSPACKLIST

One or more rows for applications plan bound with a package list.

PLANNAME	VARCHAR(24)
SEQNO	SMALLINT
LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
TIMESTAMP	TIMESTAMP
IBMREQD	CHAR(1)

SYSIBM.SYSPACKAGE

A row for every package.

LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
CONTOKEN	CHAR(8)
OWNER	VARCHAR(128)
CREATOR	VARCHAR(128)
TIMESTAMP	TIMESTAMP
BINDTIME	TIMESTAMP
QUALIFIER	VARCHAR(128)
PKSIZE	INTEGER
AVGSIZE	INTEGER
SYSENTRIES	SMALLINT
VALID	CHAR(1)
OPERATIVE	CHAR(1)
VALIDATE	CHAR(1)
ISOLATION	CHAR(1)
RELEASE	CHAR(1)
EXPLAIN	CHAR(1)
QUOTE	CHAR(1)
COMMA	CHAR(1)
HOSTLANG	CHAR(1)
CHARSET	CHAR(1)
MIXED	CHAR(1)
DEC31	CHAR(1)
DEFERPREP	CHAR(1)
SQLERROR	CHAR(1)
REMOTE	CHAR(1)
PCTIMESTAMP	TIMESTAMP
IBMREQD	CHAR(1)
VERSION	VARCHAR(122)
PDSNAME	VARCHAR(132)
DEGREE	CHAR(3)
GROUP_MEMBER	VARCHAR(24)
DYNAMICRULES	CHAR(1)
REOPTVAR	CHAR(1)
DEFERPREPARE	CHAR(1)
KEEPDYNAMIC	CHAR(1)
PATHSCHEMAS	VARCHAR(2048)
TYPE	CHAR(1)
DBPROTOCOL	CHAR(1)
FUNCTIONTS	TIMESTAMP
OPTHINT	VARCHAR(128)
ENCODING_CCSID	INTEGER
IMMEDWRITE	CHAR(1)
RELBOUND	CHAR(1)
REMARKS	VARCHAR(762)
OWNERTYPE	CHAR(1)
ROUNDING	CHAR(1)
DISTRIBUTE	CHAR(1)
LASTUSED	DATE
CONCUR_ACC_RES	CHAR(1)
EXTENDED	CHAR(1)
INDICATOR
PLANMGMT	CHAR(1)
PLANMGMTSCOPE	CHAR(1)
APREUSE	CHAR(1)
APRETAINDUP	CHAR(1)
SYSTIMESENSITIVE	CHAR(1)
BUSTIMESENSITIVE	CHAR(1)
APPLCOMPAT	VARCHAR(10)
ARCHIVESENSITIVE	CHAR(1)
EXTSEQNO	INTEGER
DESCSTAT	CHAR(1)
ORIGIN	CHAR(1)
APREUSE_NO_FL	VARCHAR(10)
APREUSE_NO_TS	TIMESTAMP
CONC_STMT	CHAR(1)
FUNCTION_LVL	VARCHAR(10)

SYSIBM.SYSPACKAUTH

Privileges that are held by users over packages.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
TIMESTAMP	TIMESTAMP
GRANTEETYPE	CHAR(1)
AUTHHOWGOT	CHAR(1)
BINDAUTH	CHAR(1)
COPYAUTH	CHAR(1)
EXECUTEAUTH	CHAR(1)
IBMREQD	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSPACKSTMT

One or more rows for each statement in a package.

LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
CONTOKEN	CHAR(8)
SEQNO	INTEGER
STMTNO	SMALLINT
SECTNO	SMALLINT
BINDERROR	CHAR(1)
IBMREQD	CHAR(1)
VERSION	VARCHAR(122)
STMT	VARCHAR(3500)
ISOLATION	CHAR(1)
STATUS	CHAR(1)
ACCESSPATH	CHAR(1)
STMTNOI	INTEGER
SECTNOI	INTEGER
EXPLAINABLE	CHAR(1)
QUERYNO	INTEGER
ROWID	ROWID
STATEMENT	CLOB(2M)
STMT_ID	BIGINT
EXPANSION	CHAR(2)
QUERYID	BIGINT
QUERY_HASH	CHAR(6)
QUERY_HASH_VERSION	INTEGER

SYSIBM.SYSPKSYSTEM

Zero or more rows for every package.

LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
CONTOKEN	CHAR(8)
SYSTEM	VARCHAR(24)
ENABLE	CHAR(1)
CNAME	VARCHAR(60)
IBMREQD	CHAR(1)

SYSIBM.SYSPACKDEP

Dependencies of packages on local objects.

BNAME	VARCHAR(128)
BQUALIFIER	VARCHAR(128)
BTYPE	CHAR(1)
DLOCATION	VARCHAR(128)
DCOLLID	VARCHAR(128)
DNAME	VARCHAR(128)
DCONTOKEN	CHAR(8)
IBMREQD	CHAR(1)
DOWNER	VARCHAR(128)
DTYPE	CHAR(1)
DOWNERTYPE	CHAR(1)

SYSIBM.SYSPACKCOPY

A row for every previous and original package.

LOCATION	VARCHAR(128)
COLLID	VARCHAR(128)
NAME	VARCHAR(128)
CONTOKEN	CHAR(8)
OWNER	VARCHAR(128)
CREATOR	VARCHAR(128)
TIMESTAMP	TIMESTAMP
BINDTIME	TIMESTAMP
QUALIFIER	VARCHAR(128)
PKSIZE	INTEGER
AVGSIZE	INTEGER
SYSENTRIES	SMALLINT
VALID	CHAR(1)
OPERATIVE	CHAR(1)
VALIDATE	CHAR(1)
ISOLATION	CHAR(1)
RELEASE	CHAR(1)
EXPLAIN	CHAR(1)
QUOTE	CHAR(1)
COMMA	CHAR(1)
HOSTLANG	CHAR(1)
CHARSET	CHAR(1)
MIXED	CHAR(1)
DEC31	CHAR(1)
DEFERPREP	CHAR(1)
SQLERROR	CHAR(1)
REMOTE	CHAR(1)
PCTIMESTAMP	TIMESTAMP
IBMREQD	CHAR(1)
VERSION	VARHCAR(122)
PDSNAME	VARCHAR(132)
DEGREE	CHAR(3)
GROUP_MEMBER	VARCHAR(24)
DYNAMICRULES	CHAR(1)
REOPTVAR	CHAR(1)
DEFERPREPARE	CHAR(1)
KEEPDYNAMIC	CHAR(1)
PATHSCHEMAS	VARCHAR(2048
TYPE	CHAR(1)
DBPROTOCOL	CHAR(1)
FUNCTIONTS	TIMESTAMP
OPTHINT	VARCHAR(128)
ENCODING_CCSID	INTEGER
IMMEDWRITE	CHAR(1)
RELBOUND	CHAR(1)
REMARKS	VARCHAR(762)
OWNERTYPE	CHAR(1)
ROUNDING	CHAR(1)
DISTRIBUTE	CHAR(1)
LASTUSED	DATE
CONCUR_ACC_RES	CHAR(1)
EXTENDEDINDICATOR	CHAR(1)
PLANMGMT	CHAR(1)
PLANMGMTSCOPE	CHAR(1)
APREUSE	CHAR(1)
APRETAINDUP	CHAR(1)
SYSTIMESENSITIVE	CHAR(1)
BUSTIMESENSITIVE	CHAR(1)
APPLCOMPAT	VARCHAR(10)
ARCHIVESENSITIVE	CHAR(1)
EXTSEQNO	INTEGER
DESCSTAT	CHAR(1)
ORIGIN	CHAR(1)
APREUSE_NO_FL	VARCHAR(10)
APRESUE_NO_TS	TIMESTAMP
CONC_STMT	CHAR(1)
FUNCTION_LVL	VARCHAR(10)

SYSIBM.SYSAUDITPOLICIES

One row for each audit policy.

AUDITPOLICYNAME	VARCHAR(128)
OBJECTSCHEMA	VARCHAR(128)
OBJECTNAME	VARCHAR(128)
OBJECTTYPE	CHAR(1)
CREATEDTS	TIMESTAMP
ALTERDTS	TIMESTAMP
CHECKING	CHAR(1)
VALIDATE	CHAR(1)
OBJMAINT	CHAR(1)
EXECUTE	CHAR(1)
CONTEXT	CHAR(1)
SECMAINT	CHAR(1)
SYSADMIN	VARCHAR(128)
DBADMIN	VARCHAR(128)
DBNAME	VARCHAR(24)
COLLID	VARCHAR(128)
DB2START	CHAR(1)
IBMREQD	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSOBJROLEDEP

Dependent objects for each role.

DEFINER	VARCHAR(128)
DEFINERTYPE	CHAR(1)
ROLENAME	VARCHAR(128)
DSCHEMA	VARCHAR(128)
DNAME	VARCHAR(128)
DTYPE	CHAR(1)
IBMREQD	CHAR(1)

SYSIBM.SYSROLES

One row for each role.

NAME	VARCHAR(128)
DEFINER	VARCHAR(128)
DEFINERTYPE	CHAR(1)
CREATEDTS	TIMESTAMP
RELCREATED	CHAR(1)
REMARKS	VARCHAR(762)
IBMREQD	CHAR(1)

SYSIBM.SYSSEQUENCESDEP

Records the dependencies of identity columns on tables.

BSEQUENCEID	INTEGER
DCREATOR	VARCHAR(128)
IBMREQD	CHAR(1)
DNAME	VARCHAR(128)
DCOLNAME	VARCHAR(128)
DTYPE	CHAR(1)
BSCHEMA	VARCHAR(129)
BNAME	VARCHAR(128)
DSCHEMA	VARCHAR(128)
DOWNER	VARCHAR(128)
DOWNERTYPE	CHAR(1)

SYSIBM.SYSSEQUENCEAUTH

Records the privileges held by users over sequences.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
SCHEMA	VARCHAR(128)
NAME	VARCHAR(128)
GRANTEETYPE	CHAR(1)
AUHTHOWGOT	CHAR(1)
ALTERAUTH	CHAR(1)
USEAUTH	CHAR(1)
COLLID	VARCHAR(128)
CONTOKEN	CHAR(8)
GRANTEDTS	TIMESTAMP
IBMREQD	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSSEQUENCES

One row for each identity column or user-defined sequence.

SCHEMA	VARCHAR(128)
OWNER	VARCHAR(128)
NAME	VARCHAR(128)
SEQTYPE	CHAR(1)
SEQUENCEID	INTEGER
CREATEDBY	VARCHAR(128)
INCREMENT	DECIMAL(31,0)
START	DECIMAL(31,0)
MAXVALUE	DECIMAL(31,0)
MINVALUE	DECIMAL(31,0)
CYCLE	CHAR(1)
CACHE	INTEGER
ORDER	CHAR(1)
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
MAXASSIGN_EDVAL	DECIMAL(31,0)
IBMREQD	CHAR(1)
REMARKS	VARCHAR(254)
PRECISION	SMALLINT
RESTARTWITH	DECIMAL(31,0)
OWNERTYPE	CHAR(1)
RELCREATED	CHAR(1)
SEQSCHEMA	VARCHAR(128)
SEQNAME	VARCHAR(128)

SYSIBM.SYSDATABASE

One row for each database.

CREATOR	VARCHAR(128)
STGROUP	VARCHAR(128)
BPOOL	CHAR(8)
DBID	SMALLINT
IBMREQD	CHAR(1)
CREATEDBY	VARCHAR(128)
TYPE	CHAR(1)
GROUP_MEMBER	VARCHAR(24)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
ENCODING_SCHEME	CHAR(1)
SBCS_CCSID	INTEGER
DBCS_CCSID	INTEGER
MIXED_CCSID	INTEGER
INDEXBP	CHAR(8)
CREATORTYPE	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSDBAUTH

One row for each database.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
NAME	VARCHAR(24)
GRANTEETYPE	CHAR(1)
AUTHHOWGOT	CHAR(1)
CREATETABAUTH	CHAR(1)
CREATETSAUTH	CHAR(1)
DBADMAUTH	CHAR(1)
DBCTRLAUTH	CHAR(1)
DBMAINTAUTH	CHAR(1)
DISPLAYDBAUTH	CHAR(1)
DROPAUTH	CHAR(1)
IMAGCOPYAUTH	CHAR(1)
LOADAUTH	CHAR(1)
REORGAUTH	CHAR(1)
RECOVERDBAUTH	CHAR(1)
REPAIRAUTH	CHAR(1)
STARTDBAUTH	CHAR(1)
STATSAUTH	CHAR(1)
STOPAUTH	CHAR(1)
IBMREQD	CHAR(1)
GRANTEDTS	TIMESTAMP
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSTABLES_PROFILES

One row for each profile for a table in SYSIBM.SYSTABLES

SCHEMA	VARCHAR(128)
TBNAME	VARCHAR(128)
PROFILE_TYPE	VARCHAR(32)
PROFILE_TEXT	CLOB(1M)
ROWID	ROWID
PROFILE_UPDATE	TIMESTAMP
PROFILE_USED	TIMESTAMP

SYSIBM.SYSINDEXES

One row for every index.

NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
TBCREATOR	VARCHAR(128)
UNIQUERULE	CHAR(1)
COLCOUNT	SMALLINT
CLUSTERING	CHAR(1)
CLUSTERED	CHAR(1)
DBID	SMALLINT
OBID	SMALLINT
ISOBID	SMALLINT
DBNAME	VARCHAR(24)
INDEXSPACE	VARCHAR(24)
NLEAF	INTEGER
NLEVELS	SMALLINT
BPOOL	CHAR(8)
PGSIZE	SMALLINT
ERASERULE	CHAR(1)
CLOSERULE	CHAR(1)
SPACE	INTEGER
IBMREQD	CHAR(1)
CLUSTERRATIO	SMALLINT
CREATEDBY	VARCHAR(128)
STATSTIME	TIMESTAMP
INDEXTYPE	CHAR(1)
FIRSTKEYCARDF	FLOAT
FULLKEYCARDF	FLOAT
CREATEDTS	TIMESTAMP
ALTEREDTD	TIMESTAMP
PIECESIZE	INTEGER
COPY	CHAR(1)
COPYLRSN	CHAR(10)
CLUSTERRATIOF	FLOAT
SPACEF	FLOAT(8)
REMARKS	VARCHAR(762)
PADDED	CHAR(1)
VERSION	SMALLINT
OLDEST_VERSION	SMALLINT
CURRENT_VERSION	SMALLINT
RELCREATED	CHAR(1)
AVGKEYLEN	INTEGER
KEYTARGET_COUNT	SMALLINT
UNIQUE_COUNT	SMALLINT
IX_EXTENSION_TYPE	CHAR(1)
COMPRESS	CHAR(1)
OWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)
DATAREPEATFACTOROF	FLOAT
ENVID	INTEGER
HASH	CHAR(1)
SPARSE	CHAR(1)
ROWID	ROWID
DSSIZE	INTEGER
PAGENUM	CHAR(1)
PARTKEYCOLUMN	SMALLINT
STATUS	CHAR(1)
INDEXSTATUS	SMALLINT
PARTITIONS	VARCHAR(765)
PQTY	INTEGER
STORTYPE	CHAR(1)
STORNAME	VARCHAR(128)
VCATNAME	VARCHAR(24)
FREEPAGE	SMALLINT
PCTFREE	SMALLINT
GBPCACHE	CHAR(1)
SECQTY1	INTEGER
ENFORCED_CONS	CHAR(1)
IMPLICIT	CHAR(1)
REGENERATETS	TIMESTAMP(12)

SYSIBM.SYSINDEXCLEANUP

Time windows to control index cleanup processing.

DBNAME	VARCHAR(24)
INDEXSPACE	VARCHAR(24)
ENABLE_DISABLE	CHAR(1)
MONTH_WEEK	CHAR(1)
MONTH	SMALLINT
DAY	SMALLINT
START_TIME	TIME
END_TIME	TIME

SYSIBM.SYSFOREIGNKEYS

One row for every column of every foreign key.

CREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
RELNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
COLNO	SMALLINT
COLSEQ	SMALLINT
IBMREQD	CHAR(1)

SYSIBM.SYSINDEXPART

One row for each NPI and one row for each partition of a partioning index or DPSI.

PARTITION	SMALLINT
IXNAME	VARCHAR(128)
IXCREATOR	VARCHAR(128)
PQTY	INTEGER
SQTY	SMALLINT
STORTYPE	CHAR(1)
STORNAME	VARCHAR(128)
VCATNAME	VARCHAR(24)
LEAFDIST	INTEGER
IBMREQD	CHAR(1)
LIMITKEY	VARCHAR(512)
FREEPAGE	SMALLINT
PCTFREE	SMALLINT
SPACE	INTEGER
STATSTIME	TIMESTAMP
GBPCACHE	CHAR(1)
FAROFFPOSF	FLOAT
NEAROFFPOST	FLOAT
CARDF	FLOAT
SECQTYI	INTEGER
IPREFIX	CHAR(1)
ALTEREDTS	TIMESTAMP
SPACEF	FLOAT(8)
DSNUM	INTEGER
EXTENTS	INTEGER
PSEUDO_DEL_ENTRIES	INTEGER
LEAFNEAR	INTEGER
LEAFFAR	INTEGER
OLDEST_VERSION	SMALLINT
CREATEDTS	TIMESTAMP
AVGKEYLEN	INTEGER
RBA_FORMAT	CHAR(1)
DSSIZE	INTEGER
PAGENUM	CHAR(1)
LIMITKEY_EXTERNAL	VARCHAR(765)

SYSIBM.SYSTABLES

One row for each table, view, or alias.

NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
TYPE	CHAR(1)
DBNAME	VARCHAR(24)
TSNAME	VARCHAR(24)
DBID	SMALLINT
OBID	SMALLINT
COLCOUNT	SMALLINT
EDPROC	VARCHAR(24)
VALPROC	VARCHAR(24)
CLUSTERTYPE	CHAR(1)
NPAGES	INTEGER
PCTPAGES	SMALLINT
IBMREQD	CHAR(1)
REMARKS	VARCHAR(254)
PARENTS	SMALLINT
CHILDREN	SMALLINT
KEYCOLUMNS	SMALLINT
RECLENGTH	SMALLINT
STATUS	CHAR(1)
KEYOBID	SMALLINT
LABEL	VARCHAR(90)
CHECKFLAG	CHAR(1)
CHECKRID	CHAR(4)
AUDITING	CHAR(1)
CREATEDBY	VARCHAR(128)
LOCATION	VARCHAR(128)
TBCREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
DATACAPTURE	CHAR(1)
RBA1	CHAR(10)
RBA2	CHAR(10)
PCTROWCOMP	SMALLINT
STATSTIME	TIMESTAMP
CHECKS	SMALLINT
CARDF	FLOAT
CHECKRID5B	CHAR(5)
ENCODING_SCHEME	CHAR(1)
TABLESTATUS	VARCHAR(30)
NPAGESF	FLOAT(8)
SPACEF	FLOAT(8)
AVGROWLEN	INTEGER
RELCREATED	CHAR(1)
NUM_DEPT_MQTS	SMALLINT
VERSION	SMALLINT
PARTKEYCOLNUM	SMALLINT
SPLIT_ROWS	CHAR(16)
SECURITY_LABEL	CHAR(1)
OWNER	VARCHAR(128)
APPEND	CHAR(1)
OWNERTYPE	CHAR(1)
CONTROL	CHAR(1)
VERSIONING_SCHEMA	VARCHAR(128)
VERSIONING_TABLE	VARCHAR(128)
HASHKEYCOLUMNS	SMALLINT
ARCHIVING_SCHEMA	VARCHAR(128)
ARCHIVING_TABLE	VARCHAR(128)
STATS_FEEDBACK	CHAR(1)
REGENERATETS	TIMESTAMP(12)

SYSIBM.SYSTABLEPART

One row for each non-partitioned tablespace and one row for each partion of a partitioned tablespace.

PARTITION	SMALLINT
TSNAME	VARCHAR(24)
DBNAME	VARCHAR(24)
IXNAME	VARCHAR(128)
IXCREATOR	VARCHAR(128)
PQTY	INTEGER
SQTY	SMALLINT
STORTYPE	CHAR(1)
STORNAME	VARCHAR(128)
VCATNAME	VARCHAR(24)
CARD	INTEGER
FARINDREF	INTEGER
NEARINDREF	INTEGER
PERACTIVE	SMALLINT
PERCDROP	SMALLINT
IBMREQD	CHAR(1)
LIMITKEY	VARCHAR(765)
FREEPAGE	SMALLINT
PCTFREE	SMALLINT
CHECKFLAG	CHAR(1)
SPACE	INTEGER
COMPRESS	CHAR(1)
PAGESAVE	SMALLINT
STATSTIME	TIMESTAMP
GBPCACHE	CHAR(1)
CHECKRID5B	CHAR(5)
TRACKMOD	CHAR(1)
EPOCH	INTEGER
SECQTYI	INTEGER
CARDF	FLOAT
IPREFIX	CHAR(1)
ALTEREDTS	TIMESTAMP
SPACEF	FLOAT(8)
DSNUM	FLOAT(8)
EXTENTS	INTEGER
LOGICAL_PART	SMALLINT
LIMITKEY_INTERNAL	VARCHAR(512)
OLDEST_VERSION	SMALLINT
CREATDTS	TIMESTAMP
AVGROWLEN	INTEGER
FORMAT	CHAR(1)
RELCREATED	CHAR(1)
REORG_LR_TS	TIMESTAMP
HASHSPACE	BIGINT
HASHDATAPAGES	BIGINT
RBA_FORMAT	CHAR(1)
PCTFREE_UPD	SMALLINT
PCTFREE_UPD_CALC	SMALLINT
TYPE	CHAR(1)
PAGENUM	CHAR(1)
BPOOL	CHAR(8)
PGSIZE	SMALLINT
DSSIZE	INTEGER
MEMBER_CLUSTER	CHAR(1)
COMPRESSRATIO	SMALLINT

SYSIBM.SYSKEYS

One row for each column of an index key.

IXNAME	VARCHAR(128)
IXCREATOR	VARCHAR(128)
COLNAME	VARHCAR(128)
COLNO	SMALLINT
COLSEQ	SMALLINT
ORDERING	CHAR(1)
IBMREQD	CHAR(1)
PERIOD	CHAR(1)

SYSIBM.SYSTABLESPACE

One row for each table space.

NAME	VARCHAR(24)
CREATOR	VARCHAR(128)
DBNAME	VARCHAR(24)
DBID	SMALLINT
OBID	SMALLINT
PSID	SMALLINT
BPOOL	CHAR(8)
PARTITIONS	SMALLINT
LOCKRULE	CHAR(1)
PGSIZE	SMALLINT
ERASERULE	CHAR(1)
STATUS	CHAR(1)
IMPLICIT	CHAR(1)
NTABLES	SMALLINT
NACTIVE	INTEGER
CLOSERULE	CHAR(1)
SPACE	INTEGER
IBMREQD	CHAR(1)
SEGSIZE	SMALLINT
CREATEDBY	VARCHAR(128)
STATSTIME	TIMESTAMP
LOCKMAX	INTEGER
TYPE	CHAR(1)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
ENCODING_SCHEME	CHAR(1)
SBCS_CCSID	INTEGER
DBCS_CCSID	INTEGER
MIXED_CCSID	INTEGER
MAXROWS	SMALLINT
LOCKPART	CHAR(1)
LOG	CHAR(1)
NACTIVEF	FLOAT
DSSIZE	INTEGER
OLDEST_VERSION	SMALLINT
CURRENT_VERSION	SMALLINT
AVGROWLEN	INTEGER
SPACEF	FLOAT
CREATORTYPE	CHAR(1)
RELCREATED	CHAR(1)
INSTANCE	SMALLINT
CLONE	CHAR(1)
MAXPARTITIONS	SMALLINT
MEMBER_CLUSTER	CHAR(1)
ORGANIZATIONTYPE	CHAR(1)
HASHSPACE	BIGINT
HASHDATAPAGES	BIGINT
PAGENUM	CHAR(1)
PQTY	INTEGER
STORTYPE	CHAR(1)
STORNAME	VARCHAR(128)
VCATNAME	VARCHAR(24)
FREEPAGE	SMALLINT
PCTFREE	SMALLINT
COMPRESS	CHAR(1)
GBPCACHE	CHAR(1)
TRACKMOD	CHAR(1)
SECQTY1	INTEGER
PCTFREE_UPD	SMALLINT
PCTFREE_UPD_CALC	SMALLINT
COMPRESSRATIO	SMALLINT
INSERTALG	SMALLINT

SYSIBM.SYSRELS

One row for every referential constraint.

CREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
RELNAME	VARCHAR(128)
REFTBNAME	VARCHAR(128)
REFTBCREATOR	VARCHAR(128)
COLCOUNT	SMALLINT
DELETERULE	CHAR(1)
IBMREQD	CHAR(1)
RELOBID1	SMALLINT
RELOBID2	SMALLINT
TIMESTAMP	TIMESTAMP
IXOWNER	VARCHAR(128)
IXNAME	VARCHAR(128)
ENFORCED	CHAR(1)
CHECKEXISTINGDATA	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSCOLAUTH

Privileges held by users on individual columns.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
GRANTEETYPE	CHAR(1)
CREATOR	VARCHAR(128)
TNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
IBMREQD	CHAR(1)
COLLID	CHAR(128)
CONTOKEN	CHAR(8)
PRIVILEGE	CHAR(1)
GRANTEDTS	TIMESTAMP
GRANTEDORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSSYNONYMS

Privileges held by users on individual columns.

NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
TBCREATOR	VARCHAR(128)
IBMREQD	CHAR(1)
CREATEDBY	VARCHAR(128)
CREATEDTS	TIMESTAMP
CREATORTYPE	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSFIELDS

One row for every column that has a field procedure.

TBCREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
COLNO	SMALLINT
NAME	VARCHAR(128)
FLDTYPE	VARCHAR(24)
LENGTH	SMALLINT
SCALE	SMALLINT
FLDPROC	VARCHAR(24)
WORKAREA	SMALLINT
IBMREQD	CHAR(1)
EXITPARML	SMALLINT
PARMLIST	VARCHAR(735)
EXITPARM	VARCHAR(1530)

SYSIBM.SYSINDEXSPACESTATS

Contains real time statistics for index spaces.

UPDATESTATTIME	TIMESTAMP
NLEVELS	SMALLINT
NPAGES	INTEGER
NLEAF	INTEGER
NACTIVE	INTEGER
SPACE	INTEGER
EXTENTS	SMALLINT
LOADRLASTTIME	TIMESTAMP
REBUILDLASTTIME	TIMESTAMP
REORGLASTTIME	TIMESTAMP
REORGINSERTS	INTEGER
REORGDELETES	INTEGER
REORGAPPENDINSERT	INTEGER
REORGPSEUDODELETES	INTEGER
REORGMASSDELETE	INTEGER
REORGLEAFNEAR	INTEGER
REORGLEAFFAR	INTEGER
REORGNUMLEVELS	INTEGER
STATSLASTTIME	TIMESTAMP
STATSINSERTS	INTEGER
STATSDELETES	INTEGER
STATSMASSDELETE	INTEGER
COPYLASTTINE	TIMESTAMP
COPYUPDATEPAGES	INTEGER
COPYCHANGES	INTEGER
COPYUPDATELRSN	CHAR(10)
COPYUPDATETIME	TIMESTAMP
IBMREQD	CHAR(1)
DBID	SMALLINT
ISOBID	SMALLINT
PSID	SMALLINT
PARTITION	SMALLINT
INSTANCE	SMALLINT
TOTALENTRIES	BIGINT
DBNAME	VARCHAR(24)
NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
INDEXSPACE	VARCHAR(24)
LASTUSED	DATE
REORGINDEXACCESS	BIGINT
DRIVETYPE	CHAR(3)
GETPAGES	BIGINT
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSCOLUMNS

One row for every column of each table and view.

NAME	VARCHAR(128)
TBNAME	VARCHAR(128)
TBCREATOR	VARCHAR(128)
COLNO	SMALLINT
COLTYPE	CHAR(8)
LENGTH	SMALLINT
SCALE	SMALLINT
NULLS	CHAR(1)
HIGH2KEY	VARCHAR(2000)
LOW2KEY	VARCHAR(2000)
UPDATES	CHAR(1)
IBMREQD	CHAR(1)
REMARKS	VARCHAR(72)
DEFAULT	CHAR(1)
KEYSEQ	SMALLINT
FOREIGNKEY	CHAR(1)
FLDPROC	CHAR(1)
LABEL	VARCHAR(90)
STATSTIME	TIMESTAMP
DEFAULTVALUE	VARCHAR(1536)
COLCARDF	FLOAT
COLSTATUS	CHAR(1)
LENGTH2	INTEGER
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
TYPESCHEMA	VARCHAR(128)
TYPENAME	VARCHAR(128)
CREATEDTS	TIMESTAMP
STATS_FORMAT	CHAR(1)
PARTKEY_COLSEQ	SMALLINT
PARTKEY_ORDERING	CHAR(1)
ALTERDTS	TIMESTAMP
CCSID	INTEGER
HIDDEN	INTEGER
RELCREATED	CHAR(1)
CONTROL_ID	INTEGER
XML_TYPEMOD_ID	INTEGER
PERIOD	CHAR(1)
GENERATE_ATTR	CHAR(1)
HASHKEY_COLSEQ	SMALLINT
ENCODING_SCHEME	CHAR(1)

SYSIBM.SYSTABAUTH

Records privileges on tables and views.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
GRANTEETYPE	CHAR(1)
DBNAME	VARCHAR(24)
SCREATOR	VARCHAR(128)
STNAME	VARCHAR(128)
TCREATOR	VARCHAR(128)
TTNAME	VARCHAR(128)
AUTHHOWGOT	CHAR(1)
UPDATECOLS	CHAR(1)
ALTERAUTH	CHAR(1)
DELETEAUTH	CHAR(1)
INDEXAUTH	CHAR(1)
INSERTAUTH	CHAR(1)
SELECTAUTH	CHAR(1)
UPDATEAUTH	CHAR(1)
IBMREQD	CHAR(1)
COLLID	VARCHAR(128)
CONTOKEN	CHAR(8)
REFERENCESAUTH	CHAR(1)
REFCOLS	CHAR(1)
GRANTEDTS	TIMESTAMP
TRIGGERAUTH	CHAR(1)
GRANTORTYPE	CHAR(1)
UNLOADAUTH	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSSTMT

One or more rows for SQL statements of a DBRM.

NAME	VARCHAR(24)
PLNAME	VARCHAR(24)
PLCREATOR	VARCHAR(128)
SEQNO	SMALLINT
STMTNO	SMALLINT
SECTNO	SMALLINT
IBMREQD	CHAR(1)
TEXT	VARCHAR(3800)
ISOLATION	CHAR(1)
STATUS	CHAR(1)
ACCESSPATH	CHAR(1)
STMTNOI	INTEGER
SECTNOI	INTEGER
EXPLAINABLE	CHAR(1)
QUERYNO	INTEGER
PLCREATOR	CHAR(1)

SYSIBM.SYSDBRM

One row for each DBRM of each application plan.

NAME	VARCHAR(24)
TIMESTAMP	CHAR(8)
PDSNAME	CHAR(132)
PLNAME	VARCHAR(24)
PLCREATOR	VARCHAR(128)
QUOTE	CHAR(1)
COMMA	CHAR(1)
HOSTLANG	CHAR(1)
IBMREQD	CHAR(1)
CHARSET	CHAR(1)
MIXED	CHAR(1)
DEC31	CHAR(1)
VERSION	VARCHAR(122)
PRECOMPTS	TIMESTAMP
PLCREATORTYPE	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSPLANDEP

Dependencies of plan on other objects.

BNAME	VARCHAR(128)
BCREATOR	VARCHAR(128)
BTYPE	CHAR(1)
DNAME	VARCGHAR(24)
IBMREQD	CHAR(1)

SYSIBM.SYSPLAN

One row for each application plan.

NAME	VARCHAR(24)
CREATOR	VARCHAR(128)
VALIDATE	CHAR(1)
ISOLATION	CHAR(1)
VALID	CHAR(1)
OPERATIVE	CHAR(1)
PLSIZE	INTEGER
IBMREQD	CHAR(1)
AVGSIZE	INTEGER
ACQUIRE	CHAR(1)
RELEASE	CHAR(1)
EXPLAIN	CHAR(1)
EXPREDICATE	CHAR(1)
BOUNDBY	VARCHAR(128)
QUALIFIER	VARCHAR(128)
CACHESIZE	SMALLINT
PLENTRIES	SMALLINT
DEFERPREP	CHAR(1)
CURRENT_SERVER	VARCHAR(128)
SYSENTRIES	SMALLINT
DEGREE	CHAR(3)
SQLRULES	CHAR(1)
DISCONNECT	CHAR(1)
GROUP_MEMBER	VARCHAR(24)
DYNAMICRULES	CHAR(1)
BOUNDTS	TIMESTAMP
REOPTVAR	CHAR(1)
KEEPDYNAMIC	CHAR(1)
PATHSCHEMAS	VARCHAR(254)
DBPROTOCOL	CHAR(1)
FUNCTIONTS	TIMESTAMP
OPTHINT	CHAR(8)
ENCODING_CCSID	INTEGER
IMMEDWRITE	CHAR(1)
RELBOUND	CHAR(1)
REMARKS	VARCHAR(128)
CREATORTYPE	CHAR(1)
ROUNDING	CHAR(1)
CONCUR_ACC_RES	CHAR(1)
PROGAUTH	CHAR(1)

SYSIBM.SYSPLANAUTH

Privileges held by users over application plans.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
NAME	VARCHAR(24)
AUTHOWGOT	CHAR(1)
BINDAUTH	CHAR(1)
EXECUTEAUTH	CHAR(1)
IBMREQD	CHAR(1)
GRANTEDTS	TIMESTAMP
GRANTEETYPE	CHAR(1)
GRANTORTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSPLSYSTEM

Connections to an environment for a plan.

NAME	VARCHAR(24)
SYSTEM	VARCHAR(24)
ENABLE	CHAR(1)
CNAME	VARCHAR(60)
IBMREQD	CHAR(1)

SYSIBM.SYSPENDINGDDL

Pending definition changes.

DBNAME	VARCHAR(24)
TSNAME	VARCHAR(24)
DBID	SMALLINT
PSID	SMALLINT
OBJSCHEMA	VARCHAR(128)
OBJNAME	VARCHAR(128)
OBJOBID	SMALLINT
OBJTYPE	CHAR(1)
STATEMENT_TYPE	CHAR(1)
OPTION_ENVID	INTEGER
OPTION_KEYWORD	VARCHAR(128)
OPTION-VALUE	VARCHAR(4000)
OPTION_SEQNO	SMALLINT
CREATEDTS	TIMESTAMP(12)
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)
ROWID	ROWID
STATEMENT_TEXT	CLOB(2M)
COLNAME	VARCHAR(128)
PARTITION	SMALLINT
PARTITION_KEYWORD	VARCHAR(18)
COLUMN_KEYWORD	VARCHAR(18)
REORG_SCOPE_LOWPART	SMALLINT
REORG_SCOPE_HIGHPART	SMALLINT

SYSIBM.SYSPENDINGOBJECTS

Name of and OBID about objects pending creation.

DBNAME	VARCHAR(24)
TSNAME	VARCHAR(24)
DBID	SMALLINT
PSID	SMALLINT
PARTITION	SMALLINT
COLNAME	VARCHAR(128)
OBJSCHEMA	VARCHAR(128)
OBJNAME	VARCHAR(128)
OBJTYPE	CHAR(1)
INDEXSPACE	VARCHAR(24)
OBJOBID	SMALLINT
OBJPSID	SMALLINT

SYSIBM.SYSDUMMY1(A,E,U)

Contains one row. ASCII(A), EBCIDIC(E), or Unicode(U).

IBMREQD

CHAR(1)

SYSIBM.SYSVARIABLEAUTH

One row for each global variable privilege.

GRANTOR	VARCHAR(128)
GRANTORTYPE	CHAR(1)
GRANTEE	VARCHAR(128)
GRANTEETYPE	CHAR(1)
SCHEMA	VARCHAR(128)
NAME	VARCHAR(128)
COLLID	VARCHAR(128)
CONTOKEN	CHAR(8)
READAUTH	CHAR(1)
WRITEAUTH	CHAR(1)
AUTHHOWGOT	CHAR(1)
GRANTEDTS	TIMESTAMP
IBMREQD	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSVARIABLES

One row for each global variable.

VARID	BIGINT
SCHEMA	VARCHAR(128)
NAME	VARCHAR(128)
OWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)
RELCREATED	CHAR(1)
CREATEDTS	TIMESTAMP
TYPESCHEMA	VARCHAR(128)
TYPENAME	VARCHAR(128)
DATATYPEID	INTEGER
SOURCETYPEID	INTEGER
LENGTH	INTEGER
SCALE	SMALLINT
CCSID	INTEGER
DEFAULT	CHAR(3)
ROWID	ROWID
DEFAULTEXT	CLOB(2M)
ENVID	INTEGER
REMARKS	VARCHAR(762)
IBMREQD	CHAR(1)

SYSIBM.LULIST

Multiple LU names for a given LOCATION.

LINKNAME	VARCHAR(24)
LUNAME	VARCHAR(24)
IBMREQD	CHAR(1)

SYSIBM.LUNAMES

A row for each remote SNA client or server.

LUNAME	VARCHAR(24)
SYSMODENAME	VARCHAR(24)
SECURITY_IN	CHAR(1)
SECURITY_OUT	CHAR(1)
ENCRYPTPSWDS	CHAR(1)
MODESELECT	CHAR(1)
USERNAMES	CHAR(1)
GENERIC	CHAR(1)
IBMREQD	CHAR(1)

SYSIBM.IPLIST

Multiple IP addresses for a given LOCATION.

LINKNAME	VARCHAR(24)
IPADDR	VARCHAR(254)
IBMREQD	CHAR(1)

SYSIBM.IPNAMES

Defines remote DRDA servers using TCP/IP.

LINKNAME	VARCHAR(24)
SECURITY_OUT	CHAR(1)
USERNAMES	CHAR(1)
IBMREQD	CHAR(1)
IPADDR	VARCHAR(254)

SYSIBM.LUNAMES

Contains a row for every accessible remote server.

LOCATION	VARCHAR(128)
LINKNAME	VARCHAR(128)
IBMREQD	CHAR(1)
PORT	VARCHAR(96)
TPN	VARCHAR(192)
DBALIAS	VARCHAR(128)
TRUSTED	CHAR(1)
SECURE	CHAR(1)

SYSIBM.LUNAMES

Conversation limits for LUNAME and MODENAME.

LUNAME	VARCHAR(24)
MODENAME	VARCAHR(24)
CONVLIMIT	SMALLINT
IBMREQD	CHAR(1)

SYSIBM.USERNAMES

Outbound or Inbound ID translation and "come from" checking.

TYPE	CHAR(1)
AUTHID	VARCHAR(128)
LINKNAME	VARCHAR(24)
NEWAUTHID	VARCHAR(128)
PASSWORD	VARCHAR(24)
IBMREQD	CHAR(1)

SYSIBM.SYSQUERYPLAN

Plan hint information for queries in SYSIBM.SYSQUERY.

QUERYID	BIGINT
COPYID	SMALLINT
PLAN_VALID	CHAR(1)
IBMREQD	CHAR(1)
QBLOCKNO	SMALLINT
PLANNO	SMALLINT
METHOD	SMALLINT
CREATOR	VARCAHR(128)
TNAME	VARCHAR(128)
ACCESSTYPE	CHAR(2)
MATCHCOLS	SMALLINT
ACCESSCREATOR	VARCHAR(128)
ACCESSNAME	VARCHAR(128)
INDEXONLY	CHAR(1)
SORTN_UNIQ	CHAR(1)
SORTN_JOIN	CHAR(1)
SORTN_ORDERBY	CHAR(1)
SORTN_GROUPBY	CHAR(1)
SORTC_UNIQ	CHAR(1)
SORTC_JOIN	CHAR(1)
SORTC_ORDERBY	CHAR(1)
SORTC_GROUPBY	CHAR(1)
TSLOCKMODE	CHAR(3)
PREFETCH	CHAR(1)
COLUMN_FN_EVAL	CHAR(1)
MIXOPSEQ	SMALLINT
ACCESS_DEGREE	SMALLINT
ACCESS_PGROUP_ID	SMALLINT
JOIN_DEGREE	SMALLINT
JOIN_PGROUP_ID	SMALLINT
SORTC_PGROUP_ID	SMALLINT
SORTN_PGROUP_ID	SMALLINT
PARALLELISM_MODE	CHAR(1)
MERGE_JOIN_COLS	SMALLINT
CORRELATION_NAME	VARCHAR(128)
PAGE_RANGE	CHAR(1)
JOIN_TYPE	CHAR(1)
QBLOCK_TYPE	CHAR(6)
ACCESSTYPEPRIMARY_	CHAR(1)
PARENT_QBLOCK	SMALLINT
TABLE_TYPE	CHAR(1)
TABLE_ENCODE	CHAR(1)
TABLE_SCCSID	SMALLINT
TABLE_MCCSID	SMALLINT
TABLE_DCCSID	SMALLINT
CTREF	SMALLINT
PARENT_PLANNO	SMALLINT
EXPANSION_REASON	SMALLINT

SYSIBM.SYSQUERY

Information for access path selection for a statement.

QUERYID	BIGINT
QUERY_HASH	CHAR(16)
SCHEMA	VARCHAR(128)
QUERY_SEC_HASH	CHAR(16)
QUERY_HASH_VERSION	INTEGER
SOURCE	SMALLINT
USERFILTER	CHAR(8)
PLAN_VALID	CHAR(1)
INVALID_REASON	INTEGER
COLLECTION	VARCHAR(128)
PACKAGE	VARCHAR(128)
VERSION	VARCHAR(128)
AUTHID	VARCHAR(128)
BINDTIME	TIMESTAMP
STMTNO	INTEGER
SECTNO	INTEGER
STMTTEXT	CLOB(2M)
QUERYNO	INTEGER
CLIENT_USERID	VARCHAR(255)
CLIENT_WRKSTNNAME	VARCHAR(255)
CLIENT_APPLNAME	VARCHAR(255)
SELECTIVITY_OVERRIDE	CHAR(1)
ACCESSPATH_HINT	CHAR(1)
OPTION_OVERRIDE	CHAR(1)
SELECTIVITY_VALID	CHAR(1)
FUNCTION_LVL	VARCHAR(10)

SYSIBM.SYSQUERYPREDICATE

Predicates identified for extended optimization.

QUERYID	BIGINT
QUERYNO	INTEGER
QBLOCKNO	SMALLINT
APPLNAME	VARCHAR(24)
POGNAME	VARCHAR(128)
PREDNO	INTEGER
TYPE	CHAR(8)
LEFT_HAND_SIDE	VARCHAR(128)
LEFT_HAND_PHO	INTEGER
LHS_TABNO	SMALLINT
LHS_QBNO	SMALLINT
RIGHT_HAND_SIDE	VARCHAR(128)
RIGHT_HAND_PNO	INTEGER
PHS_TABNO	SMALLINT
RHS_QBNO	SMALLINT
FILTER_FACTOR	FLOAT
BOOLEAN_TERM	CHAR(1)
SEARCHARG	CHAR(1)
JOIN	CHAR(1)
AFTER_JOIN	CHAR(1)
ADDED_PRED	CHAR(1)
REDUNDANT_PRED	CHAR(1)
DIRECT_ACCESS	CHAR(1)
KEYFIELD	CHAR(1)
EXPLAIN_TIME	TIMESTAMP
CATEGORY	SMALLINT
CATEGORY_B	SMALLINT
TEXT	VARCHAR(2000
PRED_ENCODE	CHAR(1)
PRED_CCSID	SMALLINT
PRED_MCCSID	SMALLINT
MARKET	CHAR(1)
PARENT_PNO	INTEGER
NEGATION	CHAR(1)
LITERALS	VARHAR(128)
CLAUSE	CHAR(8)
GROUP_MEMBER	VARCHAR(24)
ORIGIN	CHAR(1)
UNCERTAINTY	FLOAT(4)
SECTNOI	INTEGER
COLLID	VARCHAR(128)
VERSION	VARCHAR(122)

SYSIBM.SYSQUERYSEL

Information about predicates identified for extended optimization.

QUERYID	BIGINT
QUERYNO	INTEGER
QBLOCKNO	SMALLINT
APPLNAME	VARCHAR(24)
PROGNAME	VARCHAR(128)
PREDNO	INTEGER
INSTANCE	SMALLINT
SELECTIVITY	FLOAT
WEIGHT	FLOAT
ASSUMPTION	VARHCAR(128)
INSERT_TIME	TIMESTAMP
EXPLAIN_TIME	TIMESTAMP

SYSIBM.SYSQUERYOPTS

Optimization parameters for queries in SYSIBM.SYSQUERY.

QUERYID	BIGINT
COPYID	SMALLINT
REOPT	CHAR(1)
STARJOIN	CHAR(1)
MAX_PAR_DEGREE	INTEGER
DEF_CURR_DEGREE	CHAR(3)
SJTABLES	INTEGER
GROUP_MEMBER	VARCHAR(24)
IBMREQD	CHAR(1)

SYSIBM.SYSVIEWDEP

Records the dependencies of view on tables, functions, and other views.

BNAME	VARCHAR(128)
BCREATOR	VARCHAR(128)
BTYPE	CHAR(1)
DNAME	VARCHAR(128)
DCREATOR	VARCHAR(128)
IBMREQD	CHAR(1)
BSCHEMA	VARCHAR(128)
DTYPE	CHAR(1)
DOWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSVIEWS

One or more row for each view.

NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
CHECK	CHAR(1)
IBMREQD	CHAR(1)
PATHSCHEMAS	VARCHAR(2048)
RELCREATED	CHAR(1)
TYPE	CHAR(1)
REFRESH	CHAR(1)
ENABLE	CHAR(1)
MAINTENANCE	CHAR(1)
REFRESH_TIME	TIMESTAMP
ISOLATION	CHAR(1)
SIGNATURE	VARCHAR(1024)
APP_ENCODING_CCSID	INTEGER
OWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)
ENVID	INTEGER
ROWID	ROWID
STATEMENT	CLOB(2M)

SYSIBM.SYSXMLTYPMOD

Rows about the XML type modifiers of XML columns.

XML_TYPEMOD_ID	INTEGER
TYPE_ANNOTATION	CHAR(1)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)
CREATEDBY	VARCHAR(128)

SYSIBM.SYSXMLTYPMSCHEMA

XML schema information for an XML type modifier.

XML_TYPEMOD_ID	INTEGER
XSROBJECTID	INTEGER
ELEMENT_NAMESPACE	INTEGER
ELEMENT_NAME	INTEGER
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)

SYSIBM.SYSXMLRELS

One row for each XML table that is created for an XML column.

XML_TYPEMOD_ID	INTEGER
XSROBJECTID	INTEGER
ELEMENT_NAMESPACE	INTEGER
ELEMENT_NAME	INTEGER
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)

SYSIBM.SYSXMLSTRINGS

A single string and its unique ID that are used to condense XML data.

STRINGID	INTEGER
STRING	VARCHAR(1000)
IBMREQD	CHAR(1)

SYSIBM.SYSCOPY

Contains information needed for recovery.

DBNAME	CHAR(8)
TSNAME	CHAR(8)
DSNUM	INTEGER
ICTYPE	CHAR(1)
START_RBA	CHAR(10)
FILESEQNO	INTEGER
DEVTYPE	CHAR(8)
IBMREQD	CHAR(1)
DSNAME	CHAR(44)
SHRLEVEL	CHAR(1)
DSVOLSER	VARCHAR(1784)
TIMESTAMP	TIMESTAMP
ICBACKUP	CHAR(2)
ICUNIT	CHAR(1)
STYPE	CHAR(1)
PIT_RBA	CHAR(10)
GROUP_NAME	CHAR(8)
OTYPE	CHAR(1)
LOWDSNUM	INTEGER
HIGHDSNUM	INTEGER
COPYPAGESF	FLOAT(8)
NPAGESF	FLOAT(8)
CPAGESF	FLOAT(8)
JOBNAME	CHAR(8)
AUTHID	CHAR(8)
OLDEST_VERSION	SMALLINT
LOGICAL_PART	INTEGER
LOGGED	CHAR(1)
TTYPE	CHAR(8)
INSTANCE	SMALLINT
RELCREATED	CHAR(1)
MODECREATED	CHAR(2)

SYSIBM.SYSCONTROLS

One row for each row permission and column mask.

SCHEMA	VARCHAR(128)
NAME	VARCHAR(128)
OWNER	VARCHAR(128)
OWNERTYPE	CHAR(1)
TBSCHEMA	VARCHAR(128)
TBNAME	VARCHAR(128)
TBCORRELATION	VARCHAR(128)
COLNAME	VARCHAR(128)
COLNO	SMALLINT
CONTROL_ID	INTEGER
CONTROL_TYPE	CHAR(1)
ENFORCED	CHAR(1)
IMPLICIT	CHAR(1)
ENABLE	CHAR(1)
STATUS	CHAR(1)
CREATEDTS	TIMESTAMP
RELCREATED	CHAR(1)
ALTEREDTS	TIMESTAMP
REMARKS	VARCHAR(762)
IBMREQD	CHAR(1)
ENVID	INTEGER
ROWID	ROWID
RULETEXT	CLOB(2M)
DESCRIPTOR	BLOB(2M)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)
REGENERATET	TIMESTAMP(12)

SYSIBM.SYSSTOGROUP

One row for each storage group.

NAME	VARCHAR(128)
CREATOR	VARCHAR(128)
VCATNAME	VARCHAR(128)
SPACE	INTEGER
IBMREQD	CHAR(1)
CREATEDBY	VARCHAR(128)
STATSTIME	TIMESTAMP
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
SPACEF	FLOAT
DATACLAS	VARCHAR(24)
MGMTCLAS	VARCHAR(24)
STORCLAS	VARCHAR(24)
CREATORTYPE	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSVOLUMES

One row for each volume of each storage group.

SGNAME	VARCHAR(128)
SGCREATOR	VARCHAR(128)
VOLID	VARCHAR(18)
IBMREQD	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSUSERAUTH

Records the system privileges that are held by users.

GRANTOR	VARCHAR(128)
GRANTEE	VARCHAR(128)
AUTHHOWGOT	CHAR(1)
BINDADDAUTH	CHAR(1)
BSDSAUTH	CHAR(1)
CREATEDBAAUTH	CHAR(1)
CREATEDBCAUTH	CHAR(1)
CREATESGAUTH	CHAR(1)
DISPLAYAUTH	CHAR(1)
RECOVERAUTH	CHAR(1)
STOPALLAUTH	CHAR(1)
STOSPACEAUTH	CHAR(1)
SYSADMAUTH	CHAR(1)
SYSOPRAUTH	CHAR(1)
TRACEAUTH	CHAR(1)
IBMREQD	CHAR(1)
MON1AUTH	CHAR(1)
MON2AUTH	CHAR(1)
CREATEALIASAUTH	CHAR(1)
SYSCTRLAUTH	CHAR(1)
BINDAGENTAUTH	CHAR(1)
ARCHIVEAUTH	CHAR(1)
GRANTEDTS	TIMESTAMP
CREATETMTABAUTH	CHAR(1)
GRANTEETYPE	CHAR(1)
GRANTORTYPE	CHAR(1)
DEBUGSESSIONAUTH	CHAR(1)
EXPLAINAUTH	CHAR(1)
SQLADMAUTH	CHAR(1)
SBBADMAUTH	CHAR(1)
DATAACCESSAUTH	CHAR(1)
ACCESSCTRLAUTH	CHAR(1)
CREATESECUREAUTH	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSCHECKS

One row for each table check constraint.

TBOWNER	VARCHAR(128)
CREATOR	VARCHAR(128)
DBID	SMALLINT
OBID	SMALLINT
TIMESTAMP	TIMESTAMP
RBA	CHAR(10)
IBMREQD	CHAR(1)
TBNAME	VARCHAR(128)
CHECKNAME	VARCHAR(128)
CHECKCONDITION	VARCHAR(7400)
RELCREATED	CHAR(1)
ENVID	INTEGER
PERIOD	CHAR(1)

SYSIBM.SYSCHECKS2

One row for each table check constraint.

TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
CHECKNAME	VARCHAR(128)
PATHSCHEMA	VARCHAR(2048)
IBMREQD	CHAR(1)
RELCREATED	CHAR(1)

SYSIBM.SYSCHECKDEP

One row for each column in a table check constraint.

TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
CHECKNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
IBMREQD	CHAR(1)

SYSIBM.SYSDYNQRY

Stabalized access path for dynamic SQL.

SDQ_STMT_ID	BIGINT
STBLGRP	VARCHAR(128)
COPYID	SMALLINT
CURSQLID	VARCHAR(128)
CURSCHEMA	VARCHAR(128)
CURAPPLCOMPAT	VARCHAR(10)
QUERY_HASH	CHAR(16)
QUERY_HASH_VERSION	INTEGER
VALID	CHAR(1)
LASTUSED	DATE
RELBOUND	CHAR(1)
GROUP_MEMBER	VARCHAR(24)
STBLTIME	TIMESTAMP
ROWID	ROWID
STMTTEXT	CLOB(2M)
FUNCTION_LVL	VARCHAR(10)

SYSIBM.SYSDYNQRYDEP

Dependencies for dynamic query packages.

SDQ_STMT_ID	BIGINT
COPYID	SMALLINT
BQUALIFIER	VARCHAR(128)
BNAME	VARCHAR(128)
BTYPE	CHAR(1)
CLASS	CHAR(1)
BAUTH	SMALLINT
AUTHID_TYPE	CHAR(1)
AUTHID	VARCHAR(128)
DBNAME	VARCHAR(128)
BADMINAUTH	VARCHAR(128)
PUBLICAUTH	CHAR(1)
ALLOBJAUTH	CHAR(1)
QUERYHASH	BINARY(16)

SYSIBM.SYSSESSION_EX

Global variable data of LOB or array type.

TOKEN	CHAR(40)
LOCATOR	CHAR(8)
HEADER	CHAR(89)
GVID	CHAR(8)
DATATYPE	CHAR(2)
CSSID	CHAR(2)
GVSCHEMA	VARCHAR(130)
GVNAME	VARCHAR(130)
DATA	BLOB(2G)

SYSIBM.SYSLEVELUPDATES

Function, catalog and code levels of subsystem.

FUNCTION_LVL	VARCHAR(10)
PREV_FUNCTION_LVL	VARCHAR(10)
HIGH_FUNCTION_LVL	VARCHAR(10)
CATALOG_LVL	VARCHAR(10)
EFFECTIVE_TIME	TIMESTAMP(12)
EFFECTIVE_LRSN	VARCHAR(12)
OPERATION_TEXT	VARCHAR(256)
GROUP_MEMBER	VARCHAR(24)

SYSIBM.SYSINDEXCONTROL

Control use of memory for an index.

SSID	CHAR(4)
PARTITION	SMALLINT
IXNAME	VARCHAR(128)
IXCREATOR	VARCHAR(128)
TYPE	CHAR(1)
ACTION	CHAR(1)
MONTH_WEEK	CHAR(1)
MONTH	SMALLINT
DAY	SMALLINT
FROM_TIME	TIME
TO_TIME	TIME

SYSIBM.SYSSESSION

Session token and data.

TOKEN	CHAR(40)
CORRTKN	VARCHAR(256)
GV_FLAGS	CHAR(2)
TOTAL	CHAR(4)
SPECIAL_REGISTERS	VARCHAR(16000
GLOBAL_VARIABLES	BLOB(2G)
ROWID	ROWID

SYSIBM.SYSSESSION_STATUS

Session token of last reference.

TOKEN	CHAR(40)
TOKEN_TS	CHAR(16)
TOKEN_MEMBER	CHAR(16)
STATUS	CHAR(2)

SYSIBM.SYSCONTEXT

One row for each trusted context.

NAME	VARCHAR(128)
CONTEXTID	INTEGER
DEFINER	VARCHAR(128)
DEFINERTYPE	CHAR(1)
SYSTEMAUTHID	VARCHAR(128)
DEFAULTROLE	VARCHAR(128)
OBEJECTOWNERTYPE	CHAR(1)
CREATEDTS	TIMESTAMP
ALTEREDTS	TIMESTAMP
ENABLED	CHAR(1)
ALLOWPUBLIC	CHAR(1)
AUTHENTICATEPUBLIC	CHAR(1)
RELCREATED	CHAR(1)
IBMREQD	CHAR(1)
REMARKS	VARCHAR(762)
DEFAULT_SECURITYLABEL	VARCHAR(24)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSCONTEXTAUTHIDS

One row for each auth ID that can use the trusted context.

CONTEXTID	INTEGER
AUTHID	VARCHAR(128)
AUTHENTICATE	CHAR(1)
ROLE	VARCHAR(128)
CREATEDTS	TIMESTAMP
IBMREQD	CHAR(1)
SECURITYLABEL	VARCHAR(24)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSCTXTTRUSTATTRS

One row for each list of attributes for a given trusted context.

CONTEXTID	INTEGER
NAME	VARCHAR(128)
VALUE	VARCHAR(254)
CREATEDTS	TIMESTAMP
IBMREQD	CHAR(1)
SYS_START	TIMESTAMP(12)
SYS_END	TIMESTAMP(12)
TRANS_START	TIMESTAMP(12)

SYSIBM.SYSTABSTATS

One row for each partition of a partitioned tablespace.

CARD	INTEGER
NPAGES	INTEGER
PCTPAGES	SMALLINT
NACTIVE	INTEGER
PCTROWCOMP	SMALLINT
STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
DBNAME	VARCHAR(24)
TSNAME	VARCHAR(24)
PARTITION	SMALLINT
OWNER	VARCHAR(128)
NAME	VARCHAR(128)
CARDF	FLOAT

SYSIBM.SYSKEYTGTDIST

One or more rows for first key-target of extended index key.

STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
IXSCHEMA	VARCHAR(128)
IXNAME	VARCHAR(128)
KEYSEQ	SMALLINT
KEYVALUE	VARCHAR(2000)
TYPE	CHAR(1)
CARDF	FLOAT
KEYGROUPKEYNO	VARCHAR(254)
NUMKEYS	SMALLINT
FREQUENCYF	FLOAT
QUANTILENO	SMALLINT
LOWVALUE	VARCHAR(2000)
HIGHVALUE	VARCHAR(2000)

SYSIBM.SYSINDEXSTATS

One row for each partition of a partitioning index or DPSI.

FIRSTKEYCARD	INTEGER
FULLKEYCARD	INTEGER
NLEAF	INTEGER
NLEVELS	SMALLINT
CLUSTERRATIO	SMALLINT
STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
PARTITION	SMALLINT
OWNER	VARCHAR(128)
NAME	VARCHAR(128)
KEYCOUNT	INTEGER
FIRSTKEYCARDF	FLOAT
FULLKEYCARDF	FLOAT
KEYCOUNTF	FLOAT
CLUSTERRATIOF	FLOAT
DATAREPEATFACTORF	FLOAT

SYSIBM.SYSCOLDISTSTATS

Zero or more rows per partition for statistics for a single column or column group.

STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
PARTITION	SMALLINT
TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
NAME	VARCHAR(128)
COLVALUE	VARCHAR(2000)
TYPE	CHAR(1)
CARDF	FLOAT
COLGROUPCOLNO	VARCHAR(254)
NUMCOLUMNS	SMALLINT
FREQUENCYF	FLOAT
QUANTILENO	SMALLINT
LOWVALUE	VARCHAR(2000)
HIGHVALUE	VARCHAR(2000)

SYSIBM.SYSKEYTARGETSTATS

Partition statistics for selected key-targets.

IXSCHEMA	VARCHAR(128)
IXNAME	VARCHAR(128)
KEYSEQ	SMALLINT
HIGHKEY	VARCHAR(2000)
HIGH2KEY	VARCHAR(2000)
LOWKEY	VARCHAR(2000)
LOW2KEY	VARCHAR(2000)
PARTITION	SMALLINT
STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
STATS_FORMAT	FLOAT
CARDF	FLOAT

SYSIBM.SYSSTATFEEDBACK

Information about missing or conflicting statistics.

TBCREATOR	VARCHAR(128)
TBNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
IXNAME	VARCHAR(128)
COLNAME	VARCHAR(128)
NUMCOLUMN	SMALLINT
COLGROUPCOLNO	VARCHAR(254)
TYPE	CHAR(1)
DBNAME	VARCHAR(24)
TSNAME	VARCHAR(24)
REASON	CHAR(8)
BLOCK_RUNSTATS	CHAR(1)
REMARKS	VARCHAR(254)
LASTDATE	DATE

SYSIBM.SYSLOBSTATS

One row for each LOB table space.

STATSTIME	TIMESTAMP
AVGSIZE	INTEGER
FREESPACE	INTEGER
ORGRATIO	DECIMAL(5,2)
DBNAME	VARCHAR(24)
NAME	VARCHAR(24)
IBMREQD	CHAR(1)

SYSIBM.SYSKEYTGTDISTSTATS

Zero or more rows for first key-target of a DPSI.

STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
PARTITION	SMALLINT
IXSCHEMA	VARCHAR(128)
IXNAME	VARCHAR(128)
KEYSEQ	SMALLINT
KEYVALUE	VARCHAR(2000)
TYPE	CHAR(1)
CARDF	FLOAT
KEYGROUPKEYNO	VARCHAR(254)
NUMKEYS	SMALLINT
FREQUENCYF	FLOAT
QUANTILENO	SMALLINT
LOWVALUE	VARCHAR(2000)
HIGHVALUE	VARCHAR(2000)

SYSIBM.SYSCOLDIST

One or more rows for statistics for a single column or column group.

STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
COLVALUE	VARCHAR(2000)
TYPE	CHAR(1)
CARDF	FLOAT
COLGROUPCOLNO	VARCHAR(254)
NUMCOLUMNS	SMALLINT
FREQUENCYF	FLOAT
QUANTILENO	SMALLINT
LOWVALUE	VARCHAR(2000)
HIGHVALUE	VARCHAR(2000)

SYSIBM.SYSCOLSTATS

Partition statistics for selected columns.

HIGHKEY	VARCHAR(2000)
HIGH2KEY	VARCHAR(2000)
LOWKEY	VARCHAR(2000)
LOW2KEY	VARCHAR(2000)
COLCARD	INTEGER
STATSTIME	TIMESTAMP
IBMREQD	CHAR(1)
PARTITION	SMALLINT
TBOWNER	VARCHAR(128)
TBNAME	VARCHAR(128)
NAME	VARCHAR(128)
COLCARDDATA	VARCHAR(1000)
STATSFORMAT	CHAR(1)