PM79232: DB2 ADMINISTRATION TOOL FOR Z/OS ON PANEL ADB21SAC THE -STOP COMMAND CONTAINS AN INVALID PARTION-ID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS on Panel ADB21SAC the -STOP
  command contains an invalid Partion-ID
  after overwrite of the storagegroup On Panel ADB21XA
  
  
  
  Example of what appears on the screen:
  
  
  ADB21SAC  ---------- ssid ALTER -  STOP command confirmation -
  Row 1 to 6 of 6
  .
  A -STOP command must be issued in order to perform the ALTER
  statement.
  Once the ALTER has been performed, a -START command will be
  issued.
  .
  Select a choice:
      1 - Continue with -STOP, ALTER and -START
      2 - Perform ALTER only (no -STOP or -START)
      3 - Display tablespace/indexspace use
      4 - Cancel entire operation
  .
  -STO DB(DBname) SPACENAM(spacename) PART( 0 , 0)
  .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Administration Tool for DB2 for     *
  *                 z/OS who alter Stogroup(STORNAME - Name of   *
  *                 storage group used), ST(STORTYPE - Implicit  *
  *                 or Explicit), VCAT(VCATNAME - Name of the    *
  *                 ICF catalog of the partition) or Erase(The   *
  *                 Erase Rule) of index space or table space.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when users alter STORNAME, STORTYPE,    *
  *                      VCATNAME, or Erase Rule of an index     *
  *                      space on panel ADB21XA 'Alter Index'    *
  *                      or alter STORNAME, STORTYPE, VCATNAME,  *
  *                      or Erase Rule of a table space on       *
  *                      panel ADB21SA 'Alter Table Space',      *
  *                      after entering panel ADB21SAC 'ALTER -  *
  *                      STOP command confirmation' and          *
  *                      redisplaying panel ADB21SA or ADB21XA,  *
  *                      then alter the STORNAME, STORTYPE,      *
  *                      VCATNAME or Erase Rule again, the       *
  *                      DB2 Administration Tool generates the   *
  *                      wrong -STOP and -START command which    *
  *                      contains an invalid partition ID on     *
  *                      panel ADB21SAC.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When users alter Stogroup, STORTYPE, VCATNAME, or Erase Rule of
  an index space on panel ADB21XA 'Alter Index' or alter
  STORNAME, STORTYPE, VCATNAME, or Erase Rule of a table space
  on panel ADB21SA 'Alter Table Space', after entering panel
  ADB21SAC 'ALTER -  STOP command confirmation' and redisplaying
  panel ADB21SA or ADB21XA then alter the STORNAME, STORTYPE,
  VCATNAME or Erase Rule again, the DB2 Administration Tool
  generates the wrong -STOP and -START command which contains an
  invalid partition ID on panel ADB21SAC.
  

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:

  UK91904 UK91905

Modules/Macros

•    ADB21SA  ADB21XA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91904

     UP13/02/26 P F302

• RA20 PSY UK91905

     UP13/02/26 P F302

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.