Super! I thought I had read it somewhere. Is this an extra cost item? Seems that it is not. Just checking. >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. -- BE ALERT!!!! (The world needs more lerts ...) Bill Verity - 814-865-4758 Fax: 814-863-7049 215A Computer Building - Information Technology Services, Penn State University At the office - on my Mac, of course ;-)