Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Dexter, MI
    Posts
    1

    Question Unanswered: DB2 Client Configuration File

    I am just getting started with DB2. I am interested in knowing what the configuration flat file is (if any) that stores all the connection information that is entered in the CCA utility. In Oracle, this file would be called tnsnames.ora.

    Thank you..

    Todd

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    Re: DB2 Client Configuration File

    Originally posted by toddtrues
    I am just getting started with DB2. I am interested in knowing what the configuration flat file is (if any) that stores all the connection information that is entered in the CCA utility. In Oracle, this file would be called tnsnames.ora.

    Thank you..

    Todd
    Tod,

    there is not a flat file with connetivity info like Oracle in DB2, most of the time you will have to configure your DB2 connect or java JDBC with information that your DBA will give you or in your case you will have to check your DB and DBM configuration parameters to find out.
    for example :
    if you are to use the CLI connection setup , use the Client configuration assistant to create a DSN name then if you are to use a java app against the database you can use the following parameters

    driver will be COM.ibm.db2.jdbc.app.DB2Driver
    jdbc:db2:<DSNName>

    my 2 cents

    marcos oliva

  3. #3
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    35
    To get similar info in "text" that tnsnames.ora would give you look at the following commands:

    db2 list node directory [show details]
    db2 list database directory [show details]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •