DSXchange

Posted: **Thu Oct 11, 2007 11:23 am**

Background - We do not have a DataStage Administrator and would like some pointers on how to establish a odbc connection to a DB2 database and also a few related questions.
1) Does the remote database need to be cataloged on the ETL server?
2) What does cataloging do on the ETL server?
3) Does cataloging help only with the db2connect? or does it help with establishing an ODBC connect?
4) Can I use the DB2_UDB_Enterprise stage in DS to connect to the database instead of the ODBC stage? How can I determine what stage to use and how can I set up DataStage.
5) How does db2connect make a connection to the remote server (does it use the odbc driver)?
5) In the odbc.ini file, when datasources are being defined, can the userid/password be omitted and passed during job execution and can they be passed-in as a project variable.

Thanks for your time.
Suresh

Posted: **Thu Oct 11, 2007 3:01 pm**

There is a PDF document available from your support provider that goes deeply into the intricacies of setting up DB2 access for DataStage. I suggest that you ask for it. It answers all your questions.

Posted: **Fri Oct 26, 2007 10:25 pm**

suresh_k wrote:Background - We do not have a DataStage Administrator and would like some pointers on how to establish a odbc connection to a DB2 database and also a few related questions.
1) Does the remote database need to be cataloged on the ETL server?
no
2) What does cataloging do on the ETL server?
catalog configures client to connect to server , just like tnsnames.ora

3) Does cataloging help only with the db2connect? or does it help with
establishing an ODBC connect?
db2 connect not odbc

4) Can I use the DB2_UDB_Enterprise stage in DS to connect to the database instead of the ODBC stage? How can I determine what stage to use and how can I set up DataStage.
db2 api and odbc can be used to connect to db2@zOS
to connect to db2 udb u can use any of those

5) How does db2connect make a connection to the remote server (does it use the odbc driver)?
no it uses db2 client drivers that you need to install

5) In the odbc.ini file, when datasources are being defined, can the userid/password be omitted and passed during job execution and can they be passed-in as a project variable.

yes you have to do that

Thanks for your time.
Suresh

Posted: **Sun Dec 09, 2007 1:08 am**

Thanks for the input.

DSXchange

Making an ODBC connection to a db2 database

Making an ODBC connection to a db2 database

Re: Making an ODBC connection to a db2 database