Introduction
Installation
Before you apply the service pack
- Verify the upgrade paths
- Download the service pack files
Before You Install or Upgrade
Creating or Updating Operational Reference Stores for Specific Locales
IBM Environments
Oracle Environments
- Oracle WebLogic 12.2.1.3
- Run the PostInstallSetup Script in Non-English Oracle and JBoss Environments
JBoss Environments
After You Install or Upgrade
- Upgrading Operational Reference Stores in IBM Db2 Environments
- Validating Operational Reference Stores in IBM Db2 Environments
Emergency Bug Fixes Merged into MDM 10.5 HotFix 2 Service Pack 1

Release Notes

10.5 HotFix 2 SP 1

Back Next

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'

Rename Saved Search

Table of Contents

Release Notes

Release Notes

Validating Operational Reference Stores in IBM Db2 Environments

Validating Operational Reference Stores in IBM Db2 Environments