Validating Operational Reference Stores in IBM Db2 Environments
Validating Operational Reference Stores in IBM Db2 Environments
In an IBM Db2 environment, after you upgrade the Operational Reference Store (ORS) databases, the ORS validation might fail with warnings. The warnings indicate the use of incorrect time stamps instead of current time stamps in the
_PCTL
and
_HPCT
tables.
To correct the time stamps, run the following command:
UPDATE C_REPOS_COLUMN
SET DATA_DEFAULT = 'CURRENT_TIMESTAMP'
WHERE (TABLE_NAME LIKE '%_PCTL' OR TABLE_NAME LIKE '%_HPCT') and DATA_TYPE = 'TIMESTAMP'