Creating Connection from DS client to a DB2 Database

abzthemanc · Post by **abzthemanc** » Mon Apr 30, 2012 10:07 am

Hi All,

New here and hoping for a little help, and hope to contribute myself in the future!

We have Infosphere (Datastage) 8.7 installed on a RedHat Linux Server (64bit), this included, the Engine Tier and Services Tier.

On a separate server we have installed DB2 9.7 (also RedHat Linux 64bit), within this DB2 install we have created an instance where XMETA (used as Metadata Repository Tier) will be stored.

The (silent) install for Infosphere completed successfully with the XMETA DB created prior to install on the DB2 server. We also intend to use the same DB2 server to hold our target database, where data will be loaded. We have a DB created but I do not know how to create the connection from my Datastage windows client to the DB2 server.

I have the necessary connection details for the server but fail to connect.

I have read the help files etc but dont know for certain what to do. In all the examples they give, the target DB is on the same server as the Engine Tier, where as in our setup its different..

So, to get to the point my questions are:

1a - On the Linux server where Infosphere Server is installed (Engine + Services Tier), do I also need to install some sort of DB2 client??
Or do I merely need to configure some files on the server?

1b - If I need to configure some files on the server, where do I do this? on the DS server? which files? what entries?

2 - Can I make a connection to the target DB directly from the Datastage client, without doing any config on the server?

Apologies in advance for the big dump of info, but any help would be greatly apprecated!!

qt_ky · Post by **qt_ky** » Mon Apr 30, 2012 7:05 pm

Hopefully this help answer one question... When you execute DataStage jobs, they execute from the server (engine tier), so you don't need a database connection from your client tier (Windows) for jobs to execute. A database connection from your client will still be useful to check database results with, outside of DataStage. You can install a DB2 client or use ODBC.

abzthemanc · Post by **abzthemanc** » Tue May 01, 2012 7:15 am

Thanks for the info!

As we are currently in development, we would be running some jobs from the client (for test purposes). I do have DB2 client on my laptop with connection to the DB so this is ok.

I am currently connecting with an ODBC connector from within Datastage and all seems to be working well from my client, however still unsure what I need need to do on the Engine server.

How do I get the connection on the Engine server for a DB which is on a different server?

ray.wurlod · Post by **ray.wurlod** » Tue May 01, 2012 4:05 pm

ODBC connectivity from a UNIX/Linux server is established by editing

the .odbc.ini file in the DSEngine directory

the uvodbc.config file in the project

Full information is to be found in the various Connectivity Guides in the manual set.

If you don't have manuals ready to hand you can also get the information from the IBM Information Center