JR42086: PERFORMANCE IMPROVEMENT IN ODBC EE STAGE IN UPSERT/INSERT ONLY WITH REJECT LINK MODE WHILE USING IBM DB2 NATIVE DRIVER

IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• While using the IBM DB2 Native driver with ODBC EE stage, in
  upsert/insert only with a reject link, the following problems
  are encountered:
  1) Performance is low compared to the same job run using the
  DataDirect DB2 Wire Protocol driver
  2) Duplicate rows are getting inserted when the table doesn't
  have a unique key constraint / warnings are issued
  

Local fix

• N/A
  

Problem summary

• ODBC Enterprise Upsert/Insert only with reject link jobs show
  the following two problems while using IBM DB2 Native driver.
  1) Duplicate rows will get inserted if the table doesn't contain
  unique / primary key constraint
  2) The performance of the upsert/insert only with reject link
  jobs is very slow when compared with the performance of the same
  job using the DataDirect DB2 Wire Protocol driver.
  

Problem conclusion

• Code has been corrected to turn off atomic operations at the DB2
  side when the upsert/insert only with reject jobs use the IBM
  DB2 Native driver.
  

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

• R753 PSY

     UP

• R800 PSY

     UP

• R801 PSY

     UP

• R802 PSY

     UP

• R810 PSY

     UP

• R850 PSY

     UP

• R870 PSY

     UP