IT16847: SLOW/UNRESPONSIVE WEG GUI DUE TO INFREQUENT DB2 TRANSACTION COMMITS

IBM Spectrum Control V5.2.12 (November 2016)
IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)

APAR status

• Closed as program error.

Error description

• 5.2.x web-based GUI performance is observed to slow down the
  longer the web server process runs.  All panels/views are
  impacted.
  This has been traced back to the statements which update the
  "relationship" tables including:  T_RELATIONSHIP_MDISK,
  T_RES_STORAGE_EXTENT, among others.
  The problem is most pronounced in environments with a high
  number of MDisks.  This excessive number of MDisks results in
  millions of rows being selected in certain queries and with
  multiple probes/updates going on at the same time, and these
  result in a locklist issue for DB2 where they end up escalating
  locks to X locks.
  The following db2diag.log messaging is evidence of this problem:
  2016-08-05-20.28.15.225000+000 E543777549F767       LEVEL:
  Warning
  PID     : 4336                 TID : 5856           PROC :
  db2syscs.exe
  INSTANCE: DB2                  NODE : 000           DB   : TPCDB
  APPHDL  : 0-13                 APPID: *LOCAL.DB2.160720161548
  AUTHID  : DB2ADMIN             HOSTNAME: usstlecpinfap25
  EDUID   : 5856                 EDUNAME: db2stmm (TPCDB) 0
  FUNCTION: DB2 UDB, Self tuning memory manager,
  stmmCheckIfFreeMemoryIsEnoughForSizeIncrease, probe:690
  MESSAGE : ZRC=0xFFFFEC49=-5047
            SQL5047C  Insufficient memory to execute this
  function.
  This APAR reduces the DB2 lock list size by committing
  transactions more frequently.  The incremental commits allow DB2
  to flush the lock list to allow other locks to occur.  Having
  one large commit in large environments resulted in DB2 not
  having any room left in the lock list (capped by DB2's auto
  configuration setting at 20% of DB2 memory).
  RECREATE STEPS:
  Observe slow GUI performance in 5.2.x environments
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.10, 5.2.10.1, 5.2.11
  
  ________________________________________________________________
  Problem as described by customer:   slow gui performance
  Initial customer impact (low/med/high): high
  

Local fix

• Apply fixing PTF level when available; contact support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.x users                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Slow and unresponsive web user interface worsening over      *
  * time.  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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• UI
  

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels

• R528 PSY

     UP

• R529 PSY

     UP

• R52A PSY

     UP

• R52B PSY

     UP