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

Restoring DMS DB from multipe backup files

P: n/a
I'm trying to restore a backup from a DMS DB2/2 database. The original
DB has 3x 1Gb containers in the user tablespace. So the backup has 3
files, bearing the time of the backup as file name, with extensions
..001, .002 and .003. The files are placed into a
d:\dbname.0\db2.0\yyyymmdd directory tree, as does DB2/2 when performing
the backup. I created a similar DMS 3x1Gb DB on another machine for the
restore. But when I launch:

db2 restore db... taken at... from d:\, d:\, d:\
or
db2 restore db... taken at... from d:\

I always get the SQL2522N error telling me there is more than one file
for the given timestamp. Of course! There are 3. But they're
complementary. What's the trick?
--
Luc Le Blanc
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Don't think there's any trick with this Luc, but what release of DB2
server are you restoring this image on? If that's the format of the
directory tree then I have to assume that you're restoring a V2 image
from DB2 on OS2? Is that right?

Can you provide a listing of the actual, full, directory path to these
images? Along with the TAKEN AT timestamp that you're providing?

Thanks.
kdr
Luc Le Blanc wrote:
I'm trying to restore a backup from a DMS DB2/2 database. The original
DB has 3x 1Gb containers in the user tablespace. So the backup has 3
files, bearing the time of the backup as file name, with extensions
.001, .002 and .003. The files are placed into a
d:\dbname.0\db2.0\yyyymmdd directory tree, as does DB2/2 when performing
the backup. I created a similar DMS 3x1Gb DB on another machine for the
restore. But when I launch:

db2 restore db... taken at... from d:\, d:\, d:\
or
db2 restore db... taken at... from d:\

I always get the SQL2522N error telling me there is more than one file
for the given timestamp. Of course! There are 3. But they're
complementary. What's the trick?


--
------------------------------------------------------------------
Kelly D. Rodger IBM Canada
DB2 UDB Backup and Recovery Toronto Lab
------------------------------------------------------------------

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.