PM33495: SQLCODE723 SQLCODE904 RC00E30305 DSNXEAAL ON UPDATE STATEMENT THAT INVOKES A TRIGGER CREATED ON DB2 10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE723 SQLCODE904 RC00E30305 DSNXEAAL on UPDATE statement
  that invokes a TRIGGER created on DB2 10
  

Local fix

• Drop and recreate trigger on DB2 9 ( V9 ).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of DB2 triggers     *
  *                 created on DB2 10 for z/OS.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -723 may occur on an INSERT,    *
  *                      UPDATE, DELETE statement running on     *
  *                      DB2 9 for z/OS and fires a DB2          *
  *                      trigger created on DB2 10 for z/OS.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When an INSERT, UPDATE, or DELETE statement was run on DB2 9
  for z/OS member and fired a DB2 trigger that was created on
  DB2 10 for z/OS, SQLCODE -723 or SQLCODE -904 occurred. This
  could occur on DB2 9 after fallback from DB2 10 or when
  running in Data Sharing coexistence mode where there is a mix
  of DB2 9 members and DB2 10 members. Other unexpected results
  may occur.
  

Problem conclusion

• DB2 10 for z/OS code has been modified to CREATE DB2 10
  triggers that are runnable and usable after fallback to DB2
  9 or when in Data Sharing coexistence mode (as described above).
                                                              .
  PM33495 does *not* fix triggers created in DB2 10 prior to
  applying this apar. To correct this problem for those affected
  DB2 10 triggers, those triggers must be dropped and recreated,
  either on DB2 9 or, after applying this apar, on DB2 10.
                                                              .
  A query such as the sample query below may be used to identify
  triggers created in DB2 10 for z/OS:
                                                              .
   SELECT * FROM SYSIBM.SYSTRIGGERS WHERE RELCREATED = 'O';
                                                              .
  ADDITIONAL SEARCH KEYWORDS:
  SQLCODE904
  SQLCODE723
  SQLTRIGGER
  SQLINSERT
  SQLUPDATE
  SQLDELETE
  INCORROUT
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK66317

Modules/Macros

• DSNDTGBI DSNTBTRG DSNXEBPG DSNXISUB DSNXOFN3
  DSNXOOP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK66317

     UP11/04/15 P F104

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.