Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
Tomislav P. Absent Member.
Absent Member.
1982 views

DB2 Integration - first full offline database backup

Hi,

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?


From documentation:
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.

Problem
Online backup is not allowed
DB2 reports:
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.
Action
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,
Tom

Tags (1)
0 Likes
1 Reply
Tomislav P. Absent Member.
Absent Member.

Re: DB2 Integration - first full offline database backup

HI,

It looks, that answers are here:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql.doc%2Fdoc%2Fmsql02413n.html

SQL2413N

Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.
Explanation

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.
User response

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.


or this:
https://scn.sap.com/thread/2025154

Regards,
Tom

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.