Edit the JT400 off-box properties file to enable encryption - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981
  1. On the Linux system running Connect CDC navigate to the kernel directory.

  2. 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
  3. 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)