DOMINO AND DB2

Installing Domino and DB2 on Microsoft Windows platforms
Complete this procedure to set up a new IBM® Lotus® Domino™ and IBM® DB2 Universal Database™ Enterprise Server Edition environment on Microsoft® Windows®. This is not a procedure for upgrading an existing Domino and DB2 configuration.

Setting up the Domino server environment for use with DB2

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

Installing and Setting up DB2

1. (MS Windows administrator) Create an installation user account.

2. ( DB2 Administrator logged on with Installation user account) Install DB2 on Microsoft Windows.

3. Restart the Domino server.

Setting up the DB2 server environment

1. (MS Windows administrator) Create a DB2 administrator account.

2. Determine whether you have a SYSCTRL group

3. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 does not have a SYSCTRL_GROUP, designate the DB2DOM group a system control group and add the Domino super user to the system control group

Enabling the Domino server to communicate with the DB2 server

1. (Domino administrator) Enable the Domino server to communicate with the DB2 server.

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) Setting up 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. 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. (Domino administrator) Restart the Domino server and the Domino Administrator.

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

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

See also