A fix is available
APAR status
Closed as program error.
Error description
Some SQL queries used by Tivoli Storage Manager Monitoring and Reporting Agent can cause performance issues. The long queries can cause ITM to timeout after 50 seconds. When this happens, the ITM stops waiting to return the data and the Data Warehouse database will not be updated, however, the Monitoring and Reporting agent is not aware of the timeout and will continue the queries. Some of the workspaces in Tivoli Enterprise Portal for the reporting and Monitoring agent will be empty. Also some of the tables in the WAREHOUS database will be empty or missing. Some specific symptoms include the following : The Tivoli Enterprise Portal "Availability" workspace reports a "GENERAL ERROR" error code for the following workspaces : OBJECT NAME OBJECT TYPE OBJECT STATUS ERROR CODE ----------- ----------- ------------- ---------- Client_Missed_Files CUSTOM INACTIVE GENERAL ERROR Schedule CUSTOM INACTIVE GENERAL ERROR Node_Activity CUSTOM INACTIVE GENERAL ERROR AGENTLOG CUSTOM INACTIVE GENERAL ERROR The schedule workspace reports no data (empty). This is more likely to happen when a lot of data is returned from the TSM server on select queries. For example, a select command on the EVENTS table returned more than 30000 rows. Version and Platforms affected: Tivoli Storage Manager Monitoring and Reporting Agent 6.1 on all platforms. Additional Keywords: 48946 zz61 zzrm61 itm timeout DSMAPI 49790
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of the Tivoli Storage Manager * * Monitoring and * * Reporting Agent * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in level 6.1.3. Note that this is * * subject to change at the discretion of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: Windows.
Temporary fix
Comments
APAR Information
APAR number
IC63755
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-14
Closed date
2010-01-04
Last modified date
2010-02-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R61W 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:
03 February 2010