The maintenance user on the primary connection is a valid DB2 UDB
user whose activities are ignored if Replication Agent processes log records by the user.
Replication Server requires one maintenance user to be defined for each
connection.
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 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 primary database as
a maintenance user.
- Select .
- Configure the Control Center administration tool to connect to the primary 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
primary 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.