-
On the Linux system running Connect CDC navigate to the kernel directory.
-
Edit the JT400offbox.properties file. Change the following line.
From:url=jdbc:as400://%SERVER;database name=%DATABASE;block size=128;date format=iso;time format=hms;time separator=:;prompt=false;translate binary=true.
To:url=jdbc:as400://%SERVER;database name=%DATABASE;block size=128;secure=true;date format=iso;time format=hms;time separator=:;prompt=false;translate binary=true
-
Stop and restart the Connect CDC kernel process for any replication models running on this Linux host system.
When the kernel is restarted you will see the following in the kernel log validating that a secure connection via JDBC has been made.
Example:
Server:LTIAS03 (10); Type=db2400, Name=LTIAS03, URL=jdbc:as400://LTIAS03;database name=*SYSBAS;block size=128;secure=true;date format=iso;time format=hms;time separator=:;prompt=false;translate binary=true, V3Shadow server? = false, Always Use triggers? = false
Metabase Information: Schema: CONNECTMB; Catalog ; Database type: db2400; Database version: 07.03.0000 V7R3m0;
Users defined=QAREP1
Database Information: Library Name: CONNECT58; DBMS Process Information: Process Name: QAUSER1/QSQJRN; Configuration file name: RPCS400_01; is CS? = true; is JM? = false; Message Name: CS1;
Example of Change Retriever connection validating SSL JDBC port and SSL connection job:
2018-03-01 13:33:04,973 [ChangeRetriever5-R6] INFO:Connecting to i5 service assigned to job 547583/QUSER/QZDASSINIT via port(9471)