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?
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.
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?