For connecting to DB 2 database, ETL Validator currently requires the hostname and port number. But some of the customers might be configured to use a ODBC DSN name. Here are the steps to find out the host name and port number for IBM DB2: 


The first task involves running the IBM DB2 command line processor to list the node directory. The steps below were taken from the post here: 

  1. On UNIX or Linux, navigate to the IBM DB2 Universal Database server or IBM DB2 Universal Database client sqllib directory, which is located in the IBM DB2 Universal Database instance owner user home directory. For example, on UNIX:

    cd /db2home/db2inst1/sqllib

  2. On UNIX or Linux, set the IBM DB2 Universal Database environment variables by sourcing the appropriate script:

    • For C shell:

      source db2cshrc

    • For Bourne or Korn shell:

      . db2profile

    If necessary, log in to the operating system as the IBM DB2 Universal Database instance owner. Logging in sets up all the IBM DB2 Universal Database environment variables.

    NoteOn Windows, the IBM DB2 Universal Database installation sets up all necessary environment variables.

  3. Start the IBM DB2 Universal Database command line processor (CLP).

    • On UNIX or Linux, enter the following command:

      db2

    • On Windows, select Start | Programs | IBM DB2 | Command Line Tools | Command Line Processor.

  4. Determine if the desired IBM DB2 Universal Database node has already been cataloged. At the CLP prompt, enter:

    list node directory


The node directory listing will give the host name and the SVCENAME (service name). SVCENAME is the port that DB2 is listening on. To resolve this name to an actual port number, you need to refer to the services file, which is located at %SystemRoot%\system32\drivers\etc\services