DB2 Integration - first full offline database backup
according to documentation, to enable online backups of DB2, "First backup up the database offline to non-Data Protector media"
Why offline backup must be done, and how to avoid that?
Before you begin
To enable online backups of DB2 objects, set the DB2 logretain and userexit parameters to ON (in a partitioned environment, on every node on which the object resides). Then restart the database for the new parameters to take effect and perform a full offline database backup.
Online backup is not allowed
Online backup is not allowed because either logretain or userexit for roll-forward is not activated, or a backup pending condition is in effect for the database.
After configuring the DB2 database for rollforward recovery (userexit and logretain ON), first back up the database offline. If online backup is started first, the above error is reported.
Thanks & Regards,
Re: DB2 Integration - first full offline database backup
It looks, that answers are here:
Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.
Online backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. Forward recovery is placed into effect by setting either the database configuration LOGARCHMETH1 or LOGARCHMETH2 and then performing an offline backup of the database.
Execute an offline backup or reconfigure the database for roll-forward recovery and issue an offline backup so that subsequent online backups will be allowed.