PM31936: ALC/ALT RESULTS IN PANEL ADB27PGA"ALTER TABLE SPACE OPTION" THE NEW ROW LENGTH 6440 IS GREATER THAN THE PAGE SIZE 8192

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS displays panel ADB27PGA
  "ALTER Table Space option" with a message:
  Page size utilization
  
  The new row length  6440      is  GREATER than the page size
  8192
  Alter the table space to change the page size or
  alter the table to change the row length to better utilize
  space.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the ALC/ALT line commands to    *
  *                 add multiple columns to a table at one       *
  *                 time.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool, when    *
  *                      the ALC/ALT line commands are used to   *
  *                      alter a table that adds multiple        *
  *                      columns at once, a message is           *
  *                      displayed on panel ADB27PGA 'ALTER      *
  *                      Table Space option' that shows the new  *
  *                      row length is greater than the page     *
  *                      size, which is not consistent with the  *
  *                      facts:                                  *
  *                                                              *
  *                      "Page size utilization                  *
  *                                                              *
  *                      The new row length  nnnn  is            *
  *                      GREATER than the page size mmmm         *
  *                      Alter the table space to change the     *
  *                      page size or alter the table to         *
  *                      change the row length to better         *
  *                      utilize space".                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In the DB2 Administration Tool, when the ALC/ALT line commands
  are used to alter a table that adds multiple columns at once,
  a message is displayed on panel ADB27PGA 'ALTER Table Space
  option' that shows the new row length is greater than the page
  size, which is not consistent with the facts.
  

Problem conclusion

• The program has been modified to retain the correct page size
  value when altering a table that adds multiple columns.
  

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:

  UK67041 UK67042

Modules/Macros

•    ADB27C
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67041

     UP11/04/27 P F104

• R720 PSY UK67042

     UP11/04/27 P F104

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.