Online backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 29 Dec 2006 05:19 GMT

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 <DBNAME> online
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

Reply to this Message

Gladiator - 29 Dec 2006 06:01 GMT

> We have a production DB that is running DB2 v8 fix pak 8. Some of
> configuration parameter on the primary DB config file is:
[quoted text clipped - 15 lines]
>
> 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

Reply to this Message

Al - 29 Dec 2006 18:24 GMT

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

Reply to this Message

Ian - 29 Dec 2006 22:23 GMT

> 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/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/ad
min/r0006082.htm

Reply to this Message

Al - 30 Dec 2006 03:52 GMT

Thanks alot Ian & Kamal

Reply to this Message