PH58060: ABEND04E RC00E70005 DSNXEPM M450 FOR THE QUERY INVOLVING TRIGGER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXEPM M450 MAY OCCUR FOR THE QUERY
  INVOLVING A TRIGGER. It can happen when CREATE TRIGGER statement
  is rolled back.
  
  KEYWORDS: SQLTRIGGER
  

Local fix

• BYPASS/CIRCUMVENTION:
  N/A
  
  RECOVERY ACTION:
  rerun the query
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 v12 and v13 for z/OS users of                        *
  * CREATE TRIGGER running concurrently                          *
  * with DML on the same table.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 might issue ABEND04E with                                *
  * RC00E70005 IN DSNXEPM:M450 on an                             *
  * INSERT into a table that is the                              *
  * subject of a concurrent CREATE                               *
  * TRIGGER statement.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When the user attempts to insert data into a table, where
  there is a trigger being created on the same table
  concurrently, due to missing serialization, the INSERT
  statement might receive ABEND04E with RC00E70005 IN
  DSNXEPM:M450, or SQLCODE723.
  Sample SQLCODE723 messages:
   DSNT408I SQLCODE = -723, ERROR:  AN ERROR OCCURRED IN
            A TRIGGERED SQL STATEMENT IN TRIGGER SYSADM.TRG1.
            INFORMATION
            RETURNED: SQLCODE -805,
            SQLSTATE 51002, MESSAGE TOKENS
            STLEC1.SYSADM.TRG1.1BD4E0BD0130A0FD,DSNTEP3,02,
            SECTION NUMBER
   DSNT418I SQLSTATE   = 09000 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -450  0  0  -1  0  0 SQL DIAGNOSTIC
                         INFORMATION
   DSNT416I SQLERRD    = X'FFFFFE3E'  X'00000000'  X'00000000'
            X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
            INFORMATION
  TEP3I55   RETCODE=   8
  

Problem conclusion

• Db2 code has been fixed. When creating a trigger on the table,
  Db2 gets an S-lock on the table if the containing table space
  is non-partitioned, or drains the writer on the table space if
  the containing table space is partitioned in order to
  serialize properly with concurrent DMLs on the same table.
  ADDITIONAL KEYWORDS:
  SQLCREATE
  SQLINSERT
  SQLDYNSTMTCACHE
  SQLTRIGGER
  ABEND04E
  SQLCODE723
  RC00E70005
  

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:

  UI96316 UI96317

Modules/Macros

• DSNGDBTG
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI96316

     UP24/04/06 P F404

• RD10 PSY UI96317

     UP24/04/06 P F404

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.