Table of Contents

Search

  1. Abstract
  2. Installation and Upgrade
  3. 10.4 Fixed Limitations
  4. 10.4 Closed Enhancement Requests
  5. 10.4 Known Limitations
  6. Cumulative Known Limitations

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.
  1. 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'
(MDM-31443)

0 COMMENTS

We’d like to hear from you!