Connecting to DB2 on OS/390 sans DB2 Connect?

theguvnor has asked for the wisdom of the Perl Monks concerning the following question:

Anyone know if it's possible to talk to a mainframe database (DB2 on OS/390) from the desktop (RedHat9) without installing DB2 Connect on the desktop and registering the datasource as a DSN with DB2 Connect?

I don't have enough room on the desktop to install DB2 Connect, and would like to avoid resizing any partitions if possible.

Ideas?

[Jon]

Comment on Connecting to DB2 on OS/390 sans DB2 Connect?

Replies are listed 'Best First'.
Re: Connecting to DB2 on OS/390 sans DB2 Connect? by dug (Chaplain) on Oct 27, 2003 at 18:58 UTC
I've done this using the iSeriesODBC driver supplied by IBM and then used DBD::ODBC on top of that. You'll need an ODBC driver manager as well, but I think RH9 comes with a good version of unixodbc, which was the driver manager I used.. -- dug	[reply]
Re: Re: Connecting to DB2 on OS/390 sans DB2 Connect? by theguvnor (Chaplain) on Oct 28, 2003 at 03:36 UTC
Thanks.. I'll investigate. It does seem a touch precarious though. [Jon]	[reply]
Re: Re: Re: Connecting to DB2 on OS/390 sans DB2 Connect? by dug (Chaplain) on Oct 28, 2003 at 13:19 UTC
It does seem a touch precarious though. It's not the native DRDA stream like the DB2Connect solution would be, but ODBC is pretty well known. IBM has support for the iSeriesODBC driver for Linux if that would give you an extra level of comfort. -- dug	[reply]

Back to Seekers of Perl Wisdom