Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

openbsd and db2

Status
Not open for further replies.

Faroon

Programmer
Jun 16, 2003
46
CA
Hi everyone. I want to connect to a remote IBM DB2 database from my OpenBSD box. Is this possible? I know on the Linux platform you can do this using DB2-Client. If it's possible, then how do I do it? What software do I need besides perl's DBI::DB2?
 
Why don't you start with howto connect asking howtom remote connect to a remote IBM DB2. If you can telnet to it this should do the trick you can tellnet in OpenBSD.

But I'am not sure if this is what you wanted.

Be more specific and try asking it also on a IBM DB2 formum because I have no glue of howto clue anything to OpenBSD if i don't know what to glue it to.
 
Thanks for the reply. Everything's ok now. The fact is that I was able to connect to DB2 and do everything I want on the first day, using the DB2 client. But I had to labour myself for weeks on the forum because I want to find a free way to connect. Thanks to that now I realize that stupid IBM makes you buy the driver if you want to use their product. Most opensource softwares out there, iODBC, unixODBC, freeODBC, bridge this, connect that.. they all require the IBM driver to work, either the ODBC or the JDBC. In order to get these drivers you gotta pay, and that goes against all that I believed in, stood for, and will always live for. Unfortunately this is work, not personal use, so I will have to buy stupid IBM's software.

If this helps anybody, then i'll post it in case. The real IBM DB2 client does not work on *BSD environment, except FreeBSD. So for OpenBSD like mine, you would either have to emulate redhat 6.2, and then install db2 client v7.2- (7.2 and earlier). If you're lazy like myself, then you could just extract the db2jcc.jar file from a whole installed program, or just download it from the IBM website. That's the JDBC driver, which you can use Java to talk to and connect to a DB2 server. This is what I did. Note though that db2jcc.jar comes from a program that requires licensing, so there's no escape. I'm just pissed right now that i have to pay for the whole program just to use one file. Stupid IBM. Maybe i'll just change everything to redhat, and use the whole program.

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top