Test Data Manager

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  Error when trying to scan a DB2 Z/Os database in CA TDM Portail 4.7

    Posted 03-15-2019 02:07 PM

    Hello Community,

     

     

    Product :  CA TDM Portal 4.7, im trying to create the Model of à DB2 Z/Os ver.10 database. (Modeling / Data Model)

     

     

    The connection is working.  But when I try to "scan" the database, I receive this 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

     

    The bind of the packages on the DB2 Mainframe to set the parameter DESCSTAT=Y is done.

     

     



  • 2.  Re: Error when trying to scan a DB2 Z/Os database in CA TDM Portail 4.7
    Best Answer

    Posted 03-21-2019 11:39 AM

    Here is the 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