APAR status
Closed as program error.
Error description
When running zRES with ruleset trace enabled, sometimes the zRES will stop responding to incoming request. And log files reported Decision Warehouse table deadlock. Stacktrace as follows: ------ WARNING: An error occurred when executing the SQL query. com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000D01;00000473.00000141, DRIVER=3.72.30 at com.ibm.db2.jcc.am.hd.a(hd.java:816) ...... at com.ibm.db2.jcc.am.lp.kc(lp.java:793) at com.ibm.db2.jcc.am.lp.executeUpdate(lp.java:771) at ilog.rules.res.persistence.impl.jdbc.helper.IlrDatabaseUtility.e xecuteUpdate(IlrDatabaseUtility.java:106) at ilog.rules.res.persistence.trace.impl.jdbc.IlrTracesTable.callIn sertStatement(IlrTracesTable.java:156) at ilog.rules.res.persistence.trace.impl.jdbc.IlrTracesTable.insert (IlrTracesTable.java:96) at ilog.rules.res.persistence.trace.impl.jdbc.IlrGenericTraceDAO.sa veTrace(IlrGenericTraceDAO.java:157) at com.ibm.rules.hbr.dw.IlrAsyncDriverTraceDAO.persistTrace(IlrAsyn cDriverTraceDAO.java:110) at com.ibm.rules.hbr.dw.IlrAsyncDriverTraceWriter.insertFromQueue(I lrAsyncDriverTraceWriter.java:156) at com.ibm.rules.hbr.dw.IlrAsyncDriverTraceWriter.run(IlrAsyncDrive rTraceWriter.java:189) at java.lang.Thread.run(Thread.java:785) ------
Local fix
NA
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Decision Warehouse for ruleset tracing * **************************************************************** * PROBLEM DESCRIPTION: * * When running zRES with ruleset trace enabled (use of * * Decision Warehouse), sometimes the * * zRES will stop responding to incoming request. * * Log files report a Decision Warehouse table deadlock. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The DW persistance code has been enhanced to provide extra configuration parameters. These parameters allow changing how the Decision Warehouse persists its records.
Temporary fix
Comments
APAR Information
APAR number
PH06632
Reported component name
WS ODM FOR Z/OS
Reported component ID
5655Y1700
Reported release
812
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-18
Closed date
2019-06-03
Last modified date
2019-06-03
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
WS ODM FOR Z/OS
Fixed component ID
5655Y1700
Applicable component levels
R812 PSY
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"812","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 June 2019