IT19903: IN IBM SPECTRUM CONTROL SMIS PROBE ON FUJITSU ETERNUS DEVICES FAILS.

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

• The composite primary key in T_RES_STORAGE_POOL consists of
  three columns subsystem_id  , instance_id , class_name_id
  but in SMISCIM_StoragePoolToDBMapper constructor only
  instance_id and class_name_id are set as primary key.
  When there are multiple storage pools having the same
  instance_id and class_name but coming from different fujitsu
  devices an SqConstraintViolationException is thrown when
  updating the pool info.
  
  DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=1;TPC.T_RES_STORAGE_POOL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.x users monitoring Fujitsu Storage  *
  * ETERNUS devices, or 3PAR devices.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Spectrum Control database table for storage pool consists of *
  * 3 columns:  subsystem_id, instance_id, class_name_id.  But   *
  * SMISCIM_StoragePoolToDBMapper constructor only consists of   *
  * instance_id and class_name_id.                               *
  *                                                              *
  * When there are multiple storage pools having the same        *
  * instance_id and class_name but coming from different fujitsu *
  * devices an exception is thrown when updating the pool info:  *
  *                                                              *
  * DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,                 *
  * SQLERRMC=1;TPC.T_RES_STORAGE_POOL                            *
  ****************************************************************
  * 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-RP0015 - target August 2017
  
  Fixed in IBM Spectrum Control 5.2.15
  
  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

• Fixed component ID

  5608TPC00

Applicable component levels