A fix is available
APAR status
Closed as requirement.
Error description
Customer has a large number of jobs using the ODBC Enterprise stage as a target writing to SQL Server. They are using the upsert write mode, insert only method, and the stage has a reject link. The Array Size property is set to a large positive integer. These jobs ran to completion successfully at the base release of 8.1. After the customer applied Fix Pack 1, some of the jobs are now aborting with a heap allocation failure message in the ODBC Enterprise stage.
Local fix
The issue can be solved by reducing the array size. If the customer requires a high commit interval, they can set array size to one, and then set the Row Commit Interval to a large positive integer value as required.
Problem summary
**************************************************************** USERS AFFECTED: All platforms, jobs using ODBC upsert with reject link and very large insert array size **************************************************************** PROBLEM DESCRIPTION: ODBCupsert jobs with insert only and reject link fails with Heap allocation error **************************************************************** RECOMMENDATION: Install patch for JR35554 ****************************************************************
Problem conclusion
There has been a change in the way reject link logic is processed for insert only. The memory requirement is more , hence for very large insertArraySize values, the job fails with heap allocation error. Added env APT_ODBC_NO_ROWSTATUS_ARRAY. When this env variable is set to 1, the reject link logic for insert only will revert to using insertArraySize=1.
Temporary fix
Comments
New env var APT_ODBC_NO_ROWSTATUS_ARRAY added
APAR Information
APAR number
JR35554
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED REQ
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-04
Closed date
2010-02-15
Last modified date
2010-02-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ODBCEE
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021