Cloud Data Fusion - Error attempting connect to DB2 database

[Louie_P]

Hello

I have created a very basic pipeline to read data from a DB2 database and load that data into a csv file.

The following error is presented when I click, "GET SCHEMA" or run the pipeline

SQL error while getting query schema: [jcc][t4][10509][13454][4.27.25] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to the data server and using DB2 Connect Unlimited Edition for System z, perform the activation step by running the activation program in the license activation kit. If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968

Can anyone offer any insights?

[jarichard]

Hi Louie,   did you find a solution? We are having issues setting up a connection string from Data Fusion to on-prem IBM DB2 i series database. We set up the firewall rules, registered the driver, etc and are not making progress.