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: