Direct links to fixes
APAR status
Closed as program error.
Error description
Aggregator job fails daily with SRV0084E and an SQL error. TPCUser.Aggregator*.log --------------------- STS0306I: Job queued for processing. Waiting for idle thread. STS0128I: Aggregator started STS0129I: Aggregating summary statistics... STS0130I: Aggregating filesystem statistics... STS0131I: Aggregating user space usage statistics... STS0132I: Aggregating group space usage statistics... STS0202I: Aggregating file type space usage statistics... STS0133I: Aggregating time distribution statistics... STS0134I: Aggregating disk capacity statistics... STS1054I: Aggregating disk system statistics... SRV0084E: SQL error. Unable to update T_RES_STORAGE_SUBSYSTEM SQLSTATE: 22003, Vendor error code: -413 DB2 SQL Error: SQLCODE=-413, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.19.49 STS0125E: Aggregator completed with errors. traceDataServer_x.log --------------------- [com.tivoli.itsrm.TStorm.server.svp.JobHndlr] [SQLUtil.getGeneralSQLException] [ERROR] DB2 SQL Error: SQLCODE=-413, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.19.49 com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-413, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.19.49 at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.fp.b(Unknown Source) at com.ibm.db2.jcc.am.fp.c(Unknown Source) at com.ibm.db2.jcc.t4.bb.l(Unknown Source) at com.ibm.db2.jcc.t4.bb.a(Unknown Source) at com.ibm.db2.jcc.t4.p.a(Unknown Source) at com.ibm.db2.jcc.t4.wb.b(Unknown Source) at com.ibm.db2.jcc.am.gp.tc(Unknown Source) at com.ibm.db2.jcc.am.gp.b(Unknown Source) at com.ibm.db2.jcc.am.gp.lc(Unknown Source) at com.ibm.db2.jcc.am.gp.executeUpdate(Unknown Source) at com.ibm.tpc.infrastructure.database.DBPreparedStatement.executeU pdate(DBPreparedStatement.java:117) at com.ibm.tpc.disk.discovery.SubsystemHist.setFilesystemRegression Data(SubsystemHist.java:1117) at com.ibm.tpc.disk.discovery.SubsystemHist.calcPrediction(Subsyste mHist.java:1032) at com.ibm.tpc.disk.discovery.SubsystemHist.aggregateHist(Subsystem Hist.java:800) at com.tivoli.itsrm.TStorm.server.svp.Aggregator.run(Aggregator.jav a:338) at com.tivoli.itsrm.TStorm.server.svp.JobHndlrThread.run(JobHndlrTh read.java:109) at java.lang.Thread.run(Thread.java:785)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control 5.2.x users monitoring * **************************************************************** * PROBLEM DESCRIPTION: * * Aggregator job does not run properly every day, and problem * * encountered while running the history aggregator. * * The query that updates the prediction data for filesystems * * was not correct, the formula was wrong. * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following release: IBM Spectrum Control 5.3.1 | 5.3.1-IBM-SC | Nov 2018 http://www.ibm.com/support/docview.wss?&uid=swg21320822
Temporary fix
Comments
APAR Information
APAR number
IT22712
Reported component name
TPC ADVANCED
Reported component ID
5608TPCA0
Reported release
52E
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-09
Closed date
2017-12-06
Last modified date
2019-01-08
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
[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSC6VJ","label":"IBM Spectrum Control Advanced Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"52E"}]
Document Information
Modified date:
04 September 2023