KB-1534 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 the persistence exception above.

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