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
In TPC WEB UI panel the Storage Resource Agent Deployment status can be stuck in a perpetual 'Deploying' state. i.e. Servers -> Servers Summary: Some db2 statements are not closing as expected, which generates following SQL Exceptions as noted below. Because of these exceptions the deployment job status could not be updated properly. i.e. ( seen in data/log/server*.log): com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH21E 0X5359534C564C3031, DRIVER=3.65.77 com.ibm.db2.jcc.am.cd.a(cd.java:701) com.ibm.db2.jcc.am.cd.a(cd.java:60) com.ibm.db2.jcc.am.cd.a(cd.java:127) com.ibm.db2.jcc.am.jo.c(jo.java:2753) com.ibm.db2.jcc.t4.ab.p(ab.java:872) com.ibm.db2.jcc.t4.ab.h(ab.java:144) com.ibm.db2.jcc.t4.ab.b(ab.java:41) com.ibm.db2.jcc.t4.p.a(p.java:32) com.ibm.db2.jcc.t4.qb.i(qb.java:135) com.ibm.db2.jcc.am.jo.gb(jo.java:2159) com.ibm.db2.jcc.am.jo.a(jo.java:3238) com.ibm.db2.jcc.am.jo.a(jo.java:691) com.ibm.db2.jcc.am.jo.executeQuery(jo.java:670) com.tivoli.itsrm.repository.TResAttr.getResourceIDAndType(TResAt tr.java:1342) com.tivoli.itsrm.scheduler.ScheduleComplete.notifyCEP(ScheduleCo mplete.java:786) com.tivoli.itsrm.scheduler.ScheduleComplete.process(ScheduleComp lete.java:588) com.tivoli.itsrm.scheduler.ScheduleHandler.handle(ScheduleHandle r.java:166) com.tivoli.itsrm.server.RequestManager$RmThread.run(RequestManag er.java:501 RECREATE STEPS: Launch Storage Resource Agent Deployment job and view status. ________________________________________________________________ DB2 Version used for Server: 10.1.FP5 The defect is against component: 5608TPC00 Server/Manager build/release (TPC): 5.2.8 Agent build/release (TPC): 5.2.8 Server/Manager (OS): WIN2008-R2 Agent (OS): ________________________________________________________________ Problem as described by customer: SRA Deployment job stuck. Initial customer impact (low/med/high): med
Local fix
Contact Support
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control or TPC 5.2.x users deleting a large * * number of servers. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * **************************************************************** DB2 statements left open when processing deletion of servers.
Problem conclusion
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
IT15192
Reported component name
TPC ADVANCED
Reported component ID
5608TPCA0
Reported release
511
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
DATA
Fix information
Fixed component name
TPC ADVANCED
Fixed component ID
5608TPCA0
Applicable component levels
R526 PSY
UP
R527 PSY
UP
R528 PSY
UP
R529 PSY
UP
Document Information
Modified date:
22 February 2022