PK76150: PANEL ADB2314 "TABLE SPACE MAINTENANCE" DOES NOT PROVIDE FACILIT IES TO FILTER PARTITIONED OBJECTS RESULTING IN DUPLICATE UTILS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB2314 "Table Space
  Maintenance" does not provide facilities to filter partitioned
  tablespaces successfully resulting in duplicated utility steps
  i.e. if two partitions of the same tablespaces are listed on
  panel ADB2314 and a "C - Full Copy" command line command is
  issued the resulting JCL will contain two steps each having
   COPY TABLESPACE aaa.aaa DSNUM ALL
  

Local fix

• Manually delete the additional steps or use the "-" line command
  to remove all but one of the partitions.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 Admin Tool users who use real time       *
  *                 performance query screen ADB2314.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: On panel ADB2314,  when generating the  *
  *                      utility jobs from the primary command,  *
  *                      DB2  Administration Tool is not taking  *
  *                      the partition value into account,  and  *
  *                      generates multiple  steps for the same  *
  *                      tablespace,   but  does  not  add  the  *
  *                      partition  number for the  tablespace.  *
  *                      The  result  is  the  duplicate  steps  *
  *                      performing  the identical  process for  *
  *                      the entire tablespace.                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Panel ADB2314 has been changed  such that  primary commands C,
  CI, O, and R operate  at the partition level if the tablespace
  is partitioned. New primary commands with an 'A' suffixed (CA,
  CIA, OA, and RA) have been added to the panel which generate a
  single step to process all  partitions of a  table space, even
  when  multiple  partitions of the same table space are present
  on screen ADB2314.
  

Problem conclusion

• The duplicate steps  generated by primary commands on screen
  ADB2314 have been eliminated and the generated steps operate
  at the partition level.
  
  A new set of primary commands  has been added to screen ADB2314
  to allow processing all partitions of table spaces displayed on
  ADB2314, with one step per table space.
  

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

•    ADB2314
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK43898

     UP09/02/17 P F902

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.