DB2, Domino, and DB2NSF setup on a Windows operating system normally works without issue. However, setting up the environment on AIX can be sensitive and may cause problems if exact steps are not followed.
Attempting to install a DB2 and Domino setup using DALD "(Db2 Access for Lotus Domino) we faced the following problems:
1. Ensure that we use the exact path names as specified in the supplied documentation for:
a. AIX Users
b. AIX Groups
c. Domino Users involved
2. Following the exact sequence of Installation (example):
a. Domino Server
b. Db2 Server
c. DB2 Access for Lotus Domino
3. “Enable Server for Db2” is greyed out, as are all other options. If using “Menu > Configuration > DB2 Server > Enable Server for Db2”, this option is not greyed out. (Once the server is enabled, you should be able to see the remaining option as normal).
4. We were unable to make the system work on multiple machines. (Domino server on one LPAR and DB2 Server on the other LPAR).
The following error message is generated. The error is generic and it can be very difficult to diagnose the root cause.
[483416:00002-00001] 11.05.2009 17:24:46 Attaching to DB2 Instance
'lts27' with username 'db2inst2'...
[483416:00002-00001] 11.05.2009 17:24:46 Creating DB2 database
'DOMINO' in DB2 Instance 'lts27' with username 'db2inst2'...
[483416:00002-00001] 11.05.2009 17:25:59 DB2 database DOMINO
successfully created with codepage/territory (UTF-8/DE).
[483416:00002-00001] 11.05.2009 17:26:00 Warning: Modifying DB2
database manager configuration parameters for optimization...
[483416:00002-00001] 11.05.2009 17:26:00 Updating DB2 database
configuration parameters for optimization...
[483416:00002-00001] 11.05.2009 17:26:00 Routine invoked in improper
context.: An error occurred accessing the db2 datasource.
[483416:00002-00001] 11.05.2009 17:27:34 Routine invoked in improper
context.: An error occurred accessing the db2 datasource.
[483416:00002-00001] 11.05.2009 17:27:34 DB2NSFInit Error allocating
DB2 session.: DB2 CLI/SQL error
[483416:00002-00001] 11.05.2009 17:27:34 Unable to initialize DB2
services. DB2-based NSF databases will be unusable.: An error occurred
accessing the db2 datasource.
[528628:00002-00001] 11.05.2009 17:27:35 Routine invoked in improper
context.: An error occurred accessing the db2 datasource.
Ensure that you following the exact steps including Path names in the following file:
(See attached file: Installation steps for test setup of DALD on AIX.doc)
1. Ensure that we use the exact path names as specified in the supplied documentation for:
a. AIX Users
b. AIX Groups
c. Domino Users involved
2. Following the exact sequence of Installation (example):
a. Domino Server
b. Db2 Server
c. DB2 Access for Lotus Domino
3. The Model that we managed to get working is as follows and on the machine / LPAR.