IT17088: IMPROVE TRACING ON ALERT SERVER UPGRADE CODE FOR MIGRATING ALERTS.

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

• Problems with the database migration that takes place during
  upgrades results in an excessively busy Alert Server component
  which can then impact device server functions, resulting in slow
  GUI performance across all Spectrum Control views and functions.
  Evidence of the alert migration problem manifests itself in the
  alert server logs with messaging similar to this:
  1:  2016-07-05 21:32:25.166-0400 *** Error: SrvDskStat is of
  type Integer; not Short
  com.ibm.tpc.cep.entityFacts.DeviceEntity getAttributeShort()
  Default Executor-thread-3841
  This is due to entries in the db table:
  T_RULE_CONSTRAINT.PROPERTY_NAME='SrvDskStat', With all
  T_RULE_CONSTRAINT.VALUE_TYPE having values of 1
  (ConsolidatedConstraint.VALUE_TYPE_SHORT).
  2:  2016-07-08 09:23:38.114-0400 *** Error: Unable to Analyse
  Expression isRelatedTo($StorageNodeEntity_entityId,
  $StorageNodeEntity_topLevelId):
  [Error: unable to resolve method using strict-mode:
  com.ibm.tpc.cep.entityFacts.StorageSubsystemJobEntity.isRelatedT
  o(int, int)]
  [Near : {... isRelatedTo($StorageNodeEntity ....}]
  *JobEntity refers to Probe or PM status alerts. This is a
  special type of alert where Spectrum Control does not allow
  multi-condition. In other words, there should only be one
  constraint entry in T_RULE_CONSTRAINT for these alerts.
  Checking the alerts for StorageSubsystemJobEntity (Storage Probe
  or PM status alerts), There are many alerts that have more than
  1 entry.
  This APAR improves tracing to better capture problems with alert
  migration during upgrades.
  RECREATE STEPS:  N/A
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.10.1
  ___________________________________________________
  Problem as described by customer:   Alert server issues
  impacting device server functions
  Initial customer impact (low/med/high): med
  

Local fix

• Contact support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.x users who've upgraded Spectrum    *
  * Control and subsequently encounter slow GUI performance      *
  * across all Spectrum Control views and functions.             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Problems with the database migration that takes place during *
  * upgrades results in an excessively busy Alert Server         *
  * component which can then impact device server functions,     *
  * resulting in slow GUI performance across all Spectrum        *
  * Control views and functions.                                 *
  ****************************************************************
  * 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-RP0014 - target May 2017
  
  Fixed in IBM Spectrum Control 5.2.14
  
  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:

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels