JR38582: DB2 CONNECTOR JOB USING WRITE MODE AS "USER DEFINED SQL" ABORTING WHEN A DB2 WARNING IS ENCOUNTERED

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• Db2 connector job using Write mode as "User defined SQL" aborts
  when a DB2 warning is encountered with property of "Fail on
  Error" is set to 'YES'.
  

Local fix

• Work around is to set the DB2 Connector property "Fail on error
  = NO" in the Before/After SQL.
  

Problem summary

• Problem Summary:
  DB2 Connector job using Write mode as "User defined SQL"
  aborting when a DB2 Warning is encountered.
  
  Problem Description:
  DB2 connector job using Write mode as "User defined SQL" aborts
  when a DB2 warning is encountered and Fail on Error =
  YES.Setting Fail on Error = NO, is not a viable solution as it
  may ignore valid errors also.
  

Problem conclusion

• The Fail on Error property now has the following values:
  - 'Yes' is now called 'Fail on errors and warnings'
  - 'No' is now called 'Ignore errors and warnings'
  - The new value is 'Fail on errors only, ignore warnings'
  
  To ignore warnings but not errors:
  Set the Fail on Error property to 'Fail on errors only, ignore
  warnings'
  

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

• R850 PSY

     UP