You are currently reviewing an older revision of this page.

KB-XXXX DB2 Unknown column name TABLE_SCHEM

Symptoms

When attempting to create a new CDT object from an existing table in a DB2 database that has already been added as a datasource, the user will see a pink box containing the following error:

Invalid parameter: Unknown column name TABLE_SCHEM. ERRORCODE=-4460, SQLSTATE=null] (APNX-1-4198-000)

The user will not be able to create the CDT.

Cause

Use of DB2 on z/OS with the IBM JCC driver requires the DESCSTAT subsystem parameter value to be set to 'YES'. If this parameter is set to 'NO', the mapping tool will fail with a persistence exception containing this text: "Invalid parameter: Unknown column name TABLE_SCHEM".

Action

Set value of DESCSTAT to YES. The DB2 metadata tables must be recreated by running the DSNTIJMS job. See DB2 for z/OS documentation for additional information.

 

Affected Versions

This article applies to all versions of Appian using DB2 for z/OS.

Last Reviewed: March 2018