JR62565: DB2 CONNECTOR EXTERNAL TABLE STATEMENT FAILS IN CASE OF MISMATCHING COLUMNS

APAR status

• Closed as program error.

Error description

• A DataStage job with DB2 Connector configured to write data
  using external tables aborts because the DB2 Connector reports
  an external table statement error like:
  SQLSTATE = 22551: Native Error Code = -20,570: Msg = [IBM][CLI
  Driver][DB2/LINUXX8664] SQL20570N The statement failed because
  the number of rejected rows exceeds the limit set in the
  MaxErrors option value. Log file name: ".log". SQLSTATE=22551
  The issue occurs when following conditions are met:
  - a mismatch between columns defined in connector configuration
  and columns existing in destination table
  - option 'Drop unmatched columns' is set to 'Yes'
  - option 'Use external tables' is set to 'Yes'
  

Local fix

• Set option 'Use external tables' to 'No'
  

Problem summary

• A DataStage job with DB2 Connector configured to write data
  using external tables aborts because the DB2 Connector reports
  an external table statement error like:
  SQLSTATE = 22551: Native Error Code = -20,570: Msg = [IBM][CLI
  Driver][DB2/LINUXX8664] SQL20570N The statement failed because
  the number of rejected rows exceeds the limit set in the
  MaxErrors option value. Log file name: ".log". SQLSTATE=22551
  The issue occurs when following conditions are met:
  - a mismatch between columns defined in connector configuration
  and columns existing in destination table
  - option 'Drop unmatched columns' is set to 'Yes'
  - option 'Use external tables' is set to 'Yes'
  

Problem conclusion

• Due to 'Drop unmatched columns' option, not matching column is
  removed from the column names list in ET-related statement but
  its value is not removed from ET file prepared for load. This
  causes the failure of statement unloading data from External
  Table and aborting the job.
  

Temporary fix

• Set option 'Use external tables' to 'No'
  

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

• RB71 PSY

     UP