JR61117: SQL SERVER ENTERPRISE OPERATOR IN WRITE MODE (BULK LOAD) TO BCP CAUSES HEAP CORRUPTION WHEN PROCESSING DECIMAL DATA.

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• The SQL Server operator incorrectly calculates the size of the
  bind buffer for a DECIMAL column as 1 byte too short. This
  causes the conversion from DECIMAL to BCP format (string) to
  overrun the heap. This subtle heap corruption issue may or may
  not cause a segmentation violation or the fatal message
  Unexpected exit status -1,073,740,940.
  

Local fix

Problem summary

• A decimal value must be converted to a string in order to
  satisfy the BCP Load format. The string length is precision plus
   2. Add 1 is for the leading space or plus or minus sign and 1
  for the decimal separator. The string value is NOT
  null-terminated. The 1st 4 bytes in the buffer represent the
  length of the string. The SQL Server Operator code was modified
  to provide a buffer of precision+2 instead of precision+1.
  

Problem conclusion

• The heap corruption of BCP Load was solved.
  

Temporary fix

Comments

APAR Information

• 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

• RB50 PSY

     UP

• RB70 PSY

     UP

• RB71 PSY

     UP