By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Control Center doesn't find backup files

P: n/a
I have taken a backup of a production database and copied it to a test
server. I'm attempting to use the Control Center to create the
database from the backup. However, when I get to the screen to select
the backup to restore from, there are no backup files visible through
the Control Center even if I navigate to where I copied the backup
file. Is there a reason why my backup files don't show up through the
Control Center? Thanks. Is there a better way to restore this backup?
DB2 version 8.2 and Windows 2003.

Mar 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On the receiving system, the Control Center cannot display the backup image
copy source because it did not take it. Your receiving system Database
Recovery History file does not have the entry that the backup was made on
another system and you just copied the file.
You back up on the source sytem to X;\somedir

You need to move the whole path to the receiving system.
X;\somedir\dbname.0\instname\node0000\catn0000\YYY MMDD
The file you put there should be: HHMMSS.001 which is the image of your
backup.

Even then the Control Center on the system where you copied this will not be
able to see the recovery history file and therefore will not be able to show
you the the source files for your restore.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Matt" <ma*******@gmail.com> a écrit dans le message de news:
11**********************@i40g2000cwc.googlegroups. com...
I have taken a backup of a production database and copied it to a test
server. I'm attempting to use the Control Center to create the
database from the backup. However, when I get to the screen to select
the backup to restore from, there are no backup files visible through
the Control Center even if I navigate to where I copied the backup
file. Is there a reason why my backup files don't show up through the
Control Center? Thanks. Is there a better way to restore this backup?
DB2 version 8.2 and Windows 2003.


Mar 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.