473,226 Members | 1,261 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,226 software developers and data experts.

db2 full-incremental-delta restore/recovery question

Recently I've done a db2 backup and restore/recovery, but the process
for recovering the database was different than what I thought to be.

here is what I did:

DB2 is set in online mode

- backup -
* backup db2 in full
* insert record
* backup db2 in incremental
* insert record
* backup db2 in delta
* run command "archive log for db abc" and three log files archived to
tape

drop the database

- restore/recovery -
* restore delta backup - read from tape
* restore incremental backup - read from tape
* restore full backup - read from tape
* restore delta backup - read from tape

rollforwarding to end of log
5 log files applied and it was much fast than I thought, during
backup, there where at least 30 log files being created and archived
to tape. Most of them were in size of about 1 GB, but the archive log
applied was very small for roll forward.

what logs being applied (needed) and why the data (delta backup) being
read twice from tape? DB2 document no where tell the process in
detail, any one can help to explain?

Thanks,
Jimmy
Nov 12 '05 #1
1 3416
The reason the reason the delta backup is read twice is because it is the
most recent and therefore has the most recent values for the recovery
history.
The first read only gets the recovery history which is used to find A) the
most recent FULL from which to start and B) the intervening incremental full
or incremental deltas and C) the proper sequence in which to apply those.
AFAIK, the sequence should be in your case:
Incremental delta from tape - To get the sequence from history
Full image from tape
Full Incremental
Delta Inceremental - Again to get the last of your insert.
Roll Forward (If needed)
If you set your DIAGLEVEL to 4 in the dbm cfg, you will be able to get msgs.
which will indicate that flow.

As to your log files, I'm not sure I understand what you are saying. Abit
more detail in the mechanics might help.
HTH, Pierre.
"Jimmy Chen" <ji*********@hotmail.com> a écrit dans le message de
news:5e**************************@posting.google.c om...
Recently I've done a db2 backup and restore/recovery, but the process
for recovering the database was different than what I thought to be.

here is what I did:

DB2 is set in online mode

- backup -
* backup db2 in full
* insert record
* backup db2 in incremental
* insert record
* backup db2 in delta
* run command "archive log for db abc" and three log files archived to
tape

drop the database

- restore/recovery -
* restore delta backup - read from tape
* restore incremental backup - read from tape
* restore full backup - read from tape
* restore delta backup - read from tape

rollforwarding to end of log
5 log files applied and it was much fast than I thought, during
backup, there where at least 30 log files being created and archived
to tape. Most of them were in size of about 1 GB, but the archive log
applied was very small for roll forward.

what logs being applied (needed) and why the data (delta backup) being
read twice from tape? DB2 document no where tell the process in
detail, any one can help to explain?

Thanks,
Jimmy

Nov 12 '05 #2

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

Similar topics

0
by: karolina | last post by:
Hi, I building a little site using PHP and mysql. Now I want to make full text searches on some columns in one table. The problem is that I have 25 colums in the table that I want to put at...
0
by: daking | last post by:
I'm trying to track down a Java performance issue, and believe it may be related to GC behavior. Quick background: j2se app server running Caucho Resin 2.1.12, on RHEL3 with Sun JDK 1.4.2_04,...
0
by: Tracey | last post by:
Hi there, I want to search Japanese characters with Full Text search function. I created a table (tbSearch) for Full-text search on SQL 2000, English Win2k Server. The table contains 4 fields,...
0
by: Denise | last post by:
Hi I have set up a full text index on one of my database tables and created a catalog. Then I started a full population on my catalog and got a message "Population of full text index started...
1
by: onewebclick | last post by:
Is there a way to detect a browser cache is full using javascript or HTML thorugh a web page and inform the user to clear the cache to improve performance of the website. It looks like google's...
11
by: rh00667 | last post by:
hi all, i'm confused now. how i can get the full path of an application? if myapp is in a directory which belongs to PATH, argv gives me the first token of cmd line, and not the real path of...
5
by: =?Utf-8?B?TWFydHluIEZld3RyZWxs?= | last post by:
Hi there. I posted an earlier issue under the name "That assembly does not allow partially trusted callers" but have now identified what the issue is. As explained before I am working in...
4
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available...
1
by: vivek samantray | last post by:
I have a query.When i try to create a index on one of the table the index gets created but when i take the output it stuill shows "TABLE ACCESS FULL" Please see below what i did QUERY ======...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
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...

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.