Lotus Domino Administrator 8.5 Help - Setting and modifying DB2 values in the Server document

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.

Field Description

Host Name Host name of the DB2 server. The host is the name of the remote server on which you are storing data. Remote configuration only.

Port Number Specify the port number used to access the DB2 server. Remote configuration only.

Instance The DB2 instance name. The default instance is DB2.

Database Enter the DB2 database name. The default is Domino.

Directory A 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 Creation The 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 Server Enter the fully-qualified user name of the USER.ID file that DB2 Access server uses. For example, DB2AccServ/DomainName

DB2 Access Path Enter 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 Group The 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 views The 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 limit The 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 warnings The 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

Mapping the DB2 ID to a Notes ID in the Domino server's Domino Directory

Administering the Domino and DB2 environment

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary

Field	Description
Host Name	Host name of the DB2 server. The host is the name of the remote server on which you are storing data. Remote configuration only.
Port Number	Specify the port number used to access the DB2 server. Remote configuration only.
Instance	The DB2 instance name. The default instance is DB2.
Database	Enter the DB2 database name. The default is Domino.
Directory	A 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 Creation	The 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 Server	Enter the fully-qualified user name of the USER.ID file that DB2 Access server uses. For example, DB2AccServ/DomainName
DB2 Access Path	Enter 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 Group	The 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 views	The 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 limit	The 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 warnings	The 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.