SYSLEVELUPDATES catalog table

The SYSLEVELUPDATES table contains information about the catalog level and function level of the Db2 subsystem or data sharing group. The schema is SYSIBM.

Column name Data type Description Use
FUNCTION_LVL VARCHAR(10) Function level in effect when this record was inserted. G
PREV_FUNCTION_LVL VARCHAR(10) Previous function level. G
HIGH_FUNCTION_LVL VARCHAR(10) Highest activated function level. G
CATALOG_LVL VARCHAR(10) The catalog level. G
OPERATION_TYPE CHAR(1) Type of operation:
'C'
Catalog level change.
'F'
Function level change.
'M'
Code level change.
G
EFFECTIVE_TIME TIMESTAMP(12) Time when the operation completed. G
EFFECTIVE_LRSN   RBA (or LRSN for data sharing) depicting the time that an operation completed. G
OPERATION_TEXT VARCHAR(256) The text of the operation. G
GROUP_MEMBER VARCHAR(24) Name of the group member on which the operation was run. G