POSTUPGRADECHECKLIST

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