Skip to content

IBM InfoSphere DataStage: Test OBDC Connectivity

January 6, 2016

This post explains how to test ODBC connectivity to data sources.

How to Test

  1. Go to the directory $DSHOME.
  2. Source dsenv
      . ./dsenv
    
  3. Start the IBM InfoSphere Information Server engine shell.
    ./bin/dssh
    
  4. Log into the dstage1 project.
    DataStage Command Language 11.5 Licensed Materials - Property of IBM
    (c) Copyright IBM Corp. 1997, 2015 All Rights Reserved.
    DSEngine logged on: Tuesday, January 05, 2016 11:18
    
    >LOGTO dstage1
    
  5. List the available data sources.
    >Ds_CONNECT
    
    Data Source information from /opt/IBM/InformationServer/Server/Projects/dstage1/uvodbc.config:
    
    Data Source:       localuv
      DBMS Type:         UNIVERSE
      Network Type:      TCP/IP
      Host System:       localhost  127.0.0.1
      Service Name:      uvserver
    
    Data Source:       MySAPIqDb
      DBMS Type:         ODBC
    
    >
    
  6. Test the connection.
    >DS_CONNECT prodDwIqDb
    Enter username for connecting to 'prodDwIqDb' DBMS [root]: myDBuser
    Enter password for myDBuser:
    prodDwIqDb> select count(*) from sysobjects;
       count()
    ----------
          2504
    
    1 row selected
    prodDwIqDb> .Q
    Disconnecting from 'prodDwIqDb'
    >Q
    

References

IBM Knowledge Center. Testing ODBC driver connectivity. Retrieved from https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_Testing_ODBC_Driver_Connectivity.html

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: