IT11539: REDUNDANT DATABASE ENTRIES CAUSE ALL TPC PROBES AND EVENT PROCESSING TO SLOW DOWN AND/OR HANG.

Tivoli Storage Productivity Center 5.2.7.1 - Windows Server Files
Tivoli Storage Productivity Center 5.2.7.1 - Linux Server Files
Tivoli Storage Productivity Center 5.2.7.1 - AIX Server Files
Tivoli Storage Productivity Center 5.2.7.1 Agent Files
Tivoli Storage Productivity Center 5.2.7.1
IBM Spectrum Control V5.2.8 (December 2015)
IBM Spectrum Control V5.2.9 (February 2016)
IBM Spectrum Control V5.2.10 (May 2016)
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)
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• SVC event processing fills up T_STAT_DISK_HIST with redundant
  entries and then all probes and event processing take a very
  long time to complete.
  When storage subsystem probes appear to hang and never complete,
  examine the TPC device server javacore files.  Look for entries
  like this, which indicate hung threads accessing the
  T_STAT_DISK_HIST table:
  4XESTACKTRACE                at
  com/tivoli/itsrm/TStorm/repository/TStatDiskHist.ageOff(TStatDis
  kHist.java:1323(Compiled Code))
  4XESTACKTRACE                at
  com/tivoli/itsrm/TStorm/repository/TStatDiskHist.ageHist(TStatDi
  skHist.java:1285(Compiled Code))
  RECREATE STEPS:
  Notice hung probes that never seem to complete in the TPC
  web-based GUI
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.7
  ________________________________________________________________
  Problem as described by customer:   probes hung
  Initial customer impact (low/med/high): high
  

Local fix

• Apply fixing PTF when available; contact support for
  patch/cleanup steps.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.2.7 users monitoring SVC  or other Storwize subsystem. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * High DB2 CPU usage.                                          *
  * Increased size of DB2 transaction logs and table spaces.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available.                        *
  ****************************************************************
  

Problem conclusion

• For each SVC event entries were inserted in T_STAT_DISK_HIST.
  
  The fix for this APAR is targeted for the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0008 - target December 2015
  | fix pack | 5.2.1-TIV-TPC-FP0001 - February 2016
  
  http://www-01.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-RP0007 |
  

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   Server
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R527 PSY

     UP