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.
|
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.
Glossary, Upgrade