A fix is available
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 number
IC64137
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61S
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-23
Closed date
2009-11-10
Last modified date
2009-11-10
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61S","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
10 November 2009