PM40299: PANEL ADB21SS "REAL-TIME STATISTICS FOR TABLE SPACE" SHOWS TWO ROWS IF A CLONE TABLE EXISTS I.E INSTANCE GREATER THAN 1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' panel ADB21SS
  "Real-Time Statistics for Table Space" shows multiple rows
  for a given tablespace partition each of which may contain
  different data.
  .
  While the data is correct there is no guidance or explanation
  for the rows which are related to a base table and its clone
  table.
  

Local fix

• Use the BR/BROWSE command to find the "INSTANCE" column then
  manually query SYSIBM.SYSTABLESPACESTATS to establish which
  objects the information refers to.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Real Time Statistics ( RTS )    *
  *                 on a table space which has a clone table.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      panel ADB21SS 'Real-Time Statistics     *
  *                      for Table Space' shows multiple rows    *
  *                      for a given table space partition,      *
  *                      each of them may contain different      *
  *                      data.  While the data is correct        *
  *                      there is no guidance or explanation     *
  *                      for the rows which are related          *
  *                      to a base table and its clone           *
  *                      table.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Panel ADB21SS shows multiple rows when the table space has a
  clone table.
  

Problem conclusion

• The new field 'INSTANCE' has been added in panels ADB21SS
  'Real-Time Statistics for Table Space; ADB21SSI 'Interpretation
  of an Object in SYSTABLESPACESTATS', and ADBH1SS 'HELP:
  DB2 Real-Time Statistics'.
  

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:

  UK69173 UK69174

Modules/Macros

•    ADBH1SS  ADB21SS  ADB21SSI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK69173

     UP11/06/30 P F106

• R720 PSY UK69174

     UP11/06/30 P F106

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.