PH41331: ABEND0C4 RC11 DSNXOSL OFFSET074C8 ON A CREATE TRIGGER STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC11 at DSNXOSL OFFSET074C8 on a CREATE TRIGGER
  statement due to an invalid address for an internal pointer .
  Additional keywords: SQLTRIGGER
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of a CREATE                        *
  * TRIGGER(basic) statement containing a                        *
  * SIGNAL or VALUES statement.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND0C4 RC00000011 at the location                          *
  * DSNXGRDS DSNXOSL OFFSET074C8 could                           *
  * happen for a CREATE TRIGGER(basic)                           *
  * statement containing a SIGNAL or                             *
  * VALUES statement.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An example is shown below:
  CREATE TABLE T1(
    C1 INT
  )
  ;
  --#SET TERMINATOR !
  CREATE TRIGGER(basic) TG1
  NO CASCADE BEFORE INSERT ON T1
  REFERENCING NEW AS NEW_ROW
  FOR EACH ROW MODE DB2SQL
  WHEN (NEW_ROW.C1 > 100)
  BEGIN ATOMIC
   SIGNAL SQLSTATE '75001' ('JUST FOR TEST');
  END
  !
  An abend may occur for the SQL statement above because Db2 did
  not handle the SIGNAL or VALUES statement correctly.
  

Problem conclusion

• Db2 has been modified so an abend will not occur for a CREATE
  TRIGGER(basic) statement containing a SIGNAL or VALUES
  statement.
  Additional keywords: SQLTRIGGER
  

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:

  010PC2Ÿ UI78449

Modules/Macros

• DSNXOSL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI78449

     UP21/12/16 P F112

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.