Error when trying to scan a DB2 Z/Os database in CA TDM Portal 4.7

book

Article ID: 129863

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction



I'm trying to create the Model of a DB2 Z/Os (version10.1) database in CA TDM 4.7 (Modeling / Data Model).

The bind of the packages on the DB2 Mainframe to set the parameter DESCSTAT=Y is done. Yet, we still have an issue.

The connection is working, but when we try to "scan" the database, we receive the following

error (1) job:1070 profile: DB2TEST: : failed to get metadata for conprof: DB2KTEST with exception: SqlException: [jcc][10150][10300][4.24.92] Invalid parameter: Unknown column name TABLE_SCHEM. ERRORCODE=-4460, SQLSTATE=null, (2) Failed to scan entities for profile DB2TEST, reason: TDMDatabaseException: job: 1070 profile: DB2TEST: : failed to get metadata for conprof: DB2TEST with exception: SqlException: [jcc][10150][10300][4.24.92] Invalid parameter: Unknown column name TABLE_SCHEM. ERRORCODE=-4460, SQLSTATE=null: Exception raised: TDMDatabaseException: job: 1070 profile: DB2TEST: : failed to get metadata for conprof: DB2TEST with exception: SqlException: [jcc][10150][10300][4.24.92] Invalid parameter: Unknown column name TABLE_SCHEM. ERRORCODE=-4460, SQLSTATE=null

Environment

Release:
Component: TDMWBP

Resolution

Researching the TDM Documentation - Supported Data Sources (https://docops.ca.com/ca-test-data-manager/4-7/en/installing/supported-data-sources#SupportedDataSources-DB2) Looking at the DB2 table I see Data Modeling and PII Audits are supported for DB2 versions 11, and 12 for Z/OS. DB2 10.1 Z/OS is not a supported Data Source.

However, the customer was able to provide a solution that worked for their Environment.

Their solution:
1) MAINFRAME : « BIND/REBIND » of the STORED PROCEDURE with zparms set to « DESCSTAT=YES ». 
List of the components that are affected:

- SYSIBM.SQLTABLES 
- SYSIBM.SQLPRIMARYKEYS 
- SYSIBM.SQLSTATISTICS 
- SYSIBM.SQLFOREIGNKEYS 
- SYSIBM.SQLCOLUMNS
- DSNATBLU. 

2) MAINFRAME : Execute the JOB DSNTIJMS
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/imjcc_t0024156.html