Fixes are available
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)
APAR status
Closed as program error.
Error description
Upgrade to 5.2.8 (e.g. from 5.2.7) fails at database component and in the installation log there are some details like: [java] Failed to execute query: insert into t_rule_constraint (constraint_id, rule_id, entity_type, property_name, operator, value, value_type) values ((select COALESCE(max(constraint_id), 0)+1 from t_rule_constraint), (select alert_id from t_alert_definition where NAME='SysMemUtil' ... [java] DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=6, TABLEID=3606, COLNO=1, DRIVER=3.65.77
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Those upgrading to Spectrum Control 5.2.8 who have * * previously installed TPC 5.2.0 and then upgraded to one of * * the TPC 5.2.3 through 5.2.7 levels. If you have upgraded to * * 5.2.1 or 5.2.2 prior to reaching 5.2.3 through 5.2.7, this * * problem should not affect you. * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: * * If you fall into the case of affected users, do not install * * 5.2.8. Rather, use Spectrum Control 5.2.9 for upgrades when * * available. If you have already encountered this failure, * * contact IBM Support for assistance restoring missing alerts * * to resolve the upgrade issue. * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following maintenance package: | refresh pack | 5.2-TIV-TPC-RP0009 - target February 2016 Fixed in IBM Spectrum Control 5.2.9. 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-RP0008 |
Temporary fix
Comments
APAR Information
APAR number
IT13094
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
527
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-01-15
Closed date
2016-02-24
Last modified date
2016-02-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INSTALL
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R528 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"527","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
22 February 2022