Encountering a `You must perform a FULL DATABASE BACKUP to start the FULL or BULK-LOGGED RECOVERY MODEL` message when configuring the CDC Replication Engine for DB2 for LUW

Environment

CDC Replication Engine for DB2® for LUW

Symptoms

When configuring an instance of CDC Replication using the CDC Replication configuration tool, you receive the following error:

You must perform a FULL DATABASE BACKUP to start the FULL or BULK-LOGGED RECOVERY MODEL

Causes

You have not performed a full database backup. You must perform a full backup of your database to start using the full or bulk-logged recovery model. A full database backup activates the new recovery model. Until you perform a full database backup, your database will continue logging with the simple recovery model.

Resolution

Back up your database. For example, the following SQL statement will perform a full backup of the abc database:

BACKUP DATABASE abc TO DISK = 'c:\mssql\backup\abc.bak'

For more information on how to perform this task, contact your database administrator or refer to your database documentation.