PM16574: RTS IN DB2 V9 ENFM USES TABLESPACESTATS AND INDEXSPACESTATS INSTEAD OF SYSTABLESPACESTATS AND SYSINDEXSPACESTATS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In the DB2 Administration Tool for z/OS, when using RTS function
  in a DB2 9 ENFM subsystem, the wrong tables are used in the SQL.
  Tables used are the user defined tables TABLESPACESTATS and
  INDEXSPACESTATS instead of SYSTABLESPACESTATS and
  SYSINDEXSPACESTATS.  If the old tablespace/indexspaces are
  stopped, default names DATABASE(DSNRTSDB) TABLESPACE(DSNRTSTS)
  INDEXSPACE(INDEXSPA) and INDEXSPACE(TABLESPA), users will
  experience a SQLCODE -904 error.
  Additional Symptoms: sqlcode904 sqlcoden904
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'RTS' command on            *
  *                 panels ADB21X, ADB2XP, ADB21S,               *
  *                 ADB21SP and ADB21D.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The 'RTS' line command of the DB2       *
  *                      Administration Tool for z/OS uses       *
  *                      the wrong table names in DB2 V9         *
  *                      ENFM.                                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Line command 'RTS' of panels ADB21X, ADB21XP,
  ADB21S, ADB21SP and ADB21D uses the wrong table
  names in DB2 V9 ENFM.
  

Problem conclusion

• Panels ADB21X, ADB21XP, ADB21S, ADB21SP, ADB21D
  and EXEC ADBDISOB have been modified to ensure the
  'RTS' line command in these panels uses the correct table
  names in DB2 V9 ENFM.
  

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

•    ADBDISOB ADB2M1S  ADB21D   ADB21S   ADB21SP
  ADB21TPS ADB21X   ADB21XP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.