PM77562: ABEND04E RC00E2000D AT DSNXGXTB DSNSVSFB OFFSET0848 WHEN BINDING A SQL STATEMENT WITH MULTIPLE UNION ALLS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E2000D AT DSNXGXTB DSNSVSFB OFFSET0848 WHEN BINDING
  A SQL STATEMENT WITH MULTIPLE UNION ALLS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS users *
  *                 of the CREATE TRIGGER statement that defines *
  *                 a TRIGGER that contains at least 20 UNION or *
  *                 UNION ALL statements.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E2000D can occur at     *
  *                      location DSNXGXTB DSNSVSFB OFFSET0848   *
  *                      when creating a TRIGGER that contains   *
  *                      at least 20 UNION or UNION ALL          *
  *                      statements.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E2000D can occur at location DSNXGXTB DSNSVSFB
  OFFSET0848 when creating a TRIGGER that contains at least 20
  UNION or UNION ALL statements.
  
  The following CREATE TRIGGER statement is an example of a
  failing case.
  
  CREATE TRIGGER TRIG_01
      INSTEAD OF INSERT ON T1
      REFERENCING NEW_TABLE AS N
      FOR EACH ROW MODE DB2SQL
        BEGIN ATOMIC
        INSERT INTO T1
          SELECT *
            FROM N
            WHERE N.TKKEY < 2240001
          UNION ALL
          SELECT *
            FROM N
            WHERE N.TKKEY BETWEEN 2240001 AND 2500000
          UNION ALL
         ... repeat the above UNION ALL statements ...
        END!
  

Problem conclusion

• The code in DB2 has been modified to correct the conditions
  leading to the abend when executing a CREATE TRIGGER statement
  that defines a TRIGGER that contains at least 20 UNION or UNION
  ALL statements.
  
  Additional Keywords: SQLUNIONALL SQLUNION 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:

  UK91577 UK91578

Modules/Macros

• DSNXGRM1 DSNXGRTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91577

     UP13/02/27 P F302

• R910 PSY UK91578

     UP13/02/27 P F302

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.