Re: DataStage / DB2 data transfer
Hello Joe, I am facing simmilar problem. In my case it is connection from HP-UX to AS/400. I don't find any response to your problem. I've, actually, open call to IBM about this. Did you find anything more? I'll give you update from my side as well. Thank you, Peter DBA Brookfield, CT In article <8kd8rk$20fn$1@news.hal-pc.org>, "Milton J. Vidrine, Jr." <jvidrine@gardenridge.com> wrote: > I am trying to move data between DB2 UDB on AS/400 and Informix running on > Solaris using Data Stage ETL. > > I have been able to get that connection to work with Merant ODBC > client/server suite, but that solution is rather expensive. > > I have been told that this can also be accomplished with IBM's Client > Application > Enabler. I have downloaded the Version 6.1 of the runtime, but I can't get > it to connect. Here is what I have done so far on the client: > > 1) Set up the server in /etc/inet/hosts > 2) Set up a port in /etc/inet/services > 3) Uncompressed and un-tar-ed CAE > 4) Installed CAE using db2_install > 5) Run db2icrt > 6) Catalog-ed the tcpip node > 7) Catalog-ed the database > > However, "db2 connect to dbname" fails with SQLSTATE = 08001. This is a > rather generic error message telling me that I can't connect to the database > on the host. > > TCP/IP is running on the server. I have a hunch that there is some little > something I am missing or have not yet done. > > Does anyone have any ideas? Thanks In Advance. > > Joe Vidrine > DBA > Garden Ridge, Inc. > Houston, TX > > Sent via Deja.com http://www.deja.com/ Before you buy.
Hello, You might try using iODBC (www.iodbc.org) and using the IBM supplied drivers to get to your AS/400. You will need IBM DB2 Connect in order to do this. Here a sample DSN from an odbc.ini file that makes this connection (it contains the reference to the DB2 Connect library): [db2 on as400] UserName = xxxxxx Password = xxxxxx Description = AS400 ODBC Host = localhost Driver = /home/db2inst1/sqllib/lib/libdb2.so Database = <dbname> ReadOnly = No Regards, Stephen In article <8m4kb6$c93$1@nnrp1.deja.com>, kolda1@my-deja.com wrote: > Hello Joe, > I am facing simmilar problem. In my case it is connection from HP-UX to > AS/400. I don't find any response to your problem. > I've, actually, open call to IBM about this. Did you find anything more? > I'll give you update from my side as well. > Thank you, > Peter > DBA > Brookfield, CT > > In article <8kd8rk$20fn$1@news.hal-pc.org>, > "Milton J. Vidrine, Jr." <jvidrine@gardenridge.com> wrote: > > I am trying to move data between DB2 UDB on AS/400 and Informix > running on > > Solaris using Data Stage ETL. > > > > I have been able to get that connection to work with Merant ODBC > > client/server suite, but that solution is rather expensive. > > > > I have been told that this can also be accomplished with IBM's Client > > Application > > Enabler. I have downloaded the Version 6.1 of the runtime, but I > can't get > > it to connect. Here is what I have done so far on the client: > > > > 1) Set up the server in /etc/inet/hosts > > 2) Set up a port in /etc/inet/services > > 3) Uncompressed and un-tar-ed CAE > > 4) Installed CAE using db2_install > > 5) Run db2icrt > > 6) Catalog-ed the tcpip node > > 7) Catalog-ed the database > > > > However, "db2 connect to dbname" fails with SQLSTATE = 08001. This is > a > > rather generic error message telling me that I can't connect to the > database > > on the host. > > > > TCP/IP is running on the server. I have a hunch that there is some > little > > something I am missing or have not yet done. > > > > Does anyone have any ideas? Thanks In Advance. > > > > Joe Vidrine > > DBA > > Garden Ridge, Inc. > > Houston, TX > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.