The DB2 Access Server (or UDF, or DALD), is a separate piece
of software that you can install on top of Domino that allows for Domino
to be able to perform SQL queries on NSF databases housed in DB2. The
DB2 Access Server software actually is a mini-Domino server installation.
It contains a names.nsf, notes.ini, etc. There are a few things
to take note of with the DB2 Access Server:
- If you have DB2 installed on a different machine than
Domino, the DB2 Access Server must be installed on the same machine that
DB2 is installed on.
- The address book that the DB2 Access Server uses (names.nsf)
contains the connection information from itself to the Domino server. (When
you click on "Edit DB2 Access Connection", all that does is open
the connection document in the DB2 Access Servers names.nsf). If
you are having trouble getting from the Domino server to the DB2 Access
Server, or vice versa, edit this connection document to have the optional
IP address to help with networking problems.
- If you are having problems with the DB2 Access Server
crashing (i.e. your SQL error references "abnormal termination"),
or there are performance issues with query views, you can run NSD for the
DB2 Access Server. NSD is not installed by default with R8 (it will
be with 8.5), so if you want to use NSD, you must copy it over from the
Domino program directory to the DB2 Access Server program directory.
- If you are having problems with query views, or the DB2
Access Server in general, there is debug available to help determine the
cause of the problem. You can place the following into the DB2 Access
The + at the end of the line is required!