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:

Upgrade