Domino 6 and DB2

Hi

I found out that it’s possible to Create a Lotus Notes application to access DB2 using Domino Designer: IBM Db2

However, can someone guide me as to what components to download? IBM provides a list of things to download for DB2: Administration Client, Enterprise Client, etc. Do I download all? Or is there any specific components to download only?

Pls help

Thks

Rusyinni

Subject: Domino 6 and DB2

Hi,

what do you want to do ?? just get data from db2 Table ?

greets

bernhard

Subject: RE: Domino 6 and DB2

Hi

Yes, I want to try and compare the difference between using DB2 and NSF

Pls guide me along.

Thanks

Subject: RE: Domino 6 and DB2

Slightly puzzled, why you answer “yes” and then state, that you want to compare NSF to DB2.

Just to clarify this: Domino 8 has native support for storing Notes data directly into DB2. The same technology has been available for Domino 7, but without general support. In Domino 6.x there is no such thing.

If your idea is to save all the contents of Notes documents into DB2 instead of an NSF file, simply forget about it. It doesn’t make any sense. The different ways of reading from and writing to DB2 in Domino 6 (like DECS, LEI, native LS connector, ODBC) are meant for integrating Domino data - stored in an NSF - with enterprise data stored in DB2, not as a replacement for NSF.

Subject: RE: Domino 6 and DB2

Hi

I know that only Domino 7 and 8 supports DB2. According to the article link I posted, it’s possible for Domino 6 to connect to DB2.

Anyway, I’ve tried and it works.

And I just downloaded DB2 UDB Express Edition, and install it at the same location as my Domino server.

Subject: RE: Domino 6 and DB2

Domino 6 running a web application. When a form submits I need to update a table in db2. I have code already but I need to know how to setup the connection between the Domino server and db2? What do I need to install on the Domino server so that a database on that server can connect to db2 on another server?