• Make sure you are running at least IBM® DB2 Universal Database™ Enterprise Server Edition 9.1 or more recent.

1. Set the environment variable, DB2_ALLOW_SETAUTH_WITH_REMOTECONNECT=, in order for query views to work. Use the following path and command:

C:\Program Files\IBM\SQLLIB\BIN>db2set -i DB2  DB2_ALLOW_SETAUTH_WITH_REMOTECONNECT=1

where -i is the name of your DB2 instance (typically DB2).

3. Ensure that your DOMINO database has federated support enabled.

4. Create a federation wrapper in DB2 for the remote server.

For information about wrappers and about enabling federated data support in DB2, go to the DB2 Information Center http://publib.boulder.ibm.com/infocenter/db2help/index.jsp.

5. Add a user mapping to this federation wrapper mapping the DOMINO server user to the remote connection user name and password. From the DB2 Control Center, choose Server Definitions - DAVS - User Mapping.

The IBM® Lotus® Domino™ server user is the account you created for DB2 server enablement.

7. Grant privileges to the NICKNAME object as required for those mapped DB2 users to whom you want to give access to the federated table. Complete these steps from the command prompt or from the command center:

• Log on to your database as your Domino server user, or as another administrator.
• Use this command to grant privileges:
grant select on domino.forpeter to <user's short name>

ALL users granted access to the federated table have equal access to it, based on the mapped credential in the federation definition.

See also

Working with views in Domino and DB2

Glossary