Fixes are available
APAR status
Closed as program error.
Error description
DB2 Application snapshots show queries that need to read millions of rows in order to update thousands of rows. This query is inefficient in design and was determined to be related to deprecated periodic background tasks running for propagated status processing. This excessive DB activity contributes to GUI slowness in all IBM Spectrum Control versions from 5.2.8 to 5.2.11 inclusive. RECREATE STEPS: Observe slow GUI performance in versions 5.2.8-5.2.11 ________________________________________________________________ DB2 Version used for Server: N/A The defect is against component: 5608TPC00 Server/Manager build/release (TPC): 5.2.11 ________________________________________________________________ Problem as described by customer: Slow GUI performance Initial customer impact (low/med/high): med
Local fix
Apply fixing level when available.
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control 5.2.x users * **************************************************************** * PROBLEM DESCRIPTION: * * Inefficient background queries run and consume system * * resources. See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following maintenance package: | refresh pack | 5.2-TIV-TPC-RP0012 - target November 2016 Fixed in IBM Spectrum Control 5.2.12. http://www.ibm.com/support/docview.wss?&uid=swg21320822 The target dates for future refresh packs do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT17113
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
52B
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-19
Closed date
2016-09-26
Last modified date
2016-09-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DEVICE
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R528 PSY
UP
R529 PSY
UP
R52A PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"52B"}]
Document Information
Modified date:
23 March 2022