Data Refinery Job fails with an "TABLES in SYSCAT type *TABLE not found.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.23.42" error

Resolving The Problem

What';s Happening

You have created a data refinery job to work with connected data asset that is created from a Db2 for I or Db2 for Z connection. When you run the job, the job fails. When you view logs, it fails with the following error:

TABLES in SYSCAT type *TABLE not found.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.23.42

Why it';s Happening

This situation occurs when you use a plain Db2 connector for connecting to your Db2 for I or Db2 for Z instead of using the Db2 for I or Db2 for Z profile. The profile uses a specific connector that is designed for Db2 for I or Db2 for Z.

SQL Syntax and System tables are different for each type of Db2 so it is essential to select the correct connector.

How to Fix

You can change the source connection for the data flow. Create a new connection using Db2 for I or Db2 for Z, as appropriate.

After the connection is created, complete the following steps:

1. Open your data flow.
   
   
2. Click the arrows icon under Summary.
   
   
3. Select the appropriate source connection and source table or data set. See the following screen shot:
   

   

4. Click the Change Source.

As result of these steps, you can update your Data Refinery Job with a new source.