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

DB2 Restore V8.2 Express

P: n/a
Hey.

I am trying to import the following file:

C:\SMARTMUN.0.DB2.NODE0000.CATN0000.20060926082904 .001

with the following command:

RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

But get the following error:

SQL2542N No match for a database image file was found based on
the source database alias "SMARTMUN" and timestamp
"20060928082904" provided.
>From what I under stand, all parameters are correct... Exectly the same
command worked fine on migrating to V9, but when trying on V8.2 it does
not work... Please help!

Thanks

Ian

Oct 2 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
In article <11**********************@i3g2000cwc.googlegroups. com>,
ci*****@gmail.com says...
Hey.

I am trying to import the following file:

C:\SMARTMUN.0.DB2.NODE0000.CATN0000.20060926082904 .001

with the following command:

RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

But get the following error:

SQL2542N No match for a database image file was found based on
the source database alias "SMARTMUN" and timestamp
"20060928082904" provided.
From what I under stand, all parameters are correct... Exectly the same
command worked fine on migrating to V9, but when trying on V8.2 it does
not work... Please help!

It looks like a backup file taken on a Linux/Unix system. If so, you
can't restore it on a windows system.
Oct 2 '06 #2

P: n/a
Thanks, but the backup was taken on a windows Server 2003 machine.
Trying to restore it to the same machine...
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
ci*****@gmail.com says...
Hey.

I am trying to import the following file:

C:\SMARTMUN.0.DB2.NODE0000.CATN0000.20060926082904 .001

with the following command:

RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

But get the following error:

SQL2542N No match for a database image file was found based on
the source database alias "SMARTMUN" and timestamp
"20060928082904" provided.
>From what I under stand, all parameters are correct... Exectly the same
command worked fine on migrating to V9, but when trying on V8.2 it does
not work... Please help!


It looks like a backup file taken on a Linux/Unix system. If so, you
can't restore it on a windows system.
Oct 2 '06 #3

P: n/a
In article <11**********************@i3g2000cwc.googlegroups. com>,
ci*****@gmail.com says...
Thanks, but the backup was taken on a windows Server 2003 machine.
Trying to restore it to the same machine...
Then your backup directory/file should be something like this:

C:\SMARTMUN.0\DB2\NODE0000\CATN0000\20060926\08290 4.001

It can't be the one you mentioned.

Oct 2 '06 #4

P: n/a
Ian.. I dont know if it's a typo or what but ... your cmd to restore
the database is :
RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING; but the file has
the following timestamp 20060926082904...20060928 is not the same as
20060926.....

/Roger

Oct 2 '06 #5

P: n/a
Ian
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
ci*****@gmail.com says...
>Thanks, but the backup was taken on a windows Server 2003 machine.
Trying to restore it to the same machine...

Then your backup directory/file should be something like this:

C:\SMARTMUN.0\DB2\NODE0000\CATN0000\20060926\08290 4.001

It can't be the one you mentioned.
Gert,

DB2 9 finally fixed the directory tree nightmare for backups on
Windows boxes, so a Windows backup file looks like every other
platform.

Ian, I don't think you can restore a V9 backup image into a V8
engine. There are all kinds of changes to the catalog, etc. that
V8 won't understand.

Your best best will be to export the data from the V9 database
and import it into a V8 database.

Oct 3 '06 #6

P: n/a
In article <7%uUg.672$rS.39@fed1read05>, ia*****@mobileaudio.com says...
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
ci*****@gmail.com says...
Thanks, but the backup was taken on a windows Server 2003 machine.
Trying to restore it to the same machine...
Then your backup directory/file should be something like this:

C:\SMARTMUN.0\DB2\NODE0000\CATN0000\20060926\08290 4.001

It can't be the one you mentioned.

Gert,

DB2 9 finally fixed the directory tree nightmare for backups on
Windows boxes, so a Windows backup file looks like every other
platform.
Thanks, Ian. I didn't notice it. Sorry, other Ian :)
Oct 3 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.