IT15885: DB TABLES GET LOCKED DURING REMOVAL OF EXPIRED ENTRIES CAUSING THE PROBE JOBS TO FAIL AND WEB GUI TO HANG

IBM Spectrum Control 5.2.11 - Windows Server
IBM Spectrum Control 5.2.11 - Linux Server
IBM Spectrum Control 5.2.11 - AIX Server
IBM Spectrum Control 5.2.11 - Agent
IBM Spectrum Control V5.2.10.1 (July 2016)
IBM Spectrum Control V5.2.11 (August 2016)
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

• DETAIL OF PROBLEM:
  After upgrade of TPC or Spectrum Control to version 5.2.10
  Storage system probes begin to hang, which may cause subsequent
  scheduled Probe jobs to fail due to the hanging probes.
  Accessing the Web GUI may become problematic, especially when
  attempting to access Storage Device panels due to database locks
  caused by the Device server not releasing the lock placed on the
  database table while performing maintenance activity.
  Rebooting the server will temporarily restore access to the GUI
  until the next time a Storage System probe runs and locks the
  database.
  RECREATE STEPS:
  Upgrade an existing TPC or Spectrum Control environment actively
  monitoring SVC/Storwize devices to Spectrum Control v5.2.10.
  Allow scheduled Storage system Probe jobs to run and observe job
  run time increase with subsequent runs of the Probes beginning
  to fail.  GUI usability degrades and Storage panels will no
  longer load.
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPCA0
  Server/Manager build/release (TPC):   5.2.10
  ___________________________________________________
  Problem as described by customer: Probe jobs taking many hours
  to complete (12-24hrs) when normally complete in 1 or 2 hours.
  Web GUI panels do not load and become unusable.
  
  Initial customer impact (low/med/high): high
  Local Fix:  n/a
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.10 users                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Problems accessing the web UI.  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-RP0011 - target August 2016
  
  Fixed in IBM Spectrum Control 5.2.11.
  
  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.
  
  | MDVREGR | 5.2-TIV-TPC-RP0010 |
  

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

• DEVICE
  

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels

• R52A PSY

     UP