By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Online backup

P: n/a
Al
We have a production DB that is running DB2 v8 fix pak 8. Some of
configuration parameter on the primary DB config file is:

Logretain = NO
Userexit = NO
Logarchmeth1 = Disk:/aa/bb/ccc/

when I ran: db2 backup DB <DBNAMEonline
the command ran successful, I ran db2ckbkp on the backup, result is
successful.

According to IBM one of "Logretain" or "Userexit" must be turn on
before an online backup can be taken.
Am I missing something here, both Logretain & Userexit are off and I'm
still able to make online backup?

Thanks for your input.

Al

Dec 29 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

Al wrote:
We have a production DB that is running DB2 v8 fix pak 8. Some of
configuration parameter on the primary DB config file is:

Logretain = NO
Userexit = NO
Logarchmeth1 = Disk:/aa/bb/ccc/

when I ran: db2 backup DB <DBNAMEonline
the command ran successful, I ran db2ckbkp on the backup, result is
successful.

According to IBM one of "Logretain" or "Userexit" must be turn on
before an online backup can be taken.
Am I missing something here, both Logretain & Userexit are off and I'm
still able to make online backup?

Thanks for your input.

Al
Hai AI..

There is nothing u missed... When u enable LOGARCHMETH1 ("Logarchmeth1
= Disk:/aa/bb/ccc/") u are archiving the logs to the location u
specified (Disk:/aa/bb/ccc/" in this case) . So archive logging is
enabled and so the online backup happened....

Logretain is also similar to that , when u enable logretain u are
asking the logs to be retained in a default location...... in older
versions there is no LOGARCHMETH1 .. in that case we use LOGRETAIN and
USEREXIT to archive in required location..

Regards
Kamal

Dec 29 '06 #2

P: n/a
Al
Hello Kamal,

IBM doc's doesn't state that Logarchmth1 by itself will allow us to do
Online backup and rollforward the DB to any giving point. My
understanding that Logretain & Logarchmth1 must be turned on before a
successful online backup happen.

Thanks for your input.

Regards,
Al

Dec 29 '06 #3

P: n/a
Ian
lAl wrote:
Hello Kamal,

IBM doc's doesn't state that Logarchmth1 by itself will allow us to do
Online backup and rollforward the DB to any giving point. My
understanding that Logretain & Logarchmth1 must be turned on before a
successful online backup happen.
The doc was updated a long time ago, but is a little confusing. The
key information is provided in the first 2 sentences:

Log retain (logretain)
This configuration parameter has been replaced by logarchmeth1.
It is still supported for back-level compatibility.

If logretain is set to RECOVERY, archived logs are kept in the
database log path directory, and the database is considered to be
recoverable, meaning that rollforward recovery is enabled.

Note:

The default value for the logretain database configuration
parameter does not support rollforward recovery. You must change
the value of this parameter if you are going to use rollforward
recovery.

If you read the description of LOGARCHMETH1 and LOGARCHMETH2, they are
much more clear.
Reference:

http://publib.boulder.ibm.com/infoce...n/r0006082.htm

Dec 29 '06 #4

P: n/a
Al

Thanks alot Ian & Kamal

Dec 30 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.