473,703 Members | 2,808 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

restore tablespace backup onto another system

Source/Production system: AIX 5.2, DB2 8.2

I have a full backup of sample db taken on 05/01/2006(logs included in
backups)
I have a tablespace backup of userspace1 taken on 05/03/2006(logs
included in backups)
There are other tablespaces in this db as well
There is retention logging

I want to restore the userspace1 tablespace of sampledb into newdb on
development( AIX 5.2, DB2 8.2).

How can I accomplish this.

My ideas:
create newdb with circular logging
restore from full backup into newdb
RESTORE DATABASE SAMPLE into newdb TABLESPACE (USERSPACE1) FROM
"C:\TEMP\bk p" TAKEN AT 20060303162052 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;

I want to have the data in userspace1 of newdb to be the data as of
05/03 and the rest of the db as of 05/01, is this possible?

Thanks
KS

Will this work?

May 10 '06 #1
3 3216
No this will not work.

In any backup image, there is a list of the tablespace in the image as well
as a lait of the tablespaces in the db.

Your newdb database will never have heard of the userspace1 and moreover,
the list of tablespace existing in the image will not match the one in the
db.

DB2 uses, as well as the entries in the catalog tables, a file known as the
table space descriptors to track who and what belongs to whom and where for
its tablespaces.

What you need to do is:
1) restore the userspce1 tablespace of 05/03 in to either the sample db or a
restored test copy of it.
2) rollforward the userspace1 tblspc as far as the time you require or end
of logs, whichever comes first.
3) Use db2look to extract the ddl for each of the tables in the tablespace.
4) Use db2move to extract the actual data for each of the tables.
5) Run the output of db2look in step 3 against the the newdb. You'll have
to edit that output file so that db name and containers of tablespace are
acceptable.
6) Run db2move in load mode to load the data that you extracted in step 4.

Once finished you should be all right.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<hi****@gmail.c om> a écrit dans le message de news:
11************* *********@g10g2 00...legr oups.com...
Source/Production system: AIX 5.2, DB2 8.2

I have a full backup of sample db taken on 05/01/2006(logs included in
backups)
I have a tablespace backup of userspace1 taken on 05/03/2006(logs
included in backups)
There are other tablespaces in this db as well
There is retention logging

I want to restore the userspace1 tablespace of sampledb into newdb on
development( AIX 5.2, DB2 8.2).

How can I accomplish this.

My ideas:
create newdb with circular logging
restore from full backup into newdb
RESTORE DATABASE SAMPLE into newdb TABLESPACE (USERSPACE1) FROM
"C:\TEMP\bk p" TAKEN AT 20060303162052 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;

I want to have the data in userspace1 of newdb to be the data as of
05/03 and the rest of the db as of 05/01, is this possible?

Thanks
KS

Will this work?


May 15 '06 #2
Thanks Pierre!!
Pierre Saint-Jacques wrote:
No this will not work.

In any backup image, there is a list of the tablespace in the image as well
as a lait of the tablespaces in the db.

Your newdb database will never have heard of the userspace1 and moreover,
the list of tablespace existing in the image will not match the one in the
db.

DB2 uses, as well as the entries in the catalog tables, a file known as the
table space descriptors to track who and what belongs to whom and where for
its tablespaces.

What you need to do is:
1) restore the userspce1 tablespace of 05/03 in to either the sample db or a
restored test copy of it.
2) rollforward the userspace1 tblspc as far as the time you require or end
of logs, whichever comes first.
3) Use db2look to extract the ddl for each of the tables in the tablespace.
4) Use db2move to extract the actual data for each of the tables.
5) Run the output of db2look in step 3 against the the newdb. You'll have
to edit that output file so that db name and containers of tablespace are
acceptable.
6) Run db2move in load mode to load the data that you extracted in step 4.

Once finished you should be all right.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<hi****@gmail.c om> a écrit dans le message de news:
11************* *********@g10g2 00...legr oups.com...
Source/Production system: AIX 5.2, DB2 8.2

I have a full backup of sample db taken on 05/01/2006(logs included in
backups)
I have a tablespace backup of userspace1 taken on 05/03/2006(logs
included in backups)
There are other tablespaces in this db as well
There is retention logging

I want to restore the userspace1 tablespace of sampledb into newdb on
development( AIX 5.2, DB2 8.2).

How can I accomplish this.

My ideas:
create newdb with circular logging
restore from full backup into newdb
RESTORE DATABASE SAMPLE into newdb TABLESPACE (USERSPACE1) FROM
"C:\TEMP\bk p" TAKEN AT 20060303162052 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;

