APAR status
Closed as program error.
Error description
When the connector is configured to run in Insert then update write mode, the amount of heap memory consumed by the job process increases as the number of rows written to the database is increasing.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: DataStage users who are utilizing Oracle Connector stage to insert and update rows to the Oracle database **************************************************************** PROBLEM DESCRIPTION: Oracle Connector stage is used in Insert then update write mode. As the number of records on the input link of the stage increases, the amount of the allocated memory on the heap increases as well. For a large number of records the memory leak results in an error once the job process has run out of all available memory. **************************************************************** RECOMMENDATION: Install patch JR38234. ****************************************************************
Problem conclusion
The connector code was fixed to free temporary Oracle OCI error handles which the stage was allocating while inspecting error codes associated with the rows that could not be written to the database.
Temporary fix
Comments
APAR Information
APAR number
JR38234
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-10
Closed date
2010-11-29
Last modified date
2010-11-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
29 November 2010