DOMINO AND DB2

Setting and enabling a default DB2 user ID for use with query views
You can set up a common default DB2 user name and use it in place of an explicit DB2 user mapping. This default DB2 user mapping is sufficient when working with most query views. IBM® Lotus® Domino® uses this DB2 user ID to access query views in IBM® DB2 Universal Database™ Enterprise Server Edition databases.

When you specify a default DB2 user name, IBM® Lotus® Domino® verifies that the default DB2 user name is not the same as the Domino server user name. If the name is the same, an error is generated on server start up and the default method of explicit DB2 user mappings is required.

If you explicitly map more that one Notes user to a single DB2 user name, an error is generated when you try to access the DAV using either a query view or SQL.

For information about IBM® DB2 Universal Database™ Enterprise Server Edition, see the DB2 Information Center.

Enabling the default DB2 user for query views

After creating the DB2 user account, you must enable it. This tool updates the Default user for query views field on the Server document - DB2 Tab.

Prerequisite

Create the DB2 user ID that will be used as the default by creating an OS account, and assigning at least connect-only privileges in DB2.

Complete these steps to enable the default DB2 user ID.

1. From the Domino Administration, click Configuration - Server - All Server Documents.

2. From the Tools panel, click DB2 Server - Edit DB2 Default User.

3. Enter the DB2 user name to be used as the default DB2 user.

4. Click to enable the check box Use default query view user on this server.

5. Click OK.

6. To allow the default DB2 user name to take effect, restart the Domino server or wait for the administration process to run.

Related topics