Mark,
I had an alternate request again; SA said that the other box
does not have that kind of disk space as porduction; they asked me to
restore
that 5 month old dump file into same production Box.
I am afraid of putting a rick on real production box. If they
insist to do so; what can I do to restore to same box in production
without rick current
production.
My cold dump is in server itself and this is dataware house DB
cold dump and very huge crossed other 2 disk directories.
Thanks for help!!
Sue



mark.[Email address protected]
09/29/2006 03:18 PM


To
Sheuehua Leufuh/NYC-NY/US/Marsh/[Email Address Removed] address protected]

Subject
Re: How to restore db cold dump to different machine








Sue,
Is the data actually stored on the server or is it stored out on a SAN?
Can the SA do the mksysb just to bring up DB2? If not you'll need to
install DB2 on that box. Once that's done, you can still recover to the
other box if you want, but you'd have to do a Redirected Restore. The
backup you have will be looking to build the tablespaces in the same
containers with the same directories as the original Productoin database.
Therefore, you need to "redirect" the tablespace containers to a new path.

Your restore will look something like this:

db2 restore database dbname from /db2backup to /dbdir redirect without
rolling forward; <<<---- This will start the restore process and then
complete with an error message saying the containers need to be reset.

db2 "set tablespace containers for 0 using (file
'/filesystemname/dbname/tsname/dms_cat.dbf' 25800)"; <<<<---- You need
to do a set tablespace container for each tablespace in your database.
db2 "set tablespace containers for 1 using (path
'/filesystemname/dbname/tmpspace/dms_temp')";
db2 "set tablespace containers for 2 using (file
'/filesystemname/dbname/tsname/dms_data.dbf' 2234000)";
db2 "set tablespace containers for 3 using (file
'/filesystemname/dbname/tsname/dms_big_data.dbf' 640)";
db2 "set tablespace containers for 4 using (file
'/filesystemname/dbname/ixname/dms_indx.dbf' 1093600)";
db2 "set tablespace containers for 5 using (path
'/filesystemname/dbname/tsname/SYSTOOL')";
db2 "set tablespace containers for 6 using (path
'/filesystemname/dbname/tsname/QCTEMPTS')";

db2 restore database dbname continue; <<<--- This will complete the
restore

Mark Talens
Certified Consulting I/T Specialist
DB2 UDB for Linux, Unix and Windows
DB2 Tools for zSeries and Multiplatform


IBM Data Management Solutions
600 Anton Blvd. Costa Mesa, CA 92626
Voice: (714) 438-6149 Fax: 714-438-6199

IBM Only: T/L 925-6149, Mark Talens/Costa Mesa/[Email Address Removed] Sheuehua Leufuh/NYC-NY/US/Marsh/[Email Address Removed] [Email address protected]
From: mark.[Email address protected]




**********************************************************************
This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page