SYSOBJEVENTS catalog table

The SYSOBJEVENTS table contains object-level event information for utility executions if collection of utility object-level history is active. The schema is SYSIBM.

FL 504

Rows in this table can be updated, inserted, and deleted by authorized users.

Table 1. SYSIBM.SYSOBJEVENTS table column descriptions
Column name	Data type	Description	Use
EVENTID	BIGINT NOT NULL	The identifier for the utility execution. The value is the same as EVENTID column value in the corresponding SYSUTILITIES row for the utility execution.	G
DBID	SMALLINT NOT NULL	The internal identifier of the database which contains the table space or index space.	G
PSID	SMALLINT NOT NULL	The internal identifier of page set descriptor for the table space or index space.	G
PARTITION	SMALLINT NOT NULL	The physical partition number, a nonzero value, for a partitioned table space or index. Zero for a nonpartitioned table space or index.	G
INSTANCE	SMALLINT NOT NULL WITH DEFAULT 1	Indicates if the object is associated with data set instance 1 or 2.	G
DBNAME	VARCHAR(24) NOT NULL	The name of the database that contains the table space or index space.	G
SPACENAME	VARCHAR(24) NOT NULL	The table space or index space name.	G
OBJTYPE	CHAR(1) NOT NULL	The type of object: T Table space I Index space	G
EVENTTS	TIMESTAMP NULLABLE WITH DEFAULT NULL	Starting timestamp (in local time) of utility processing for the object. NULL when processing has not started. For more information, see Utility object-level history information in SYSOBJEVENTS.	G
COUNT	BIGINT NULLABLE WITH DEFAULT NULL	When COUNT is applicable to the utility and object, NULL indicates processing of the object has not started or is in progress. Count of pages, rows, keys, or LOBs for the physical partition or nonpartitioned object processed by the utility. NULL when COUNT is not applicable to the utility and object. Some utilities do not set a value for this column. For more information, see Utility object-level history information in SYSOBJEVENTS.	G
ELAPSEDTIME	BIGINT NULLABLE WITH DEFAULT NULL	The elapsed time in microseconds for COPY and RECOVER. For COPY utility, the elapsed time to create a sequential image copy(s) for the object. For RECOVER utility, the elapsed time to restore a sequential image copy(s) for the object. The elapsed time for the log processing phases is not included. NULL when the utility is not a COPY or RECOVER that processed a sequential image copy. For more information, see Utility object-level history information in SYSOBJEVENTS.	G
INSERTEDBY	VARCHAR(9) NOT NULL	'DB2' for rows inserted by IBM® Db2 Utilities. This column should be set to an identifiable value for rows inserted by users or programs.	G