Troubleshooting guide

If you have not set up the sample Replication Server instance, enter your Replication
Server instance name in place of SAMPLE_RS.
2.
Enter:
grant create object to SAMPLE_RS_ra
go
where SAMPLE_RS_ra is the value for the rs_username parameter you entered in the
resource file.
Configuring Replication Agent
Review the procedures for configuring Replication Agent for DB2 UDB.
Primary DB2 UDB Configuration for Replication
To configure the primary DB2 UDB database for replication, you may need to connect to the
primary database using the primary database instance owner user.
Verifying the Current Archive Setting of the Transaction Log
Set the primary DB2 UDB database transaction logging to archive logging, instead of circular
logging for Replication Agent.
1.
Determine the LOGARCHMETH1 setting.
a.
Connect to the database by entering this command at the CLP prompt.
CONNECT TO dbalias USER db2_user USING db2_user_ps
where dbalias is the cataloged alias of the primary database, db2_user is the primary
database user, and db2_user_ps is the password.
b.
Determine the LOGARCHMETH1 setting:
GET DB CFG FOR dbalias
2.
If the results do not show that LOGARCHMETH1 is set to LOGRETAIN or to the path
name of the directory to which logs are archived, set it:
• To use the default archive location:
UPDATE DATABASE CONFIGURATION USING logarchmeth1 LOGRETAIN
• To use a specific archive location:
UPDATE DATABASE CONFIGURATION USING logarchmeth1 DISK:path
where path is the full path name of the directory where the archive logs are to be stored.
If you change the setting of the DB2 UDB logarchmeth1 parameter, DB2 UDB requires
you to back up the database:
BACKUP DATABASE dbname TO "backup_dir"
where dbname is your database name, and backup_dir is the target directory for the
backup.
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
92 Replication Server