Lotus Domino Administrator 7 Help - Enabling a Domino server to communicate with a DB2 server

DOMINO AND DB2

Enabling a Domino server to communicate with a DB2 server
The DB2 Server Enablement Tool enables DB2 as a data store for Domino, which enables Domino to use DB2. After DB2 server enablement occurs, the fact that DB2 is used as a data store is transparent to Notes client users. Only administrators are aware of this. Notes users use Domino Notes as usual; Domino uses DB2.

During the DB2 server enablement process, the DB2 database is created. Domino uses the administration process to create that database, and the administration process requires that the administration server is running. After the database is created, the default schemas, domino.catalog, and other objects are created. Several NOTES.INI variables are automatically set by the DB2 Server Enablement Tool, using information that you provide.

Caution The DB2 database name that you enter in this procedure is automatically stored in the NOTES.INI variable DB2DATABASE. If you later delete or modify this value, Domino's DB2 capabilities are effectively disabled. The name stored in DB2DATABASE is used as the basis for the names of the database, buffer pool, tablespaces, and schema.

For more information about the NOTES.INI variables that are added when you run the DB2 Server Enablement Tool, see the topic NOTES.INI variables set by the DB2 Server Enablement Tool.

In this procedure, all of the steps apply to all supported platforms unless there is a notation at the beginning of the step that indicates it is for IBM AIX only or Microsoft Windows only. If a step does not apply to your configuration, just omit that step and proceed to the next step.

Prerequisites

1. From the Domino Administrator, point to the server you are enabling.

2. Have this information available before you begin the procedure:

The name of the DB2 instance that you created when you installed DB2. If you are using Microsoft Windows, the default instance name is DB2; on AIX, it is whatever you named it.
The Domino server account name and password. This is a user name created at the OS level that will be used by the Domino server to access the DB2 server. This user account must have at least SYSCTRL_GROUP access in DB2 or it must be a member of the group, DB2DOM.
The server ID that you created for the DB2 Access server.
If you are using AIX, the location where you installed the DB2 Access server. This path is used in the DB2 Access Path field of the Server document and in one of the dialog boxes for the DB2 Server Enablement tool. Microsoft Windows does not prompt for this information; Windows uses the default DB2 function directory.

Procedure

1. From the Domino Administrator, click Configuration.

2. Click DB2 Server -- Enable Server for DB2.

Note

If the feature Enable Server for DB2 is not active, the Domino server is already enabled for DB2, or you are using a pre-Domino 7 version of the Lotus Domino and Notes software, or you are using a platform other than Microsoft Windows or IBM AIX.

3. Click DB2 Server, and then complete these fields:

Field	Action
DB2 and Domino are on different systems or DB2 is 64-bit on AIX server	If any of these conditions are true, click this check box: DB2 and Domino are installed on different computers. 64-bit DB2 instance is used on the DB2 AIX server. You are using the DB2 Run-Time Client on the Domino server.
DB2 Instance Name	Enter the DB2 instance name that you created when you installed the DB2 server. Note This field only applies to local configurations using a 32-bit DB2 instance.
DB2 Datastore Directory	(Optional) Enter the full path and name of the directory where the DB2 enabled Notes databases will be stored on the DB2 server. For example, In Microsoft Windows, a sample path is: c:\db2db\srvr\ In IBM AIX, a sample path is: /local1/db2inst1/db2dir/ Users must have appropriate access rights for the directory that you enter.
DB2 Database Name	Enter a database name, or accept DOMINO as the default DB2 database.
Host Name	Enter the name of the remote server that will store data. This field applies only to remote configurations.
Port Number/Service Name	Enter the port number or service name for the remote instance of DB2. This field applies only to remote configurations. Open the DB2 Control Center to obtain this information, and then right click the instance to which you are connecting. Select "Setup Communications." Review the TCP/IP properties. An example of a service name is db2c_DB2. An example of a port number is 50000. You can use either in this field.
DB2 Node Name	This field appears only for remote configurations or if a 64-bit DB2 instance is being used on the DB2 AIX server. Enter the DB2 node name, that is, the name assigned to the DB2 server in the DB2 Node Directory. The node name you enter cannot be a name that is assigned to another entity in the DB2 configuration. For example, the node name cannot be identical to the DB2 instance name nor the Domino server name. The DB2 server enablement tool uses the DB2 node name to create the DB2 node.
By default, create databases as	Choose one: DB2 (default) -- Creates DB2 databases. NSF -- Creates Domino NSF databases.
Immediately update the server's Domino Directory with DB2 information	Click this check box to update the Domino Directory immediately instead of waiting for the administration process to initiate the update.
Automatically restart the Domino server upon successful enablement	Click this check box to restart the server after the DB2 Server Enablement Tool runs and the DB2 information is added to the Domino Directory.

4. Click DB2 Access, and then complete these fields:

Field	Action
OS account name to be used by Domino to access DB2	This user name is an operating system user account name that Domino uses to access the DB2 server. This is a Microsoft Windows or IBM AIX account. If you are using IBM AIX, you can only enter an existing user account name; you cannot create one from this dialog box. Do one: Enter a new name to create the new user account. This option applies only to Microsoft Windows. Enter an existing user account name if you have created one that you want to use. It must be an OS user account name.
DB2 Password	Enter the password for the new or existing user account name that you entered in the field "OS account name to be used by Domino to access DB2." that The Domino server uses this password to access the DB2 server.
Verify DB2 password	Reenter the password.
DB2 Access server name	Enter the name of the DB2 Access server that you registered using the Domino Administrator and that you used for the DB2 Access server install. This server name is used for DB2 Access Views. Domino adds the DB2 Access name to the field, Trusted Servers, in the Server Access section of the Security tab on the Server document for the Domino server.
DB2 Access path	Enter the full path to the location of the DB2 Access server. The DB2 database uses this path to access the DB2 Access server's DLL. For example, `C:\Program Files\IBM\DB2 Access for Lotus Domino\ndomudf.dll` If the DB2 Access server is not installed on the same computer as the DB2 server, the path should include the server on which DB2 Access is installed. The DB2 server uses this path to load the DB2 Access service.

For more information about database storage types, see the topic Databases created with Domino 7.

5. Click Enable.

6. One of these occurs, according to platform:

Microsoft Windows -- A status box displays. If there are no errors, click OK. Click Store or Continue according to whether you want to stop the server-enablement process or continue the process.
IBM AIX -- A series of messages appears. Review the messages, and then click Stop or Continue according to what you want to do.

7. If you installed the DB2 Access server prior to running the DB2 Server Enablement tool, enter this command from the Domino server console:

DB2 ACCESS SET

Enabling Domino access to a DB2 server

Setting up DB2 on Microsoft Windows

Installing and setting up Domino and DB2 and the DB2 Access server on IBM AIX -- Local configuration

Understanding Domino and DB2 -- Limited Availability

Glossary

Help on Help

All Help Contents

Glossary

Help on Help

All Help Contents