JR49502: ODBC CONNECTOR BULKLOAD JOBS ISSUE NORMAL INSERT STATEMENT EVEN WHEN BULKLOAD IS ENABLED

APAR status

• Closed as Vendor Solution.

Error description

• ODBC Connector bulkload jobs issue normal insert statements even
  when Bulkload is enabled. This is due to the DataDirect driver
  turning off the bulkload mode when insert array size is set to
  1. This causes problems while loading data to identity columns
  (inserts to identity columns is not allowed and will be ignored
  by the Database in Bulkload mode).
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Description:
  
  ODBC Connector bulkload jobs issue normal insert statements even
  when Bulkload is enabled. This is due to the DataDirect driver
  turning off the bulkload mode when insert array size is set to
  1. This causes problems while loading data to identity columns
  (inserts to identity columns is not allowed and will be ignored
  by the Database in Bulkload mode).
  
  Resolution:
  DataDirect fixed the issue that the bulkload would not be turned
  off when the arraysize is set to 1 and would always do bulk
  inserts when the "Enable Bulk Load" option is selected for the
  driver. To get this behaviour a new option called
  "BulkLoadThreshold" was introduced and so when "Enable bulk
  load" option is selected it is advised to select
  "BulkLoadThreshold" as 1.
  

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