The maintenance user is a valid DB2 UDB user that the Replication
Server uses to apply commands to the replicate DB2 UDB database.
A user
must already exist on the operating system before you can add it to a DB2 UDB
database. To add an existing operating system user to the database, use the SAPĀ®
Control Center administration tool, which is included with either the server or
client installation of DB2 UDB on Microsoft Windows. You may choose to install a DB2
UDB client on a Windows machine and use it to administer the DB2 UDB databases.
- Select an existing operating system user
to be added to the replicate database as a maintenance user.
- Select .
- Configure the Control Center administration tool to connect to the replicate
DB2 UDB database according to the IBM documentation. Once the Control Center
administration tool has been configured, the replicate database appears in the
All Databases view.
- In the Control Center administration tool display
window, right-click the replicate database name, and select Authorities
from the context menu.
- In the Database Authorities window, click Add
User.
- In the Add User window, select the user to add
to the database from the list of displayed operating system users,
and click OK.
- Click Grant All to add necessary authorities to
the maintenance user.
Note: In a proof-of-concept environment, the user is created by a DB2 UDB system
administrator.