SYSUPDSTATLOG

SCHEMANAME

CHAR(32)

Name of the table schema

TABLENAME

CHAR(32)

Name of the table

TABLEID

CHAR(8) BYTE

Internal Identification of the table

PARTITIONID

FIXED(5)

Identification of the partition

COLUMNNAME

CHAR(32)

Name of the column

INDEXNAME

CHAR(32)

Name of the index

EXECUTED_AT

TIMESTAMP

Time of the start of the SQL statement which executes several UPDATE STATISTICS

IMPLICIT

CHAR(3)

No longer used

SAMPLE_PCT

FIXED(3)

Area of the table (in %) which is read for the UPDATE STATISTICS run

SAMPLE_ROW

FIXED(10)

Number of lines in the table which are read for the UPDATE STATISTICS run

EXECUTION_START

TIMESTAMP

Time of the start of the UPDATE STATISTICS run

EXECUTION_END

TIMESTAMP

Time of the end of the UPDATE STATISTICS run

SESSION

FIXED(10)

Identification of the database session

TERMID

CHAR(18)

Identification of the terminal used by the logged-on application

SEQNO

FIXED(5)

No longer used