473,326 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Online backup

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
4 5462

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
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
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
Al

Thanks alot Ian & Kamal

Dec 30 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Arijit Chatterjee | last post by:
Dear Friends, I don't know anybody has asked this question before or not.But I need a support urgently.How to take online backup in MS Sql server 2000. Thanks Arijit Chatterjee
4
by: manwiththeaxe.70 | last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now...
6
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option...
5
by: Gladiator | last post by:
Hai..... I have a database............ i took an online backup for tht..... After tht mistakenly i dropped the database.......... now i dont have the logs also....... now after i restore the...
3
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple...
10
by: Konstantin Andreev | last post by:
Hello. Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible. But......
4
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 I have a DB2 online DB backup that was done w/ the INCLUDE LOGS option. I am interested in restoring that backup, and rolling forward ONLY the logs contained in the...
5
by: Konstantin Andreev | last post by:
Hello, all. I can't figure out <subjectfrom documentation. I had configured LOGARCHMETH1 = DISK:/bak/logs so all full log files are copied *out* of the active log path. Let I issue | #...
6
by: michael.spoden | last post by:
Hi, how can I fix lock-waits during an online backup? Is an online backup in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux. The command to perform the backup is: db2 backup...
2
by: alex250374 | last post by:
Hi all, db2 9.1 fixpak 0 aix 5.3 I have a big problem every time I start an online backup with include logs via veritas comes out an error!!! The db2diag shows:...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.