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