Java processes JWP and JCP do not start with IBM DB2.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The Java processes JWP and JCP do not start if the JDBC string contains additional IBM DB2 options.

U00003545 UCUDB: Opening database ...
U00003611 DB OPEN executed. Return Code = '-4461'
U00003590 UCUDB - DB error: '42815', '[jcc][10165][10036][4.24.92] Invalid database URL syntax: jdbc:db2://localhost:50000/UC4;progressiveStreaming=2. ERRORCODE=-4461, SQLSTATE=42815', '-4461', 'com.ibm.db2.jcc.am.SqlSyntaxErrorException'
U00032031 Error when connecting to Database

 

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Configuration.

Resolution

The [JDBC] connect string is in the wrong format.

sqlDriverConnect=jdbc:db2://localhost:50000/UC4,progressiveStreaming=2;
sqlDriverConnect=jdbc:db2://localhost:50000/UC4;progressiveStreaming=2;
sqlDriverConnect=jdbc:db2://localhost:50000/UC4:progressiveStreaming=2

The correct string is:

sqlDriverConnect=jdbc:db2://localhost:50000/UC4:progressiveStreaming=2;