Test Data Manager

  • Private Community

  • 1.  Error message while creating connection profile to connect with DB2

    Posted Jan 23, 2018 03:27 PM

    Hi team,

     

    I am getting below error message while configuring a profile to access DB2

     

    Cannot connect using supplied values.

    Connection:
    Profile: profile_name
    odbc: -30061
    SQLSTATE = 08004
    [IBM][CLI Driver] SQL30061N  The database alias or database name "***            " was not found at the remote node.  SQLSTATE=08004

    Could you please help?

     

    Many thanks

    Abhijeet kadam



  • 2.  Re: Error message while creating connection profile to connect with DB2

    Broadcom Employee
    Posted Jan 23, 2018 03:44 PM

    Are you able to successfully establish an odbc connection from the machine to your DB2 database?



  • 3.  Re: Error message while creating connection profile to connect with DB2

    Posted Jan 24, 2018 01:04 PM

    Yes Anil, I am able to ping the system with the host name that is entered.



  • 4.  Re: Error message while creating connection profile to connect with DB2

    Posted Jan 24, 2018 08:59 AM

    Hi Abhijeet, can you please open a support case and/or provide answers to the questions below? Contact CA Support - CA Technologies 

     



  • 5.  Re: Error message while creating connection profile to connect with DB2

    Posted Jan 24, 2018 01:18 PM

    Thank you for the response Taylor. Response as below:-

    • We are experiencing the issue in both Datamaker & portal. however we are concerned about datamaker as we would be using data maker.
    • I am able to ping the system using the host name, and we are able to connect to the DB2 instance.
    • Yes we are using IBM Z series version.
    • we have followed all the intructions.
    • the format of DB name is all text. ( TTTTTTT)
    • we have being told by the DBA that the given port number will be used by multiple application teams so we are not sure how that works..

    I guess the problem is with the last point i.e. the port number. we are using teh DB2 connection port number. Also can this be a issue with DB2 drivers?



  • 6.  Re: Error message while creating connection profile to connect with DB2
    Best Answer

    Posted Jan 24, 2018 01:37 PM

    Hi Abhijeet, 

     

    Typically this error message is caused by the port number being used by other applications, so that might be worth looking into with your DBA again.

     

    Usually if it is an issue with the driver, the error message will specifically say so, but here are the drivers you will need and where to place them: Notes on Implementation with Specific Data Sources - CA Test Data Manager - 4.4 - CA Technologies Documentation 

     

    You can also enable debugging for both Datamaker and Portal in case there is a more specific error message in the logs.

    Datamaker instructions: https://support.ca.com/us/knowledge-base-articles.TEC1645916.html 

    Portal instructions: https://support.ca.com/us/knowledge-base-articles.TEC1254734.html 

    IBM DB2 11 for z/OS

    Download the file Common.jar from the vendor and place it in the following folders:

    • CA TDM Datamaker
      C:\Program Files (x86)\Grid-Tools\GTDatamaker\dplib\
    • CA TDM Portal
      C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

    If you are using CA TDM version 3.2.1 or later, replace db2jcc.jar file with db2jcc4.jar file.

    • If both db2jcc.jar and db2jcc4.jar files are present, DB2 will default to the older db2jcc.jar.
    • The older driver only works with Java 1.7 and below.

    If you are using CA TDM version 3.2 or earlier, ensure db2jcc.jar file is available at the below path:

    • CA TDM Datamaker
      C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
    • CA TDM Portal
      C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

    For masking, ensure that the db2jcc4.jar, db2jcc4_license_cu.jar, and db2jcc4_license_cisuz.jar files are available at the following location:

    • C:\Program Files\Grid-Tools\FastDataMasker\lib\

    For subsetting, ensure that the jt400.jar file is available at the following location:

    • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\

    For CA TDM Portal, ensure that the jt400.jar file is available at the following location:

    • C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

    Run the db2licm command from the command prompt to apply the license as follows:

    db2licm -a "C:\Users\Username\Desktop\10.5_DB2ConnectEE_License\db2consv_ee.lic"

    Note: Ensure that the license file path is local and does not point to a network drive.

    IBM DB2400 iSeries V7R1

    For masking, ensure that the jt400.jar file is available at the following location:

    • C:\Program Files\Grid-Tools\FastDataMasker\lib\

    For subsetting, ensure that the jt400.jar file is available at the following location:

    • C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\

    For CA TDM Portal, ensure that the jt400.jar file is available at the following location:

    • C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers


  • 7.  Re: Error message while creating connection profile to connect with DB2

    Broadcom Employee
    Posted Jan 24, 2018 03:00 PM

    I would suggest you check the DB2 drivers by creating a ODBC connection outside of TDM to validate and see if you can establish a connection to the database. This will tell you if there are connection issues, once this is resolved, you can proceed to try the connection using TDM with the same parameters.

     

    IBM Knowledge Center 



  • 8.  Re: Error message while creating connection profile to connect with DB2

    Posted Jan 25, 2018 08:35 AM

    Hi Abhijeet, if you are still having issues, please open a support case by going to Contact CA Support - CA Technologies.