APAR status
Closed as program error.
Error description
During the engine start up, by default, SCC will retrieve the last 100 completed activities for each of the monitored server. The SQL queries that try to retrieve the last 100 activities from the Database is timing out(after 10 minutes).
Local fix
STRRTC - 371542 SF / SF Circumvention: None
Problem summary
Description of issue: During the engine start up, by default, SCC will retrieve the last 100 completed activities for each of the monitored server. The SQL queries that try to retrieve the last 100 activities from the Database is timing out(after 10 minutes). Please investigate optimizing that query.
Problem conclusion
Description of fix: The query that retrieves last 'n' completed activities for a monitored server was changed to use database specific syntax to improve the performance.
Temporary fix
Description of issue: During the engine start up, by default, SCC will retrieve the last 100 completed activities for each of the monitored server. The SQL queries that try to retrieve the last 100 activities from the Database is timing out(after 10 minutes). Please investigate optimizing that query. Description of fix: The query that retrieves last 'n' completed activities for a monitored server was changed to use database specific syntax to improve the performance.
Comments
APAR Information
APAR number
IC91065
Reported component name
STR CONTROL CEN
Reported component ID
5725D0200
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-22
Closed date
2013-04-12
Last modified date
2013-04-12
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
STR CONTROL CEN
Fixed component ID
5725D0200
Applicable component levels
R52X PSY
UP
R530 PSY
UP
R540 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
12 April 2013