467,880 Members | 1,259 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,880 developers. It's quick & easy.

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
  • viewed: 3881
Share:
2 Replies

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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by GL | last post: by
reply views Thread by Andy J | last post: by
13 posts views Thread by Andy K | last post: by
11 posts views Thread by Chris | last post: by
4 posts views Thread by africantract | last post: by
5 posts views Thread by abelbfilho | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.