PI07903: PANEL ADB21SA ALTERING BP OF PBG TS GENERATES ERROR MESSAGE INVALID BUFFER POOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS generates error message:
  Invalid buffer pool
     Buffer Pool name must be BP8K0-BP8K9, and the size cannot
     be altered.  To alter the Buffer Pool name to something
     other than BP8K0-BP8K9, use the RD primary command.
  When entering AL on Panel ADB21SA trying to ALter a PBG
  Tablespace Bufferpool from 8K to 4K.      (ADB277E msgADB277E)
  

Local fix

• Specify ALT or a larger Buffer Pool.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 9, when using the AL line        *
  *                      command on panel ADB21SA 'Alter Table   *
  *                      Space' to alter the buffer pool to a    *
  *                      different page size, DB2 Administration *
  *                      Tool issues the error message ADB277E:  *
  *                                                              *
  *                      Buffer Pool name must be BP8K0-BP8K9,   *
  *                      and the size cannot be altered.  To     *
  *                      alter the Buffer Pool name to           *
  *                      something other then BP8K0-BP8K9, use   *
  *                      the RDEF primary command.               *
  *                                                              *
  *                      But the RDEF primary command is not a   *
  *                      valid command on DB2 Administration     *
  *                      Tool Version 10, Release 2 and DB2      *
  *                      Administration Tool Version 11,         *
  *                      Release 1.                              *
  *                                                              *
  *                      In DB2 10, the AL line command should   *
  *                      support altering the buffer pool to a   *
  *                      different page size. But when a         *
  *                      customer uses the AL line command       *
  *                      on panel ADB21SA 'Alter Table Space'    *
  *                      to alter the buffer pool to a different *
  *                      page size, DB2 Administration Tool      *
  *                      issues the error message ADB277E:       *
  *                                                              *
  *                      Buffer Pool name must be BP8K0-BP8K9,   *
  *                      and the size cannot be altered.  To     *
  *                      alter the Buffer Pool name to           *
  *                      something other then BP8K0-BP8K9,       *
  *                      use the RDEF primary command.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 9, when using the AL line command on panel ADB21SA
  'Alter Table Space' to alter the buffer pool to a different
  page size, DB2 Administration Tool issues the error message
  ADB277E:
  
  Buffer Pool name must be BP8K0-BP8K9, and the size can not be
  altered.  To alter the Buffer Pool name to something other than
  BP8K0-BP8K9, use the RDEF primary command.
  
  But the RDEF primary command is not a valid command on DB2
  Administration Tool Version 10, Release 2 and DB2
  Administration Tool Version 11, Release 1.
  
  In DB2 10, the AL line command should support altering the
  buffer pool to a different page size. But when a customer uses
  the AL line command on panel ADB21SA 'Alter Table Space' to
  alter the buffer pool to a different page size, DB2
  Administration Tool issues the error Message ADB277E:
  
  Buffer Pool name must be BP8K0-BP8K9, and the size cannot be
  altered.  To alter the Buffer Pool name to something other than
  BP8K0-BP8K9, use the RDEF primary command.
  

Problem conclusion

• Problem has been resolved.
  
  In DB2 9, if altering the buffer pool to a different page size,
  the DB2 Administration Tool issues the following message:
  
  ADB908E
  
  Invalid buffer pool size. The buffer pool must be &bpm
  and the size cannot be altered. To alter the buffer pool
  size to something other than &bpm, enter END to exit and
  return to the Table Space panel (ADB21S). Then, use the
  line command ALT to redefine the table space. Do not use
  the AL command to change the buffer pool size to a different
  buffer pool size.
  
  Explanation
  The buffer pool size must be appropriate for the table space.
  If the buffer pool size of the table space is 4KB, the value
  of &bpm is BP0-BP49, 8KB is BP8K0-BP8K9, 16KB is BP16K0-BP16K9,
  and 32KB is BP32K, BP32K1-BP32K9.
  
  System action
  Processing stops.
  
  User response
  Use the line command ALT to redefine the table space.
  Do not use the AL line command.
  

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

• ADB21SA  ADB90
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI17017

     UP14/04/16 P F404

• RB10 PSY UI17018

     UP14/04/16 P F404

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.