Test Data Manager

Expand all | Collapse all

FDM connecting error to DB2

Jump to Best Answer
  • 1.  FDM connecting error to DB2

    Posted 04-30-2018 11:55 PM

    Hello all,

     

    I am trying to do Db2 table masking.I have created a connection profile in FDM for Db2 and placed the all 4 jar files

    "db2jcc4.jar,

    db2jcc4_license_cu.jar,

    db2jcc4_license_cisuz.jar, and the common.jar files"  in "C:\Program Files\Grid-Tools\FastDataMasker\lib".But even after that i am getting this error.

    ----------------------------------------------------------

    ""

    [JCC][T4][10509][13454][4.14.111] CONNECTION TO THE DATA SERVER FAILED.
    THE IBM DATA SERVER FOR JDBC AND SQLJ LICENSE WAS INVALID
    OR WAS NOT
    ACTIVATED FOR THE DB2 FOR Z/OS SUBSYSTEM. IF YOU ARE CONNECTING DIRECTLY TO
    THE
    DATA SERVER AND USING DB2 CONNECT UNLIMITED EDITION FOR SYSTEM Z, PERFORM THE

    ACTIVATION STEP BY RUNNING THE ACTIVATION PROGRAM IN THE LICENSE ACTIVATION KIT. 

    IF YOU ARE USING ANY OTHER EDITION OF DB2 CONNECT, OBTAIN THE LICENSE FILE,

    DB2JCC_LICENSE_CISUZ.JAR, FROM THE LICENSE ACTIVATION KIT, AND FOLLOW THE INSTALLATION
    DIRECTIONS
    TO INCLUDE THE LICENSE FILE IN THE CLASS PATH. ERRORCODE=-4230,
    SQLSTATE=42968 SQLSTATE=42968

    """

    ---------------------------------------------------

    The previous TDE who installed the TDM tool has also installed the "DB2 Connect".But i don't know where it is.

     

    Right now i am using the server where the tool(Data Maker and FDM) installed.

     

    Please help me to find the "DB2 connect" version and the solution for this problem.

     

     

    Thanks,

    Arun



  • 2.  Re: FDM connecting error to DB2
    Best Answer

    Posted 05-03-2018 04:42 PM

    Arun,

     

    The licensing for the DB2 JDBC driver is handled by IBM.

     

    The DB2 Connect application is created, distributed and licensed by IBM.

     

    In order to get the properly licensed JDBC drivers for DB2, you will need to contact IBM for further assistance.

     

    Regards,

    Sean



  • 3.  Re: FDM connecting error to DB2

    Posted 05-08-2018 11:22 PM

    Thank you Sean..The drivers that i have  placed before are the older ones with same naming conventions.Now ,I got the right JDBC drivers and FDM is aslo working .