APAR status
Closed as program error.
Error description
DETAIL OF PROBLEM: In the logs there are more errors like "The transaction log for the database is full.. SQLCODE=-964, SQLSTATE=57011" The T_RES_DATA_PATH database table is very big and the SQL being called has many entries and / or many counts for some devices, resulting a very heavy load on the database resulting in transaction logs being consumed.
Local fix
Temporary relief involves reboot of server
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Storage Insights users with an extremely large * * environment and numerous concurrent active users * **************************************************************** * PROBLEM DESCRIPTION: * * Storage Insights GUI became unresponsive. * * The web server was not working properly and * * restarting the web server did not solve the * * problem on its own, only a full reboot of the * * server worked to resolve the problem * * * * In the logs there are more errors like "The * * transaction log for the database is full.. SQLCODE=-964, * * SQLSTATE=57011" * * * * The T_RES_DATA_PATH database table is very big * * and the SQL being called has many entries and / or many * * counts * * for some devices, resulting a very heavy load on the * * database * * resulting in transaction logs being consumed. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Spectrum Control 5.4.2 [ 5.4.2-IBM-SC ] IBM Storage Insights 1Q21 [ 5.4.2-IBM-SI-Patch ] ( release target 1Q 2021 / February ) The target dates for future releases do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT35048
Reported component name
STORAGE INSIGHT
Reported component ID
5608TPCSI
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-24
Closed date
2020-12-02
Last modified date
2021-02-15
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
STORAGE INSIGHT
Fixed component ID
5608TPCSI
Applicable component levels
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSQRB8","label":"IBM Storage Insights"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"540"}]
Document Information
Modified date:
08 February 2022