IT12493: FABRIC/SWITCH WEB UI PANELS LOAD SLOW DUE TO SQL QUERIES.

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
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• Slow running queries seen in WEB UI trace logs require
  investigation:
  
  i.e.
  2015-11-18 13:52:44.854-06:00 <t 119403899, conn
  1226474251> executing prepstmnt 2022417441
  WITH SWITCH_IN_ISL AS ( SELECT DISTINCT P2P.PORT2PORT_ID AS
  ISC_ID,
  SW1.SWITCH_WWN AS SWITCH_WWN, F.FABRIC_WWN AS
  FABRIC_WWN, CASE WHEN ****
  2015-11-18 14:20:24.908-06:00<t 119403899, conn
  1226474251> [1660054 ms] spent
  

Local fix

• TBD
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.2.6 and 5.2.7 users viewing fabric and switch panels   *
  * in the web UI.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * 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-RP0008
  | fix pack | 5.2.1-TIV-TPC-FP0001 - February 2016
  
  Fixed in IBM Spectrum Control 5.2.8 and TPC 5.2.7.1.
  
  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-FP0006 |
  | MDVREGR 5.2-TIV-TPC-FP0007 |
  

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

• FABRIC
  

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels

• R526 PSY

     UP

• R527 PSY

     UP