473,325 Members | 2,712 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,325 software developers and data experts.

DB2 restores after unrecoverable load in single and mulit-partitioned DB

We have done some testing with mixed and forgotten results. So I'm
hoping that asking here can clarify some issues for us. Right now we do
one weekly warm backup. Throughout the week there are multiple
unrecoverable loads. We are tyring to come up with the best backup
strategy for this system? It is a large dev data warehouse.

What happens when a table is loaded unrecoverable and then we need to
restore (no DDL has been done)? Can we recover using our last warm
backup if we rollforward just to before the load?

What about a table in a multi-table tablespace, what happens to other
tables? We have found that after an unrecoverable load the only thing
we can do is drop the table but most times the table is one of many.

What happens in a multi-partition environment? Let's say our table is
across 2 partitions?

What if we have a tablespace backup taken right after the unrecoverable
load but before the next full backup, can we do a restore then? How?

What happens to the backup with the unrecoverable load is happening at
the same time as the backup?

Thanks for any comment,
DBAGIRLTX

Jun 23 '06 #1
1 3785
Well, I guess you are living in intresting times !!!
See below. ######

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"dbagirltx" <db*******@yahoo.com> a écrit dans le message de news:
11**********************@b68g2000cwa.googlegroups. com...
We have done some testing with mixed and forgotten results. So I'm
hoping that asking here can clarify some issues for us. Right now we do
one weekly warm backup. Throughout the week there are multiple
unrecoverable loads. We are tyring to come up with the best backup
strategy for this system? It is a large dev data warehouse.

What happens when a table is loaded unrecoverable and then we need to
restore (no DDL has been done)? Can we recover using our last warm
backup if we rollforward just to before the load? #######
It does not matter whether DDl has been done. You cannot do a tablespace
restore/rollforward prior to drop.
You have to a full db restore/ rollforward to Point in Tine prior to drop.
Extract ddl and data the inactive objct in tablespace. Then re restore the
full db, roll it forward to end of logs which is through the load, drop the
inactive nonrecoverable load table, and then use extracted ddl and data to
reconstruct.
What about a table in a multi-table tablespace, what happens to other
tables? We have found that after an unrecoverable load the only thing
we can do is drop the table but most times the table is one of many. #######
See above, The pint is that a nonrecoverable load brings the minimum PIT of
the tablespace to the timestamp of the load. From that point on the
tablespace can only be recovered at leas to that minimum PIT but not before
it.
Method 1 above answers to protecting the other tables in the tablespace as
the second restore/rollforward will put them consistent with the db and also
the inactive table is then dropped and rebuilt.
What happens in a multi-partition environment? Let's say our table is
across 2 partitions? #######
I believe that because the tabvlespace which has the table is on more than
one partition, you would have to apply the step above to all partutions on
which the tablespace is defined.
What if we have a tablespace backup taken right after the unrecoverable
load but before the next full backup, can we do a restore then? How? #######
In this case, your strategy becomes:
Resotre the image taken after the unrecoverable load and roll it forward as
as you need, iff you only want to recover it.
For a full db restore where theimage of the db is prior to the unrecoverable
load, thwen your strategy is as follows:
restore the full db
restore the tablespace image taken after the unrecoverable load
roll forward the whole db to the end of the logs.
As the tablespace has been restored it is consistent as of the time of its
backup. The roll forward will ignore any transaction for that table space
which precedes the timestamp of the restored image.
What happens to the backup with the unrecoverable load is happening at
the same time as the backup? #######
If tyou are executing a load on a table, the db puts the tablespace in load
pending or other states as the load progress. For a tablespace to be backed
up it "must" be in normal state so the backup request will not launch.
Similarly, if the tablespace backup is launched the load command will bounce
so that the two cannot ever happen concurrently.
Thanks for any comment,
DBAGIRLTX


HTH, Pierre.

Jun 23 '06 #2

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

Similar topics

0
by: Vincento Harris | last post by:
I implement manual log shipping per http://www.sql-server-performance.com/sql_server_log_shipping.asp Full Backups are configured to overwrite current backups(backup with init) The process...
2
by: Rob Oldfield | last post by:
The other day I restarted my machine and suddenly couldn't open any of my existing VB.Net projects. I reinstalled the (1.1) framework and got around that one.... but.... Since then, if I try to...
6
by: JS | last post by:
EE instance DB2 v7.2.0 fixpack 3 on WIN2K. I select some data from a table A and write it to a file using the COALESCE function and whitespace as the null character: eg coalesce(col1, ' '). This...
0
by: Wenhai Fu | last post by:
Hi, guys, I am practicing the setup wizard of VC.Net. When I build the setup project, I am always told "unrecoverable build error". I really have no clue what's going on here. I tried this on W2K...
2
by: Stormy | last post by:
when I compile my program I get "fatal error C1506: unrecoverable block scoping error". Can anyone tell me why? Thank you very much in advance. namespace unManaged { template<class L> class...
2
by: Schoo | last post by:
I was working in VS creating web pages and testing them in debug for our intranet site, when suddenly I went to run the app and got the error message that there were build errors. To my suprise...
0
by: amber | last post by:
Help! All of a sudden my solution won't build! If I'm in debug mode, it builds fine, but if I switch to release mode, I get the error message: "Unrecoverable Build Error." That's it...nothing...
4
by: andrewcw | last post by:
I am moving some code forward from .NET 1.1. I was able to load the XSL file and perform the transform. The MSDN documentation looks like it should be easy. But I get a compile error. Ideas ?...
13
by: rdudejr | last post by:
Hi all, I hardly ever make a post unless I am having a very purplexing issue, so this one should be good... I am trying to do a load against a database on an AIX server into a DB2 v9.1...
1
by: cryogeneric | last post by:
Hello everybody, I'm not all that familiar with backing up and restoring databases on SQL 2005 and I have a question. First, let me give you a little insight into how we're setup and what we want...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.