DOMINO AND DB2

Installing Domino and DB2 on IBM AIX and Linux platforms
Installing and setting up the DB2 server

1. (IBM® AIX® or Linux® Admin) Create the DB2 installation user account.

2. (DB2 or IBM AIX or Linux admin logged on using installation user account) Install DB2 on IBM AIX.

Setting up the DB2 server environment

1. Create a DB2 administrator account.

2. (AIX or Linux Admin) From AIX or Linux OS or from the AIX or Linux administrator tool, create three primary groups.

3. (DB2 administrator) Determine whether your DB2 configuration already has a SYSCTRL_GROUP.

4. On the IBM® DB2 Universal Database™ Enterprise Server Edition server, log in using the Instance owner user account name and password. In a remote configuration, the IBM® Lotus® Domino® user account can be the same ID as the Instance owner's user ID.

5. Add the Domino server user account to the DB2DOM group or to whatever group you have designated as the SYSCTRL_GROUP.

6. (Instance owner)Update the DB2 configuration by entering these commands from the CLP window:


7. From AIX or Linux OS or from the AIX or Linux administrator tool, create three user accounts and add them to groups you created in step 2.

8. (DB2 Administrator) If your configuration includes a DB2 Run-Time Client, install the DB2 Run-Time Client on the computer on which you installed the Domino server.

9. Restart the Domino server.

10. DB2 administrator) Install IOCP on the same server on which you will install the DB2 Access server.

11. (Domino administrator) Restart the Domino server and the administrator client.

Setting up the Domino server environment

1. (Domino administrator) Install and set up the Domino server.

Enabling the Domino server to communicate with the DB2 server

1. (Domino administrator)From the Domino Administrator, run the DB2 Server Enablement Tool to enable the Domino server to communicate with DB2.

2. Grant the SETSESSIONUSER privilege to the Domino server user

3. If you are using a remote DB2 server, complete the steps in the topic Using a remote DB2 server with server enablement.

(Optional) Installing the DB2 Access server

Installing the DB2 Access server is optional. Determine whether you need to install it. The DB2 Access server is required for SQL access to Domino data which includes Query Views of Domino data, as well as any DB2-based application access to Domino data. Query Views of non-Domino data do NOT require the DB2 Access server.

1. (Domino administrator)Create a server ID for the DB2 Access server .

2. (Domino administrator)Install the DB2 Access server on the server running DB2

3. (Domino administrator) Enable the DB2 Access server.

4. (Domino administrator) To verify that the DB2 Access server is installed and configured properly, use the Test DB2 Access feature from the Domino Administrator client.

5. (DB2 administrator) Map the DB2 user name to a Notes user name

Verify your installation

Complete the AIX or Linux post-installation validation procedure.

As a final validation, create a database, and then verify that the database exists in DB2.

Related topics