Set the primary DB2 UDB database transaction logging to archive
logging, instead of circular logging for Replication Agent.
- Determine the LOGARCHMETH1 setting.
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.
Determine the LOGARCHMETH1 setting:
- 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:
If you change the setting of the DB2 UDB logarchmeth1
parameter, DB2 UDB requires you to back up the database. Use your normal backup
procedure, or see the IBM documentation for information on the BACKUP
DATABASE command.