IC64137: SQL QUERIES USED BY TIVOLI STORAGE MANAGER MONITORING AND REPORTING AGENT CAN CAUSE PERFORMANCE ISSUES

IBM Tivoli Storage Manager V6.1 Fix Pack 3 (6.1.3) Server Downloads

APAR status

• Closed as program error.

Error description

• Some of the SQL queries that the Tivoli Storage Manager
  Monitoring Agent issues can cause a performance problem. The
  symptoms may seem similar to APAR IC63755, but the cause of the
  performance degradation is different. Both APARs will need to be
  applied.
  Initial Impact: Low
  Tivoli Storage Manager Versions Affected: All Reporting and
       Monitoring
  Additional Keywords: TSM zz61 zzrm61 ITM TCR hang perf IC63755
                       55941 NLS
  .
  

Local fix

• Set the KSK_SCHED_ON to zero (ex:  KSK_SCHED_ON=0) in the
  agent's configuration file. The default locations for these
  files are located:
  .
  /opt/tivoli/tsm/reporting/itm/config/sk.ini on UNIX
  C:\IBM\itm\tmaitm6\KSKENV_<instance_name> on Windows
  .
  The KSK_SCHED_ON option turns off the schedule attribute group.
  This is the same as stopping data collection for the schedule in
  the Historical Configuration window. The "Schedule" workspace in
  TEPS will still work.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM Tivoli Storage Manager.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.  Any character   *
  *                      set conversions will be affected,       *
  *                      including queries performed by the      *
  *                      Tivoli Storage Manager Monitoring       *
  *                      Agent or the Tivoli Storage Manager     *
  *                      Admin Center as well as NDMP backup     *
  *                      of NetApp or IBM n-Series filers.       *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available.  This     *
  *                 problem is currently projected to be fixed   *
  *                 in server level 6.1.3 .  Note that this is   *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  See Error Description.
  

Problem conclusion

• The performance has been improved.
  

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

• PSXPG
  

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP