I’ve searched the forum and tried the suggestions to no result. I’m trying to use the Notes 8 Administrator to configure Notes to DB2. Here is what I have installed…Windows 2003 Server with all updates and SP3 - 32bit.
Notes Domino Ver 8.0.1 - 32bit (date Feb. 7 2008)
DB2 Enterprise V. 9.1.0.356 - 32bit.
After I run Enable Server for DB2… from the administrator console and I restart the server - the following is what I get from the server console when I reboot.
Lotus Domino (r) Server, Release 8.0.1, February 07, 2008
Copyright (c) IBM Corporation 1987, 2008. All Rights Reserved.
Restart Analysis (0 MB): 100%
02/17/2009 01:47:34 PM
The ID file being used is: D:\Lotus\Domino\data\dfwnw001.id
Enter password (press the Esc key to abort):
02/17/2009 01:47:40 PM Attaching to DB2 Instance ‘db2’ with username 'administr
ator’…
02/17/2009 01:47:40 PM Creating DB2 database ‘DOMINO’ in DB2 Instance ‘db2’ wit
h username ‘administrator’…
02/17/2009 01:47:40 PM DB2NSFInit Error creating DB2 database DOMINO sqlcode=-1
005.: Failed creating DB2 Database.
02/17/2009 01:47:40 PM Unable to initialize DB2 services. DB2-based NSF databa
ses will be unusable.: Failed creating DB2 Database.
02/17/2009 01:47:41 PM A RM error occurred.: An error occurred accessing the db
2 datasource.
DB2 CONNECTION ERROR: Domino unable to connect to DB2 database ‘DOMINO’ as user
‘administrator’…
[IBM][CLI Driver] SQL1013N The database alias name or database name “DOMINO” co
uld not be found. SQLSTATE=42705
DB2 CONNECTION ERROR: set DEBUG_DB2CONNECT=0 to suppress this message.
02/17/2009 01:47:41 PM Unable to initialize DB2 services. DB2-based NSF databa
ses will be unusable.: An error occurred accessing the db2 datasource.
I setup a user id on the server called DominoDB2 and added it to the DB2DOM group. I added the group to the SYSCTRL_GROUP in DB2. I made sure the userid had all privledges to the SQLLIB directory for DB2. I tested creating a new DB2 database with this ID in DB2 and that works fine. I start the server using this Windows userID logged in… then start Notes. I have disabled the Notes service and started Notes as an application after adding that user to the DB2DOM group.
Any suggestions? I’m clueless at this point? Any help would greatly be appreciated.