JWPs and JCPs do not start utilizing DB2.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

None of the Java Automation Engine processes (JWPs and JCPs) do start pointing to a DB2 database:

20210803/120620.383 - 24     U00045014 Exception 'java.sql.SQLException: "The required settings for DB2 are not met: DB2_EVALUNCOMMITTED=YES,DB2_SKIPDELETED=ON,DB2_SKIPINSERTED=ON"' at 'com.automic.database.impl.IBMExtension.checkRequirements():80'.
20210803/120620.384 - 24     U00003620 Routine 'com.automic.database.api.DBException' forces trace because of error.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Configuration.

Resolution

The DB2 parameter DB2_EVALUNCOMMITTED was set to ON instead of YES. 

[db2user@server ~]$ db2set -all
[i] DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON
[i] DB2_STANDBY_ISO=UR
[i] DB2_HADR_ROS=OFF
[i] DB2_ATS_ENABLE=YES
[i] DB2RSHCMD=/usr/bin/ssh
[i] DB2_SKIPINSERTED=ON
[i] DB2_OPTPROFILE=YES
[i] DB2_EVALUNCOMMITTED=ON
[i] DB2_SELECTIVITY=YES
[i] DB2_SKIPDELETED=ON
[i] DB2COMM=TCPIP
[i] DB2AUTOSTART=NO
[g] DB2SYSTEM=server.company.net

 

 

Additional Information

Preparing the AE Database - DB2