IT19929: IBM SPECTRUM CONTROL UPGRADE IN 5.2.12 MAY HANG AT 16% PROGRESSION.

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 upgrade from 5.2.11 to 5.2.12 is hanging at the following
  delete:
  (see in the lax* file or traceTPCInstall.log)
  
  DELETE FROM T_RELATIONSHIP_DATA_STORE WHERE (ID, DEVICE_ID,
  REL_TYPE, REL_ID) IN (SELECT R.ID, R.DEVICE_ID, R.REL_TYPE,
  R.REL_ID FROM T_RELATIONSHIP_DATA_STORE R JOIN T_TEMP_CLEAN_LDID
  C ON R.ID = C.LDID_TO_DELETE OR R.ID = C.LDID_TO_REMAIN) AND
  (ID, DEVICE_ID, REL_TYPE, REL_ID) NOT IN (SELECT MIN(R.ID),
  R.DEVICE_ID, R.REL_TYPE, R.REL_ID FROM T_RELATIONSHIP_DATA_STORE
  R JOIN T_TEMP_CLEAN_LDID C ON R.ID = C.LDID_TO_DELETE OR R.ID =
  C.LDID_TO_REMAIN GROUP BY R.DEVICE_ID, R.REL_TYPE, R.REL_ID,
  C.LDID_TO_REMAIN)
  
  And the following messages:
  2017-03-08 16:07:59.804+0100 INFO
  com.ibm.tpc.install.frontend.ia.actions.ProgressBarUpdater
  setPercentageComplete Component taking longer than estimated
  time C:\Program Files\IBM\TPC\config\install\tpcdb.xml: Percent
  = 2298.2456
  
  2017-03-08 16:07:59.804+0100 INFO
  com.ibm.tpc.install.frontend.ia.actions.ProgressBarUpdater
  setPercentageComplete Seconds complete = 6550.0
  
  
  The command is not completely hanging but very slow due to the
  deletion of million of rows.
  The performance of the sql delete command has been improved.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The upgrade of IBM Spectrum Control my hang and fail to      *
  * complete the upgrade.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The upgrade of IBM Spectrum Control my hang and fail to      *
  * complete the upgrade.                                        *
  ****************************************************************
  * 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