POSTUPGRADECHECKLIST 
Definition
The system table 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 |
LONG |
Text of the failed SQL statement |
The system table POSTUPGRADECHECKLIST is only visible for the database system administrator.
Following an upgrade, the existing table POSTUPGRADECHECKLIST in POSTUPGRADECHECKLIST<version> is renamed and a new table POSTUPGRADECHECKLIST generated.
If an upgrade is done for a UNICODE database instance, the upgrade information is stored in the table POSTUPGRADECHECKLISTUNICODE.
See also: