PM69278: GEN OF TRIGGER OBJECT CAN FAIL WITH ONCODE -451 STORAGE CONDITION AND ABEND U4039 RC0

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS can use GEN command to
  generate DDL for TRIGGER objects. Batch job can fail with high
  cpu and storage exhaustion ( SOS Short On Storage ) with
  ONCODEN451 storage condition and abendu4039 rc00 .
  .
  Reporting customer environment is DB2 v9 NFM .
  .
  Traceback shows routine SUBSELECT statement 8273 in loadmod
  ADB2GEN as last Admin routine prior to error. There are 118
  stack entries, which may indicate a possible loop condition.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Generate (GEN) to generate      *
  *                 DDL for TRIGGER objects.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN command to generate  *
  *                      DDL for TRIGGER objects, the Batch job  *
  *                      can fail with high CPU and storage      *
  *                      exhaustion ( SOS Short On Storage )     *
  *                      with ONCODE=451 / ONCODE451 storage     *
  *                      condition and abendu4039 rc00 :         *
  *                                                              *
  *                      IBM0451S  ONCODE=451                    *
  *                      The STORAGE condition was raised.       *
  *                         From entry point SUBSELECT at        *
  *                      statement 8287 at compile unit          *
  *                      offset +000000FC at entry               *
  *                      offset +000000FC at                     *
  *                       address >address<.                     *
  *                      ERROR condition was raised              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Performing GEN on a TRIGGER object caused a loop with an
  ONCODE=451 /ONCODE451 storage condition.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK82939 UK82940

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82939

     UP12/10/30 P F210

• RA20 PSY UK82940

     UP12/10/30 P F210

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.