JR34474: GOT MAJOR FATAL ERROR PROBLEM WITH DB2 UPSERT OR DELETE OPTION OF DB2 ENTERPRISE STAGE. HOWEVER THE JOB COMPLETE SUCCESSFUL.

APAR status

• Closed as program error.

Error description

• DS 7.5.1A on AIX 5.3
  
  The DB2 EE stage job generated following fatal error but it
  finished running successfully.
  
  Item #: 147
     Event ID: 146
     Timestamp: 2009-09-21 12:21:09
     Type: Fatal
     User Name: etldstge
     Message: SYLVAIN_TEST,1: Error in row #3 [db2Upsert.C:1974]
  Primary Error: [db2Upsert.C:1976]
  sqlcode=-407, state=23502, message=[IBM][CLI Driver][DB2/AIX64]
  SQL0407N  Assignment of a NULL value to a NOT NULL column
  "TBSPACEID=278, TABLEID=12, COLNO=4" is not allowed.
  SQLSTATE=23502
   [db2Upsert.C:2329]
  Secondary Error: [db2Upsert.C:1979]
  sqlcode=100, state=02000, message=[IBM][CLI Driver][DB2/AIX64]
  SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the
  result of a query is an empty table.  SQLSTATE=02000
  
  We can workaround the problem by setting envirnomental
  variable APT_DB2UPSERT_HIDE_REJECT_MESSAGES to 1
  
  However, the customer asked if there is a
  PATCH that correct the problem permantently without use the
  variable.
  

Local fix

• We can workaround the problem by setting envirnomental
  variable APT_DB2UPSERT_HIDE_REJECT_MESSAGES to 1
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DataStage 751 on AIX, DB2-upsert
  ****************************************************************
  PROBLEM DESCRIPTION:
  fatal error problem with DB2 UPSERT or DELETE option of DB2
  Enterprise stage.
  ****************************************************************
  RECOMMENDATION:
  Install the patch: JR34474_aix_DS751.tar.Z
  ****************************************************************
  

Problem conclusion

• Fxied, back ported the code from upper brach to 751
  

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

• R751 PSN

     UP