PK46964: MSG "NO TABLESPACESTATS TABLE" OR "NO INDEXSPACESTATS TABLE" UNDER DB2 9 ON PANEL ADB2314T OR ADB2314I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool references the wrong table name
  as SYSIBM.TABLESPACESTATS became SYSIBM.SYSTABLESPACESTATS and
  SYSIBM.INDEXSPACESTATS became SYSIBM.SYSINDEXSPACESTATS
  under DB2 9. This results in message 'No TABLESPACESTATS table'
  in panel ADB2314 'Input Parameters for Real-Time Statistics'
  and message 'No INDEXSPACESTATS table' for panel ADB2314I
  'Input Parameters for Real-Time Statistics'.
  

Local fix

• As a work around please define the following:
  CREATE ALIAS SYSIBM.TABLESPACESTATS FOR
  SYSIBM.SYSTABLESPACESTATS;
  CREATE ALIAS SYSIBM.INDEXSPACESTATS FOR
  SYSIBM.SYSINDEXSPACESTATS;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL  who use  DB2 v9 915 *
  *                 or above, and:                               *
  *                  - use the  RTS (real-time  statistics) line *
  *                    command on panel ADB21D(database), ADB21S *
  *                    (table space),ADB21SP(table space parts), *
  *                     ADB21X(index),  or ADB21XP(index parts). *
  *                  - use panel adb2314I or ADB2341T(parameters *
  *                    for real-time statistics).                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The "No TABLESPACESTATS  table" or "No  *
  *                      INDEXSPACESTATS  table"  error message  *
  *                      was received:                           *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  With DB2 v9 915 and above, the TABLESPACESTATS table name has
  been renamed to  SYSTABLESPACESTATS,  and the INDEXSPACESTATS
  table  name has been  renamed to SYSINDEXSPACESTATS.  The new
  names need to be used in DB2 ADMIN TOOL.
  

Problem conclusion

• The new names will now be used with DB2 v9 915 or above. The
  problem has been fixed.
  

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

•    ADBH1SSI ADB21    ADB21D   ADB21S   ADB21SP
  ADB21SSI ADB21X   ADB21XP  ADB21XSD ADB2314I ADB2314T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK30223

     UP07/10/25 P F710

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.