Creating an IBM DB2 Universal Database User and Granting Permissions

Create an IBM DB2 Universal Database user and grant the necessary permissions.

Replication Agent requires an IBM DB2 Universal Database login that has permission to access data and create new objects in the primary database. The IBM DB2 Universal Database login must have SYSADM or DBADM authority to access the primary database transaction log.

  1. Create a new operating system user named ra_user using commands appropriate for your operating system.
    For example, this command can be used to create a user named ra_user on the UNIX and Linux operating systems:
    useradd -gusers -Gmgmt -s/bin/shell -psybase 
-d/home/ra_user -m ra_user
    where password is the password corresponding to the ra_user user name.
  2. Select Start > Programs > IBM DB2 > Control Center.
  3. Configure the Control Center administration tool to connect to the primary IBM DB2 Universal Database according to the IBM documentation. Once the Control Center administration tool has been configured, the primary database appears in the All Databases view.
  4. In the Control Center administration tool display window, right-click the primary database name, and select Authorities from the context menu.
  5. In the Database Authorities window, click Add User.
  6. In the Add User window, select ra_user from the list of displayed operating system users, and click OK.
  7. Click Grant All to add necessary authorities to ra_user.
    Note: In a POC environment, the user is created by an IBM DB2 Universal Database system administrator.
Parent topic: Primary IBM DB2 Universal Database Configuration for Replication