Connectivity to AS/400 System

ksmurthys · Post by **ksmurthys** » Thu Sep 30, 2004 7:50 am

Hi all,

Is there any way i can conncet to AS/400 using datastage ODBC satge? If possible pls let me know how to connect(what r all parameters we set).

Thanks,
Ram.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 30, 2004 4:46 pm

There's nothing special about DataStage.
You configure the ODBC driver information exactly the same way that you would for any other ODBC client.

ashcar · Post by **ashcar** » Thu Sep 30, 2004 5:12 pm

ray.wurlod wrote:There's nothing special about DataStage.
You configure the ODBC driver information exactly the same way that you would for any other ODBC client.

this is a different question ...
but how do i make connection to db2 on AS400 with datastage on windows server
bcos i cannot initialize the db2 plugin for importing metadata and using the db2 stage

s_r_chandru · Post by **s_r_chandru** » Fri Oct 01, 2004 3:24 am

Hi,
First you need to to Install Db2 Connect(Which Communicates to AS400).After that you have to Catalog your Database
Following is the Syntax to do it:
1.CATALOG TCPIP NODE <yournodename> REMOTE <IpaddressofAS400> SERVER <portnumberofserver>
2.CATALOG DB <databasename> AS <databasealiasname> AT NODE <yournodename>
Once this is Done you can view you cataloged Database connection in your Db2 Metadata Plugin
-Chandru

ashcar · Post by **ashcar** » Fri Oct 01, 2004 7:12 am

my customer does not have db2 connect ....and i read in ascential db2 plugin doc that client application enabler has to be installed ...can u tell me if i need db2 connect also after CAE

Mike · Post by **Mike** » Fri Oct 01, 2004 7:28 am

I think DB2 Connect is the middleware that provides the CAE. If your client isn't willing to buy DB2 Connect, you will have to use ODBC to access DB2, and the wire protocol drivers supplied with DataStage would probably be your best choice.

Mike

shawn_ramsey · Post by **shawn_ramsey** » Fri Oct 01, 2004 8:19 am

We are using the IBM iSeries Access for Windows software. From what the AS/400 folks have told me comes with the AS/400 OS installation. On that disk there are several free components, one of them being the ODBC and OLEDB drivers. I am not an expert on the AS/400 but I believe that there is also a subsystem (service) on the AS/400 that needs to be configured.

ksmurthys · Post by **ksmurthys** » Tue Oct 05, 2004 8:15 am

Hi,
We created ODBC DSN for AS/400 system on datastage server,I tried to connect AS/400 by using this DSN i am getting the following error:
DSR.MetaGeta: Cannot read result file DS_METATEMP record METAGETA-4584 from GetMetaData.Could anybody know what that error means??

Thanks,
Ram.

shiv_nm · Post by **shiv_nm** » Tue Oct 05, 2004 11:17 pm

Hi,
As per my knowledge you can install IBM i-Series what ever the version is, then you will get 32-bit ODBC Driver with it. Go to Administrator tools in setting control pannel and create a new system DSN using this 32 -bit driver.
Parameters are IP address, user name and password and Library list.

hope this will help for you.

gud luck
Shiv

lpadrta · Post by **lpadrta** » Fri Oct 08, 2004 9:38 am

The IBM iSeries Access for Windows (previously called Client Access) software must be installed on the iSeries and on the DataStage Server. There is a package for each and the versions need to agree. Your local iSeries support team should be able to help with that.

Once the IBM iSeries Access for Windows is installed on your DataStage server, you can go to ODBC adminstration on the server and set up a named ODBC connection, and usually default values will work OK to get you hooked up.

Then set up the job using the source/target for the ODBC name you gave it on the server. Should be pretty straightforward from there.

Nagaraj · Post by **Nagaraj** » Fri Sep 17, 2010 8:42 am

Can any body please confirm,

Do i have to install the iseries access software on the Datastage Server(Unix) but the name says "iseries access for windows" ,
Just the ODBC way would do to connect to iseries access on datastage.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 17, 2010 2:52 pm

The original question had DataStage server installed on Windows, therefore iSeries for Windows was the correct client. It would not be appropriate to install this client on a UNIX server. But there is certain to be some other client component (such as DB2 Connect) that you could use. The ODBC driver for DB2 (from Data Direct) that ships with DataStage should then be able to connect to the iSeries from UNIX.

ppgoml · Post by **ppgoml** » Fri Jan 21, 2011 1:59 am

Nagaraj wrote:Can any body please confirm,

Do i have to install the iseries access software on the Datastage Server(Unix) but the name says "iseries access for windows" ,
Just the ODBC way would do to connect to iseries access on datastage.

There is an unix version of iseries access for odbc, but I am not sure if it is compatible with DataDirect ODBC driver manager. I am sure that it's compatible with unixODBC driver manager. Datastage could work with other odbc driver managers besides DataDirect. so theoretically, we can use iseries access for odbc to access as400 db2 with datastage. I havn't got a chance to have a try yet, and you need to verify it yourself.

rameshrr3 · Post by **rameshrr3** » Fri Jan 28, 2011 2:49 pm

yes install the odbc drivers on datastage server . The iSeries Client is optional.

I connect to As/400 using either ODBC or OLE-DB providers, since we dont really have a license for DB2 Connect

Nagaraj · Post by **Nagaraj** » Fri Jan 28, 2011 7:12 pm

what do you mean " install the odbc drivers on datastage server "

>>> The ODBC drivers gets installed when you do the IS 8.1 install on the server,correct?

do i have to install separate ODBC drivers.

DSXchange

Connectivity to AS/400 System

Connectivity to AS/400 System

Install IBM i-Series in client pc for 32-bit ODBC driver