PM68803: COMPARE DDL TO DDL FAILS ONCODE451 IN GOC2CMP ROUTINE SRC_INPUT AT STATEMENT 7798

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare Tool for z/OS can fail in very large DDL
  to DDL compare with ONCODE 451 storage condition with
  messages similar to the following:
  .
  IBM0451S  ONCODE=451  The STORAGE condition was raised.
            From entry point SRC_INPUT at statement 7798
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who use compare a large number of       *
  *                 tables ( more than 16,000 ).                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool, when     *
  *                      there are a large number of tables      *
  *                      being compared ( more than 16,000 ),    *
  *                      Compare will run out of memory and      *
  *                      issue an ONCODE451 / ONCODE=451 error   *
  *                      in GOC2CMP:                             *
  *                                                              *
  *                      IBM0451S  ONCODE=451                    *
  *                      The STORAGE condition was raised.       *
  *                        From entry point >entry_point<        *
  *                      at statement 7798 at compile            *
  *                      unit offset >offset_address<            *
  *                      at entry offset >offset_address<        *
  *                      at address offset_address.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a large number of tables ( 16,000 or more ), the DB2
  Object Compare will run out of memory and issue an ONCODE451 /
  ONCODE=451 error in GOC2CMP:
  

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:

Modules/Macros

•    ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81227

     UP12/08/24 P F208

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.