JR37562: INCORRECT VALUES WRITTEN TO THE DATABASE FOR DATASTAGE FIELDS OF BIGINT DATA TYPE

APAR status

• Closed as program error.

Error description

• There is corruption of data values mapped to a BigInt column on
  the input link of Oracle Connector stage. The values inserted in
  the NUMBER column in the database do not match the values
  provided to the stage on the input link. If Decimal data type is
  used for the column on the link, the values are inserted
  correctly.
  
  If the Record count property value on the connector stage is set
  to 1 then the discrepancies between using a
  BigInt column and a Decimal column in the link to insert data to
  the NUMBER column become even more prevalent.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DataStage users who are using Oracle Connector stage in their
  jobs to write data to Oracle database.
  ****************************************************************
  PROBLEM DESCRIPTION:
  DataStage parallel job uses Oracle Connector stage to insert
  data to a NUMBER column in the Oracle table. The column on the
  link is defined as BigInt column. The job completes successfully
  but some values are inserted to the table incorrectly.
  
  Decreasing the value for Record count property (which may in
  turn the Array size property value) results in more values being
  inserted incorrectly.
  
  ****************************************************************
  RECOMMENDATION:
  Install patch JR37562.
  ****************************************************************
  

Problem conclusion

• A bug was corrected in the connector in regard to handling bind
  array buffers for DataStage fields represented by the BigInt
  DataStage type. The connector was not managing value lengths
  correctly for reused bind buffers which resulted in incorrect
  lengths specification for some values which in turn resulted in
  incorrect values inserted into the database. With smaller Record
  count the number of buffer reuses for inserted values was
  greater which resulted in higher probability for inserting
  values with incorrect lengths to the database.
  

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

• R810 PSN

     UP