APAR status
Closed as program error.
Error description
The design of the queries that run to generate this report results in excessive CPU cycles and causes general sluggishness in other functions. Increasing CPU usage can be confirmed via operating system administration tools (Windows task manager, AIX topas, etc). RECREATE STEPS: Run the predefined report "performance of one storage system" in Cognos and observe very high CPU usage. ________________________________________________________________ DB2 Version used for Server: N/a The defect is against component: 5608TPC00 Server/Manager build/release (TPC): 5.2.9 ________________________________________________________________ Problem as described by customer: Report causes system to slow down Initial customer impact (low/med/high): med
Local fix
Apply fixing PTF when available
Problem summary
**************************************************************** * USERS AFFECTED: * * Spectrum Control 5.2.x users who generate performance report * * for subsystems (Web UI or Cognos report) * **************************************************************** * PROBLEM DESCRIPTION: * * Very high CPU usage by the DB2sysc process when running * * performance report for subsystems. * **************************************************************** * 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-RP0010 Fixed in IBM Spectrum Control 5.2.10. http://www.ibm.com/support/docview.wss?&uid=swg21320822
Temporary fix
Comments
APAR Information
APAR number
IT15919
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
529
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-28
Closed date
2016-10-03
Last modified date
2016-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Data
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R52A PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"529","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
22 February 2022