Page 1 of 2
Connectivity to AS/400 System
Posted: Thu Sep 30, 2004 7:50 am
by ksmurthys
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.
Posted: Thu Sep 30, 2004 4:46 pm
by ray.wurlod
There's nothing special about DataStage.
You configure the ODBC driver information exactly the same way that you would for any other ODBC client.
Posted: Thu Sep 30, 2004 5:12 pm
by ashcar
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
Posted: Fri Oct 01, 2004 3:24 am
by s_r_chandru
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
Posted: Fri Oct 01, 2004 7:12 am
by ashcar
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
Posted: Fri Oct 01, 2004 7:28 am
by Mike
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
Posted: Fri Oct 01, 2004 8:19 am
by shawn_ramsey
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.
Posted: Tue Oct 05, 2004 8:15 am
by ksmurthys
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.
Install IBM i-Series in client pc for 32-bit ODBC driver
Posted: Tue Oct 05, 2004 11:17 pm
by shiv_nm
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
Posted: Fri Oct 08, 2004 9:38 am
by lpadrta
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.
Posted: Fri Sep 17, 2010 8:42 am
by Nagaraj
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.
Posted: Fri Sep 17, 2010 2:52 pm
by ray.wurlod
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.
Posted: Fri Jan 21, 2011 1:59 am
by ppgoml
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.
Posted: Fri Jan 28, 2011 2:49 pm
by rameshrr3
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
Posted: Fri Jan 28, 2011 7:12 pm
by Nagaraj
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.