JR35554: JOB CONTAINING ODBC ENTERPRISE STAGE ABORTS WITH HEAP ALLOCATIONFAILURE AFTER APPLYING FIX PACK 1 FOR INFORMATION SERVER 8.1

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

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 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