Datastage ODBC Connection Problems - Part 1

Test ODBC Driver Connectivity in Datastage :DK®

You can test the whether your ODBC drivers can successfully connect to your data sources or not. This post give you details, How you can identify the issue.DK®

Problem Details :DK®

If a job fails to connect to a data source using an ODBC connection, test the connection outside the job to see if the ODBC connection is the source of the problem. The procedure applies to ODBC connections in a UNIX environment.DK®

Checking the problem and Solution :DK®

To test the connectivity of your ODBC connections:DK®

1. Change directory to $DSHOME and set up the IBM InfoSphere DataStage environment by running dsenv:DK®

   . ./dsenv

2. Start the engine shell:

   ./bin/dssh

3. In the engine shell, log to the project:

   LOGTO project_name

4. Get a list of available DSNs by typing:

   DS_CONNECT

5. Test the required connection by typing:

   DS_CONNECT DSN

   Where DSN specifies the connection that you want to test.
6. Enter the user name and password to connect to the required data source.DK®
7. After you have connected to the data source, enter .Q to close the connection.DK®