DOMINO AND DB2

Installing and setting up Domino and DB2 and the DB2 Access server on Microsoft Windows - Local configuration
To enable Domino 7 with DB2, use the "DB2 key" that allows access to Domino 7 with DB2. For Microsoft Windows platforms, use NDB2KEY.DLL. Add the DB2 key to the default Domino Program directory C:\Program Files\Lotus\Domino.

For more information about the DB2 key, contact your IBM representative.

Complete this procedure to set up a new Domino and DB2 environment on Microsoft Windows. This is not a procedure for upgrading an existing Domino and DB2 configuration.

For information about whether you need to install the DB2 Access server, see the topic Installing the DB2 Access server on the DB2 server.

Procedure

1. Install and set up the Domino server and the Domino Administrator. For instructions, see Chapters 1 - 3 of Administering the Domino System, or see the Domino Administrator 7 Help.

2. When you start the Domino server, you are prompted to specify whether to run Domino as an application or a Windows service. Choose application.

3. Create an installation user account.

4. Install DB2 on Microsoft Windows.

5. Create a DB2 administrator account.

6. On the Domino server, permanently enable transaction logging.


For information about setting up transaction logging, see the topic Setting up a Domino server for transaction logging.

7. Create a server ID for the DB2 Access server.

8. Install the DB2 Access server on the server running DB2.

9. Enable the Domino server to communicate with the DB2 server.

10. After Domino has created the initial DB2 database, stop the Domino server.

11. Determine whether your DB2 configuration already has a SYSCTRL group by entering this command from the DB2 Command Line Processor (CLP):


12. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 configuration does not have a SYSCTRL_GROUP, set up DB2DOM as the SYSCTRL_GROUP in DB2 by entering this command from the DB2 CLP:
13. Update the DB2 configuration by entering these commands from the CLP:
14. Restart the Domino server and the Domino Administrator.

15. From the Domino server console, enter


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

17. Map the DB2 user name to a Notes user name.

You are now ready to create views.