JR30353: THERE IS AN ERROR ON DB2 INSERT OR UPDATE, WE SET EXIT_STATUS TO4 AFTER CALLING DB-ERROR WHICH SETS EXIT-STATUS TO 16.

APAR status

• Closed as program error.

Error description

• there is an error on DB2 Insert or Update, we set EXIT_STATUS to
  4 after calling DB-ERROR which sets EXIT-STATUS to 16.  This
  causes no Rollback to be done in MAINBODY-EXIT.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 as target stage.
  ****************************************************************
  PROBLEM DESCRIPTION:
  In the DB target stage if update/insert/delete failed the return
  code was reset to 4 causing failure to rollback.
  ****************************************************************
  RECOMMENDATION:
  The new patch will resolve the customer issue and rollback will
  be performed if update failed.
  ****************************************************************
  

Problem conclusion

• Don't reset return code to 4 if the update action is a single
  action (i.e insert only, delete only or update only)
  

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R801 PSN

     UP