JR29248: DB2_UDB_ENTERPRISE_2: DUE TO DB2 DEFECT FOR ARRAY EXECETION IN PDF SYSTEM, COMMITSIZE OPTION IS IGNORED"

APAR status

• Closed as program error.

Error description

• Datastage:  V751A with patch 102853
  DB Server:  DB2 V9
  DB Client:  DB2 V9
  
  Customer recieves following warning message:
  
  DB2_UDB_Enterprise_2: Due to DB2 defect for array execetion in
  PDF
  system, commitsize option is ignored".
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 Enterprise Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Receving following warning in db2upsert job:
  DB2_UDB_Enterprise_2: Due to DB2 defect for array execetion in
  PDF
  system, commitsize option is ignored".
  ****************************************************************
  RECOMMENDATION:
  Apply patch for JR29248
  ****************************************************************
  

Problem conclusion

• The warning message should not return if both -arraysize and
  -rowCommitInterval is not set.
  The condition to return warning message is fixed.
  

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:

Modules/Macros

• DB2
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R751 PSN

     UP