Testing ODBC driver connectivity

After you configure ODBC connectivity that you defined for IBM® InfoSphere® DataStage®, test the configuration to verify your connection to the data source.

1. Change directories to the $DSHOME directory and set up the environment by running the following command:

   . ./dsenv
   

2. Enter the following command to start the IBM InfoSphere Information Server engine shell:

   ./bin/dssh
   

3. Enter the following command to log in to the project:

   LOGTO project_name
   

   where project_name is case-sensitive.
4. Enter the following command to obtain a list of available data source names:

   DS_CONNECT

5. Enter the following command to test the connection:

   DS_CONNECT dsn
   

   where dsn is the data source name of the connection to test.
6. Enter your user name and password to connect to the specified database.
7. Enter .Q to quit the connection.