Show TOC

Object documentationPOSTUPGRADECHECKLIST Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.POSTUPGRADECHECKLIST describes errors that occurred during an upgrade that required the re-execution of SQL statements (for example while attempting to recreate a view table, a trigger or a database procedure). These errors were ignored during the upgrade.

Structure

POSTUPGRADECHECKLIST

UPGRADETYPE

CHAR(40)

Type of upgrade (ImplicitUpgrade | CatalogToUnicode)

SCHEMANAME

CHAR(32)

Name of the schema to which the object was assigned that could not be recovered

OWNER

CHAR(32)

Name of the owner of the object that could not be recovered

UPGRADEDATE

TIMESTAMP

Time at which the recovery of the object failed

ERRORNUMBER

INTEGER

Error code that occurred during recovery

ERRORPOSITION

INTEGER

Error position in the statement

STATEMENT

CLOB

Text of the failed SQL statement

The system table POSTUPGRADECHECKLIST is only visible for the database system administrator.

Following an upgrade, the existing POSTUPGRADECHECKLIST table is renamed POSTUPGRADECHECKLIST<version> and a new POSTUPGRADECHECKLIST table is generated.

If an upgrade is done for a UNICODE database, the upgrade information is stored in the table POSTUPGRADECHECKLISTUNICODE.

More Information

Glossary, Upgrade