PI29569: ADBALT IS USING TOO MUCH MEMORY. PARSER INCREASES REGION SIZE BY 160MB. 15/01/30 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Parser increasing REGION size by 160 MB.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use 'ALT Alter Table' (ALT) and/or  *
  *                 Change Management (CM) functions.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: After applying the PTF for APAR         *
  *                      PI26570, the functions use excessive    *
  *                      memory resulting in an ONCODE=0         *
  *                      message:                                *
  *                                                              *
  *                      Error occurred processing DDL           *
  *                      statement                               *
  *                                                              *
  *                      Length of stmt:     95                  *
  *                        1   ADMIN ALTER TABLE >table_name<    *
  *                      REPLACE COLUMN >col_name< CHAR(5)       *
  *                      FOR SBCS DAT                            *
  *                            73   A NOT NULL WITH DEFAULT      *
  *                      An ONCODE condition     0 has been      *
  *                      detected from location ADBCDTS          *
  *                      Error: " oncode()="                     *
  *                      0" onloc()="ADBCDTS" online()="         *
  *                      2929" onoffset()="         20706"       *
  *                      oncondcond()="" on                      *
  *                      condid()="             7"               *
  *                      ...                                     *
  *                        ADBALT - Error(s) found.              *
  *                      Please review output                    *
  *                      ERROR condition was raised              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  After applying the PTF for APAR PI26570, the functions use
  excessive memory resulting in an ONCODE=0 message.
  

Problem conclusion

• Problem has been fixed.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• ×**** PE15/01/30 FIX IN ERROR. SEE APAR PI27832  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI23099

Modules/Macros

•    ADB2PA   ADB2PA3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI23099

     UP14/11/18 P F411 Ž

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.