Object documentationSYSUPGRADEHISTORY Locate this document in the navigation structure

 

The system table <DATENBANKSYSTEMADMINISTRATOR>.SYSUPGRADEHISTORY indicates when and with which version of the database software an implicit upgrade had to be performed on a certain component; or when the system tables were successfully loaded and with which system table version the load was executed.

Structure

SYSUPGRADEHISTORY

KERNELVERSION

CHAR(40)

Version of the database software

EXECUTEDATE

TIMESTAMP

Time at which the implicit upgrade or the loading of the system tables occurred.

COMPONENT

CHAR(18)

Part of the database kernel for which the implicit upgrade was executed (e.g. CATALOG, CONVERTER, LOGGING)

DESCRIPTION

CHAR(2000)

Additional information about the upgrade or the version of the scripts used for loading the system tables

More Information

Glossary, Upgrade