TDM Portal: Connection to mainframe cannot list schemas

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When trying to list Schema on the Register New Object (s) screen, the system displays the error "getSchemas_failed The server replied: [jcc] [10150] [10300] [3.69.66] Invalid parameter: Unknown column name TABLE_SCHEM. ERRORCODE = 4460 , SQLSTATE = null "

OR

When attempting to Scan a Data Model, no tables are returned. The TDMModelingService.log contains the following messages:

[date] [time] [INFO ] [ModellingEngine-DATADISCOVERY-jobId-[job id]] --- [U:][M:][P:]                      c.c.t.a.s.TDMAuditLogService:  insertLog: projectId: [proj id] versionId: [ver id] user: [USER] status: COMPLETED desc: Warnings: (1) Failed to scan entities for schema [SCHEMA] in profile [CONN PROF], reason: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.24.92] Invalid parameter: Unknown column name TABLE_NAME. ERRORCODE=-4460, SQLSTATE=null, (2) Could not find any tables to scan from connection profile [CONN PROF]
[date] [time] [INFO ] [ModellingEngine-DATADISCOVERY-jobId-[job id]] --- [U:][M:][P:]                              c.c.t.e.ConprofCache:  close: closing 1 connection profiles
[date] [time] [INFO ] [ModellingEngine-DATADISCOVERY-jobId-[job id]] --- [U:][M:][P:]                              c.c.t.e.ConprofCache:  close: closing connection profile [CONN PROF]
[date] [time] [INFO ] [ModellingEngine-DATADISCOVERY-jobId-[job id]] --- [U:][M:][P:]                           c.c.t.e.ModellingEngine:  shutdownThreadpool: job: [job id]:pool: modelling engine worker thread pool: cleaning up now
[date] [time] [INFO ] [pool-31-thread-1         ] --- [U:][M:][P:]                      c.c.t.e.ModellingJobProgress:  run: modelling engine progress thread:  shutting down: sending final notification for job: [job id] state: COMPLETED
[date] [time] [INFO ] [ModellingEngine-DATADISCOVERY-jobId-[job id]] --- [U:][M:][P:]                           c.c.t.e.ModellingEngine:  run: job: [job id]: scan errors: [Failed to scan entities for schema [SCHEMA] in profile [CONN PROF], reason: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.24.92] Invalid parameter: Unknown column name TABLE_NAME. ERRORCODE=-4460, SQLSTATE=null, Could not find any tables to scan from connection profile [CONN PROF]]

Environment

All supported TDM releases.

Resolution

1. Ensure that the JDBC version 4.0 or later driver is in use.
Reference:
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

2. Per IBM, add the "useJDBC4ColumnNameAndLabelSemantics=2" option to the connection string. In TDM Portal, this can be done via the "Additional connection properties" box on the Connection Profile.
Reference:
http://www-01.ibm.com/support/docview.wss?uid=swg21635332

3. Per IBM, the DESCSTAT=YES parameter for DB2 is required for full JDBC functionality.
Reference:
http://www-01.ibm.com/support/docview.wss?uid=swg21474042

4. Uncomment "#wrapper.lang=en_US" by removing the "#" from C:\Program Files\CA\CA Test Data Manager Portal\service\conf\wrapper.conf and recycle portal.
Reference:
https://wrapper.tanukisoftware.com/doc/english/props-lang.html#lang