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.