On Mon, 17 Jun 2002 15:46:40 -0400, Bill Verity <[log in to unmask]> wrote:

>Subject says it all.  Can I use DB2?  Developers Guide just mentions Oracle.
>We are running Listserv HPO on an AIX platform. We have a production DB2 service  but no Oracle.

The Developers Guide has not yet been re-written to reflect all updates for
1.8e.  But the Release Notes are clear and the answer is yes:

http://www.lsoft.com/manuals/1.8e/relnotes/v18e-mnt.html#db2

Usability: (unix) DB2 now supported as a DBMS datastore

LISTSERV 1.8e introduces CLI support for DB2 on AIX and other unix platforms on
which DB2 is supported.

In order to enable this support, a library flag must be specified at
compile/install time.  The correct library flag on AIX is -ldb2 , and this is
specified in the LISTSERV Makefile in the FLAGS_AIX= macro that resides below
the end of the normal "user customization area". By default the macro is blank,
so when set for DB2, it will look like this:

CFLAGS_AIX=-ldb2

Other unixes are configured similarly.

It is important to note that LISTSERV's DB2 support will work only if you have
carefully followed the DB2 installation guide and performed the
post-configuration tasks, in particular the task that creates links to /usr/lib
for the various libraries. If this is not done, DB2 will use default directories
with version-specific names to find the library, which L-Soft does not and will
not support. Should this problem arise you must simply create the links as
stated in the DB2 manual; if further information is necessary you must contact
IBM for DB2 support.

LISTSERV configuration for the use of the CLI driver is very similar to
configuration for use of the ODBC driver.  There are three site configuration
variables:

CLI_DSN=
CLI_UID=
CLI_AUTH=

which are configured in a similar manner to their ODBC counterparts.