472,976 Members | 1,246 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

can I restore a database from one system to another?

We do not have a DBA available, and this is a development environment,
hence I was asked to do the work. I am not a DBA. I need some help to
clarify my understanding of DB2 recovery and I am reading the following
as well.
http://publib.boulder.ibm.com/infoce...help/index.jsp
I have a database say DB_INV on machine A and the database is backed
up to tape, I am going to create a second system, say machine B with a
database called DB_INV which is empty, can I run the db2 restore
command to restore from tape the database DB_INV from machine A to
machine B?

With the exception of running the db2 restore command, are there
anything that I need to do to ensure
a. the database on machine B is identical to the database on machine
A? identical to the time the backup was created. Assuming the backup is
run via "db2 backup db" command, do I need to recover the data
dictionary, catalogue etc?
b. Are there any commands I can use to ensure the restore is
successful? or that as long as there is no error at the end of the
restore?
c. I assume the db2 restore command will just overwrite whatever I
initially created as an empty database on machine B and create the
necessary tablespace, data dictionary, etc, right?
d. After the restore is finished, can I just run db2start to bring up
the database on machine B even machine A with DB_INV is up at the same
time? Will there be any conflict etc ? (say my experience as a SA, I
cannot bring up two machines with the same hostname and IP on the same
segment, will I have similar problem after the database restore).

As far as the command line is concerned, can I just use
db2 restore db DB_INV from some_directories with 4 buffers buffer 512
replace existing parallelism 4 without prompting;
Or do I need to use
db2 restore db DB_INV into DB_INV from some_directories with 4 buffers
buffer 512 replace existing parallelism 4 without prompting;
thanks
anna

Nov 12 '05 #1
2 4094

an**********@yahoo.com wrote:
We do not have a DBA available, and this is a development environment, hence I was asked to do the work. I am not a DBA. I need some help to
clarify my understanding of DB2 recovery and I am reading the following as well.
http://publib.boulder.ibm.com/infoce...help/index.jsp
I have a database say DB_INV on machine A and the database is backed
up to tape, I am going to create a second system, say machine B with a database called DB_INV which is empty, can I run the db2 restore
command to restore from tape the database DB_INV from machine A to
machine B?

With the exception of running the db2 restore command, are there
anything that I need to do to ensure
a. the database on machine B is identical to the database on machine
A? identical to the time the backup was created. Assuming the backup is run via "db2 backup db" command, do I need to recover the data
dictionary, catalogue etc?
b. Are there any commands I can use to ensure the restore is
successful? or that as long as there is no error at the end of the
restore?
c. I assume the db2 restore command will just overwrite whatever I
initially created as an empty database on machine B and create the
necessary tablespace, data dictionary, etc, right?
d. After the restore is finished, can I just run db2start to bring up
the database on machine B even machine A with DB_INV is up at the same time? Will there be any conflict etc ? (say my experience as a SA, I
cannot bring up two machines with the same hostname and IP on the same segment, will I have similar problem after the database restore).

As far as the command line is concerned, can I just use
db2 restore db DB_INV from some_directories with 4 buffers buffer 512
replace existing parallelism 4 without prompting;
Or do I need to use
db2 restore db DB_INV into DB_INV from some_directories with 4 buffers buffer 512 replace existing parallelism 4 without prompting;
thanks
anna


Nov 12 '05 #2
Anna ,

have you some more detail
System A / System B Operating system
Are the systems equally resourced in terms of disk

Nov 12 '05 #3

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

Similar topics

9
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...
4
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2,...
0
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2,...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in 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...
4
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...
5
by: abelbfilho | last post by:
I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure:...
1
by: mlaris | last post by:
Howdy, We are experiencing a bizarre problem under Linux attempting to restore a DB2 database. The backup was created on this machine, and is being restored to the same machine, but changing the...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.