Primary and Replicate Databases Prerequisites

Ensure that the primary and replicate databases meet the environment requirements for using RMA.

UDB DB2

These items are required for your UDB DB2 database environment:

User with DBADM authority – the Replication Agent requires the use of a UDB login that has DBADM authority. This is required to access the UDB log read API feature.
This is an example of a grant command that you can use to grant dbadm permission to a UDB user:
```
grant dbadm on database to user login_name
```
This is an example of a select command that you can use to list all users who currently have dbadm authority:
```
select grantee from SYSCAT.DBAUTH where DBADMAUTH =‘Y‘
```
User to identify as maintenance user – the Replication Agent requires a UDB login to be identified as the maintenance user for the database. Maintenance user activity is excluded or filtered from replication (the assumption is that maintenance user transactions generate activity from replication, and this activity must be excluded from further replication to avoid circular redundancy). This user requires no special permissions in this environment, but must be a user different than the DBADM user, so that the DBADM user activity can be replicated.
Enable log archiving in the database, so the UDF log read API can function – archiving is enabled when one of the database configurations— "logarchmeth1" or "logarchmeth2"—is set to “LOGRETAIN”, or points to a disk file location or TSM management class. See the IBM documentation for more information about UDB archiving.
Create a user temporary table space, or verify that one exist – some UDB stored procedures or functions that the Replication Agent executes require the user to have access to a temporary table space to store temporary results. The table space must be at least 8K in size.

SAP HANA Database

These items are required for your HANA database environment:

Dedicated maintenance user – the replication process requires a dedicated HANA login that is used to maintain or apply all replication-related commands. This user must have insert/update/delete and truncate authority on any schema and table that is to be replicated.
See the HANA documentation at http://help.sap.com/hana/html/sql_grant.html for more information about grants and permissions.
User with DBA authority – the RMA supports the identification of a HANA login that has DBA authority. Identify the maintenance user also as the administrative user.