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
TDM Portal
Test data manager
Researching the TDM Documentation -
Supported Data Sources (broadcom.com)
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