DOMINO AND DB2

Enabling Domino access to a DB2 server
Use the DB2 Server Enablement Tool, available from the Domino Administrator client, to automatically enable Domino to access a DB2 server. Or, you can manually enable Domino to access a DB2 server. When you enable a Domino server for DB2, Domino stores its Notes data in DB2. When a Notes database is enabled for DB2, Domino creates a DB2 database schema for it, as well as a set of tables in that schema to hold the Notes database data. The schema name is based on the NSF file name.

The DB2 Server Enablement Tool is the recommended method of enabling Domino access to a DB2 server. The DB2 Server Enablement Tool does the following:

The administration process posts an administration request in the local copy of the Administration Requests database (ADMIN4.NSF). The replicator then replicates ADMIN4.NSF to the administration server. The administration process on the administration server processes the administration request and updates the Server document with the new information. The replicator then replicates the changes to the Server document on the originating server.

The Domino server user name and password are stored in the Domino server's ID file. The Domino server user account enables Domino to access a DB2 server. Create one Domino server user account for each Domino server.

Note If you are using Microsoft Windows and you have already created a system control group to which you want to add the Domino server user, add the Domino server user to that group.

After creating the Domino server user account, create a Domino server user group named DB2DOM and add the Domino server user to that group. You must then manually define DB2DOM as a system control group in DB2. The system control group parameter assigns system control (SYSCTRL) authority to the group name. The Domino server user account is a member of the DB2DOM group that has SYSCTRL authority; and as such, the Domino server user account has the right to allow Domino to access the DB2 server. The Domino server user has complete authorization over the DB2 database and its contents. This server user acts on behalf of all Notes users.

For information about defining DB2DOM as a system control group in DB2, see the topic Designating the DB2DOM group a system control group.

Note If you have a Windows user account that you want to use as the Domino server user, begin this process with Step 3 of the procedure in the topic Manually creating the Domino server user account and the DB2DOM group.

Activating the SYSCTRL_GROUP setting

This information applies regardless of whether you use the Server Enablement Tool or you manually create the Domino server user and DB2DOM group. If the SYSCTRL_GROUP is set up for the first time in DB2, stop and start the DB2 server by issuing the following commands from the DB2 Command Line Processor (CLP):


See also