IT35048: GUI UNRESPONSIVE OR SLOW AFTER A FEW DAYS OF UPTIME

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 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