Flashes (Alerts)
Abstract
IBM has determined that the Oracle Connector is sometimes corrupting Timestamp data when Extended attribute is set to Microseconds.
Content
This corruption issue only occurs if all of the conditions below are true:
- Oracle Connector stage configured with multiple SQL statements. For example, Insert and Update mode.
- Array size must be greater than 1.
- Timestamp column must have Extended attribute set to Microseconds in the DataStage columns grid.
- Both SQL statements are used while the job is running. For example, If the stage is using Insert then Update, but only Insert is used then the issue will not be encountered.
Prior to the fix for this issue, the Oracle Connector stage was not aligning its internal timestamp buffers correctly for the above configuration.
Applying the solution
The fix for this issue is included in APAR JR44206. The patches below include this fix even if APAR JR44206 is not included in the name. The patches are cumulative. Download and install the following fix based on your version of InfoSphere Information Server. See the links in this document for the specific fixes.
The README included in each patches contains additional details about the fix and instructions for applying the patch.
If you are unable to apply these patches, open a new service request for InfoSphere Information Server.
InfoSphere Information Server, Version 8.1
Install the patch for InfoSphere Information Server, Version 8.1.
InfoSphere Information Server, Version 8.5
Install the patch for InfoSphere Information Server, Version 8.5.
InfoSphere Information Server, Version 8.7
Install the patch for InfoSphere Information Server, Version 8.7.
InfoSphere Information Server, Version 9.1
Install the patch for InfoSphere Information Server, Version 9.1.
Was this topic helpful?
Document Information
More support for:
IBM InfoSphere Information Server
Software version:
9.1, 8.7.0.1, 8.7, 8.5.0.3, 8.5.0.2, 8.5.0.1, 8.5, 8.1.0.2, 8.1.0.1
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
221059
Modified date:
25 September 2022
UID
swg21626884