The maintenance user is a valid IBM DB2 Universal Database
user that the Replication Server uses to apply commands to the replicate
IBM DB2 Universal Database. 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 an IBM DB2 Universal 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 IBM DB2 Universal Database on Microsoft Windows. You may choose
to install an IBM DB2 Universal Database client on a Windows machine
and use it to administer the IBM DB2 Universal 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 IBM DB2 Universal 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 POC environment, the user is created by an IBM
DB2 Universal Database system administrator.