My Oracle Support Banner

"unknown column name TABLE_NAME" Or SQL0443N Message Signaled On ODI Reverse Engineering Of OS/390, z/OS Or AIX DB2 UDB Tables (Doc ID 424332.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


One of the following messages is signaled when processing a standard reverse engineering of DB2 Universal Database (DB2 UDB) tables with Oracle Data Integrator (ODI): 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Set the DB2 system parameter DESCSTAT to YES
 2. On OS/390, activate the RSU0512 IBM Consolidated Service Test
 3. Add the standard stored procedures and views required by the JDBC driver to retrieve catalog/schema-based metadata
 4. The ODBC/JDBC Stored Procedures and DB2 Objects might need to be dropped and recreated
 5. Bind the "db2schema.bnd" file against each database

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.