Direct links to fixes
IBM Spectrum Control 5.2.11 - Windows Server
IBM Spectrum Control 5.2.11 - Linux Server
IBM Spectrum Control 5.2.11 - AIX Server
IBM Spectrum Control 5.2.11 - Agent
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
TPC installation directory/web/log/tpctrace*.log shows: 2016-03-14 11:01:29.450+01:00 -7883662613711171210 com.ibm.tpc.internal.api.services.impl.StorageSubsystemServiceIm pl getStoragePools <openjpa-2.2.1-r422266:1396819 fatal store error> org.apache.openjpa.persistence.OptimisticLockException: Unable to obtain an object lock on "null". FailedObject: select distinct SP.POOL_ID, SS.SUBSYSTEM_ID, SS.OS_TYPE, COALESCE(SS.USER_PROVIDED_NAME,SS.DISPLAY_NAME) as STORAGESYSTEM, SP.DISPLAY_NAME as NAME, (SELECT COUNT(CHILD_POOL.POOL_ID) FROM T_RES_STORAGE_POOL CHILD_POOL WHERE SP.POOL_ID=CHILD_POOL.PARENT_POOL_ID AND CHILD_POOL.DETECTABLE = 1) > at com.ibm.tpc.internal.api.services.impl.StorageSubsystemServiceIm pl.getStoragePools(StorageSubsystemServiceImpl.java:2405) Caused by: com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.65.7
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control or TPC 5.2.x users with SVC or Storwize * * storage. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * ****************************************************************
Problem conclusion
Expensive SQL queries were run for extracting history data. Those queries have been optimized to work well even when long periods were selected for performance reports. The fix for this APAR is targeted for the following maintenance package: | refresh pack | 5.2-TIV-TPC-RP0011 - target August 2016 Fixed in IBM Spectrum Control 5.2.11. 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 number
IT15268
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
525
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-13
Closed date
2016-08-02
Last modified date
2016-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
WebUI
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R527 PSY
UP
R528 PSY
UP
R529 PSY
UP
R52A 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":"525","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
22 February 2022