When customer upgrading DB2 version from 10 to 11 they were unable to introspect due to unknown column error ‘TABLE_CAT’ and few other columns.

 

Error

DEBUG [GetIntrospectableResourceIdsTask Get Introspectable Resource Identifiers] 2018-04-18 15:37:15.574 +0900 AbstractIntrospector2 - Fetching introspectable children of: / [DATA_SOURCE/RELATIONAL_DATA_SOURCE] Recurse: true Parallelism: 4

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.703 +0900 JdbcIntrospector2 - Column Name: 1

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.703 +0900 JdbcIntrospector2 - Column Name: 2

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.703 +0900 JdbcIntrospector2 - Column Name: 3

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.703 +0900 JdbcIntrospector2 - Column Name: 4

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 5

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 6

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 7

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 8

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 9

INFO [introspect-resourceids-100679-1] 2018-04-18 15:37:15.704 +0900 JdbcIntrospector2 - Column Name: 10

WARN [introspect-resourceids-100679-1] 2018-04-18 15:37:15.731 +0900 Introspector2Wrapper - Failed to introspectable children of 'null'

com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10150][10300] Invalid parameter: Unknown column name TABLE_CAT.

  at com.ibm.db2.jcc.b.z.a(z.java:1361)

Steps to Resolve

1. Stop TDV server

2. Remove csmodule_datasource.jar-0602 jar

3. Keep original csmodule_datasource.jar which came with installation

4. Add below properties to db2_mainframe.capabilities under <ROOT>D:\apps\dlm\cis_ds_db2_mainframe\conf

introspect.table.table_cat: 1

introspect.table.table_schem: 2

introspect.table.table_name: 3

introspect.table.table_type: 4

introspect.table.remarks: 5

5. Save the file

6. Start TDV server