ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 200832

calendar_today

Updated On:

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

 

 

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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;