Fixes are available
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center
APAR status
Closed as program error.
Error description
In large environments, the report can run 10 minutes or substantially more. This occurs because by default, there are similar SQL queries for all four charts on the report and one for the list on the report, therefore running 5 large queries at the same time.
Local fix
Use Custom Date Ranges and not relative dates. Also contact support for performance fix.
Problem summary
**************************************************************** * USERS AFFECTED: * * TPC 5.1.x users that run Performance report Storage * * Virtualizer - Volume Details Report in large environments * **************************************************************** * PROBLEM DESCRIPTION: * * This is a Cognos reporting performance issue that shows up * * in large environments when users run Performance report * * Storage Virtualizer - Volume Details Report * * The Storage Virtualizer - Volume Details Report report for * * Hourly, Sample for the Last 7 days run in more than 30 min * **************************************************************** * RECOMMENDATION: * * This fix plus additional performance fixes are already in * * 5.2. If many reports are running slow please upgrade to TPC * * 5.2.x * ****************************************************************
Problem conclusion
The issue has been solved by using shared queries. The report should run now faster(in less than 3 min). The fix for this APAR is targeted for the following maintenance package: | fix pack | 5.1.1-TIV-TPC-FP0005 - target July 2014 http://www-01.ibm.com/support/docview.wss?&uid=swg21320822 The target dates for future fix packs do not represent a formal commitment by IBM. The dates are subject to change without notice. This fix plus additional performance fixes are already in 5.2.
Temporary fix
Comments
APAR Information
APAR number
IT00573
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-03-24
Closed date
2014-04-21
Last modified date
2014-04-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
PM
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R510 PSY
UP
R511 PSY
UP
Document Information
Modified date:
23 March 2022