DB2 UDB Primary Database Permissions

Any updates applied to the primary database by the maintenance user are ignored for replication, unless the value of the LTM for z/OS LTM_process_maint_uid_trans configuration parameter is Y.

Create these two user IDs:

LTMADMIN user – a TSO user, optionally named LTMADMIN, to:
- Install, start, and stop the Replication Agent for DB2 UDB
- Manage the Replication Agent system tables on the DB2 UDB
The LTMADMIN user must have ALTER TABLE authority on any DB2 UDB table to be marked for replication. This user ID issues an ALTER TABLE DATA CAPTURE CHANGES command on a primary table that is marked for replication.

The LTMADMIN user must also have TRACE, DISPLAY, and MONITOR2 permission on the DB2 UDB log files.
Replication Server maintenance user – the user ID specified in the Replication Server create connection command for the primary database.