Introduction
Installation and Upgrade
Emergency Bug Fixes Merged into MDM 10.5 HotFix 3
10.5 HotFix 3 Fixed Limitations
- Data Director with Business Entities Fixed Limitations
10.5 HotFix 3 Known Limitations
- MDM 10.5 HotFix 3 Known Limitations
10.5 HF3 Cumulative Known Limitations
- MDM 10.5 HF3 Cumulative Known Limitations
10.5 HF2 Fixed Limitations
- Data Director with Subject Areas Known Limitations
10.5 HF2 Known Limitations
- MDM 10.5 HF2 Known Limitations
10.5 HF1 Fixed Limitations
- Data Director with Business Entities 10.5 HotFix 1 Fixed Limitations
- MDM Hub 10.5 HF1 Fixed Limitations
10.5 HF1 Known Limitations
- MDM 10.5 HF1 Known Limitations
10.5 Fixed Limitations
10.5 Known Limitations
Informatica Global Customer Support

Release Notes

10.5 HotFix 3

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