Unable to connect to AS400(DB2) through Datastage

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Oct 16, 2012 8:30 pm

Hi Experts,

We are trying to connect to AS/400 through DB2 stage.But when we trying to test the connections;its giving below error.

Code: Select all

Unable to connect to server DEV_AS400.

We have open the ticket with IBM support and as per them we have to use ODBC to connect Datastage to DB2 on our AS/400. Is this true?

So in new version 8.7 we can't connect to AS/400 through DB2

In my last project(Version 7.5.1) we were able to connect to mainframes from Datastage through DB2 API stage.

Also when we login to i-series Navigator,where can we find instance name, because in import DB2 wizard we need to give Instance name...?

Appreciate all your help!!
Thanks in Advance!!

lstsaur · Post by **lstsaur** » Tue Oct 16, 2012 10:28 pm

Of course you can use the DB2 stage to connect to the AS400. The error message that you got indicates that your connection setup between the DataStage and the AS400 is not done correctly. You first need to do the Catalog TCPIP Node, Catalog Database and then define the ODBC DSN entry in .odbic.ini and uvodbc.config.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Oct 17, 2012 8:29 am

Thanks for the help.

Where can we add/find the Catalog TCPIP Node,Catalog Database ?
Appreciate all your help!

Thanks!!

rohitagarwal15 · Post by **rohitagarwal15** » Wed Oct 17, 2012 8:37 am

You can contact your Database team (AS400) they can help you out in catalogging of database and node also (TCP/IP).

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Oct 18, 2012 12:55 pm

Hi Experts,

After the discussion with IBM support team, we are planning to connect to i-series AS/400 thorugh odbc connection.

As per the IBM documents DB2EE and DB2-API stage are Deprecated stages.
We can't connect to i-series from db2 connector stage. So only option is odbc connection(where in we can do parallelly processing).

Thanks!!

Nagaraj · Post by **Nagaraj** » Thu Oct 18, 2012 2:09 pm

But are there drivers in DataDirect drivers for i-series/AS/400 in IBM Information Server list? I dont think so.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 18, 2012 8:32 pm

I'm quite surprised to hear that the DB2 Connector cannot be used to connect to DB2 on iSeries. I understood that that was one of the features of the Connector over the Enterprise stage. And you definitely can use the DB2 API stage to connect to DB2 on iSeries, albeit only in sequential mode. (The DB2 client on your DataStage server does require DB2 Connect to be installed.)