I want to have the data in userspace1 of newdb to be the data as of
05/03 and the rest of the db as of 05/01, is this possible?

Thanks
KS

Will this work?


May 15 '06 #3
Just a bit more on this.
If you Google for DB2 Viper (a.k.a. V9) you might be agreably surprised
!!!!!!
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<hi****@gmail.c om> a écrit dans le message de news:
11************* *********@j73g2 00...legr oups.com...
Thanks Pierre!!
Pierre Saint-Jacques wrote:
No this will not work.

In any backup image, there is a list of the tablespace in the image as
well
as a lait of the tablespaces in the db.

Your newdb database will never have heard of the userspace1 and moreover,
the list of tablespace existing in the image will not match the one in the
db.

DB2 uses, as well as the entries in the catalog tables, a file known as
the
table space descriptors to track who and what belongs to whom and where
for
its tablespaces.

What you need to do is:
1) restore the userspce1 tablespace of 05/03 in to either the sample db or
a
restored test copy of it.
2) rollforward the userspace1 tblspc as far as the time you require or end
of logs, whichever comes first.
3) Use db2look to extract the ddl for each of the tables in the
tablespace.
4) Use db2move to extract the actual data for each of the tables.
5) Run the output of db2look in step 3 against the the newdb. You'll have
to edit that output file so that db name and containers of tablespace are
acceptable.
6) Run db2move in load mode to load the data that you extracted in step 4.

Once finished you should be all right.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<hi****@gmail.c om> a écrit dans le message de news:
11************* *********@g10g2 00...legr oups.com...
Source/Production system: AIX 5.2, DB2 8.2

I have a full backup of sample db taken on 05/01/2006(logs included in
backups)
I have a tablespace backup of userspace1 taken on 05/03/2006(logs
included in backups)
There are other tablespaces in this db as well
There is retention logging

I want to restore the userspace1 tablespace of sampledb into newdb on
development( AIX 5.2, DB2 8.2).

How can I accomplish this.

My ideas:
create newdb with circular logging
restore from full backup into newdb
RESTORE DATABASE SAMPLE into newdb TABLESPACE (USERSPACE1) FROM
"C:\TEMP\bk p" TAKEN AT 20060303162052 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;

I want to have the data in userspace1 of newdb to be the data as of
05/03 and the rest of the db as of 05/01, is this possible?

Thanks
KS

Will this work?


May 18 '06 #4

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

Similar topics

1
3849
by: Hakim | last post by:
Hi there, I am a rookie in DB2. I have tried to do a database restoration on my system. Since it should not go directly to our REAL database, I tried to restore to a dummy database. Below are my questions, - should I create this dummy database first before I could restore?
4
10278
by: Raquel | last post by:
How are the following two commands different as far as the 'end result' of the restores is concerned: 1. db2 RESTORE DB mydb 2. db2 RESTORE DB mydb TABLESPACE In other words, in the above case, what is the difference between 'database restore (performed in point 1 above) Vs the 'tablespace restore' (performed in point 2 above).
4
3807
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but my concern is, such big size db, I'm afraid something unexpected will destory all the effort. Who have related experience? Can you give some advice? Thanks in advance:)
9
14004
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was encountered on device "TBS_IDX". Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) t
6
3672
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 in load) to revover the tablespace? Thanks, Raj
2
5334
by: vj_dba | last post by:
Hi Group, I have a problem in restoring my tablespace, my database is running in ARCHIVAL logging, I created a tablespace, did some transaction, then took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace and tried to restore from the tablespace backup image, when I do this it's throwing error SQL2549N The database was not restored because either all of the table spaces
4
5744
by: africantract | last post by:
Hi There, We have an issue on our db2 restores. We do database dumps every night, and restore them to development servers every morning. This works fine with no errors. However if we backup those images to tape using Veritas netbackup, and then restore those images and try to restore them to the database, we get "The backup image is corrupt". If we run db2ckbkp against that image we get "Unable to decompress image from different platform"....
0
4094
by: zhif | last post by:
I tried to test this process on my personal laptop. Could you help me to take a look where is the problem as below? 1. I created a source database, name: db100 <-- db2 create db db100 2. Collect the source database tablespace containers’ information <-- db2 list tablespace containers for 0 show detail Then I got as below Tablespace Containers for Tablespace 0 Container ID = 0 Name ...
2
8604
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS USING S ON Z ON MYDB_NODE0000.out V ON DB20000I The UPDATE COMMAND OPTIONS command completed successfully. SET CLIENT ATTACH_DBPARTITIONNUM 0 DB20000I The SET CLIENT command completed successfully.
0
8739
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9089
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8983
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7832
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6575
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4412
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4668
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3107
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2037
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.