MAINTAINING THE DOMINO AND DB2 ENVIRONMENT


Setting and modifying DB2 values in the Server document
When you run the DB2 Server Enablement Tool, the fields on the IBM® DB2 Universal Database™ Enterprise Server Edition tab of the Server document are updated. If you are not using the DB2 Server Enablement Tool, manually update the Server document.

1. From the IBM® Lotus® Domino® Administrator, click the Configuration tab and then expand the Server section.

2. Select the Server document to be edited and then click Edit Server.

3. Click the DB2 tab.

4. Complete these fields on the DB2 tab and then click Save and Close.

Note If you are modifying one of the DB2 parameters, restart the server after saving your modifications in order to allow those modifications to take effect.
FieldDescription
Host NameHost name of the DB2 server. The host is the name of the remote server on which you are storing data. Remote configuration only.
Port NumberSpecify the port number used to access the DB2 server. Remote configuration only.
InstanceThe DB2 instance name. The default instance is DB2.
DatabaseEnter the DB2 database name. The default is Domino.
DirectoryA valid path where DB2-based NSF tablespace containers will reside. This field defaults to the DB2 server's default directory set up by the DB2 administrator.

Note If multiple Domino servers are connected to different instances of the same DB2 server, the Directory that you specify must be unique for each Domino server, or the Directory field must be blank for each Domino server. This is an advanced setting and in most cases, the default can be used.

If you specify multiple paths, containers are dispersed randomly across different paths. If you choose to provide multiple paths, use this syntax:

C:\db2data#D:\db2data#E:\db2data

Where the '#' is used to separate container locations. These locations are not used to stripe containers, rather to disperse newly-created NSF containers randomly across the different paths.

DB Default CreationThe type of database that is created by default when working in IBM® Lotus® Notes®. Choose one:
  • DB2 -- Creates a DB2 enabled Notes database, which you can work with in DB2 and Domino Notes.
  • NSF -- Creates an NSF which you can only work with in Domino Notes. NSFs are not recognized by DB2.
DB2 Access ServerEnter the fully-qualified user name of the USER.ID file that DB2 Access server uses. For example, DB2AccServ/DomainName
DB2 Access PathEnter the complete path that DB2 uses to load the DB2 Access server DLL. For example, C:\program files\db2udf\ndomudf.dll. The DB2 Access path must point to the file ndomudf.dll.
Maximum number of NSFs in GroupThe default setting is 10. The maximum number of DB2 enabled Notes databases permitted in one DB2 group. You can lock a DB2 group before it reaches the maximum of 10 groups. When a group is locked or when it is full because it contains ten groups, any new DB2 enabled Notes databases are added to the next sequentially numbered DB2 group.
Default user for query viewsThe default setting is No (unchecked). Click Yes to set up a common default DB2 user name that can be used when an explicit Notes user and DB2 user mapping does not exist. This default mapping is sufficient when working with most query views.
Query View row limitThe default value is 500. Specify the maximum number of rows allowed in a query view. The value that you enter is propagated to the NOTES.INI setting, DB2QUERYVIEWROWLIMIT=value.
DB2 password expiration warningsThe default setting is 15. Specify the number of days prior to the DB2 password expiration date that a warning is issued reminding the user to reset their password.
Related topics