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 it can be added 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.
Creating a maintenance user in IBM DB2 Universal
Database
Select an existing operating system user to be added to the replicate database as a maintenance user.
Select Start | Programs | IBM DB2 | Control Center.
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.
In a POC environment, the user is created by an IBM
DB2 Universal Database system administrator.
