467,198 Members | 1,205 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Control Center doesn't find backup files

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
  • viewed: 1950
Share:
1 Reply
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.

Similar topics

6 posts views Thread by Franco Lombardo | last post: by
reply views Thread by Wolfgang Reissenberger | last post: by
1 post views Thread by stevenkblack@gmail.com | last post: by
3 posts views Thread by ºa¤Ö | last post: by
2 posts views Thread by kooltop@hotmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.