I have a problem

I have a full backup (done with control center) and a new server.
Im trying to restore the backup but I cant. I use the control center to restor but it give me errors about timestamp and the database alias.
Ive checked and the timestamp is correct.

Can Anyone help me?

What are the correct steps?

I only have the backup

http://www.dbforums.com/t854783.html

sorry it was so urgent that I forgot to put info

Its a clean install
Windows 2000 advance server
DB2 8.1 Express

I have a full backup done with control center

Archivo:
165744.001

Directorio:
D:\Backup\pepe.0\DB2\NODE0000\CATN0000\20041112

commands::

RESTORE DATABASE pepe FROM "D:\Backup\pepe.0\DB2\NODE0000\CATN0000\200411 12\" TAKEN AT 20041112165744 TO "D:" INTO pepe2 NEWLOGPATH "D:\DB2\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;




error

SQL2542N No match for a database image file was found based on
the source database alias "pepe" and timestamp
"20041112165744" provided.

Explanation:

The backup image file filename consists of a database alias and a
timestamp component. A filename is constructed from the source
database alias and timestamp parameters provided in the Database
Restore call. No filename existed in the source directory that
matched based on the source database alias and timestamp
provided. If this error was received from an automatic
incremental restore then a required image was not found based on
the timestamp and location in the database history.

User Response:

Ensure that the database backup image resides on the media
source. Resubmit the operation by specifying a correct timestamp
to result in a match.

If this error was received from an automatic incremental restore,
check the database history for the corresponding backup entry
and verify that the location listed matches the actual location
of the backup image. Either update the database history and
retry the operation to result in a match or issue a RESTORE
INCREMENTAL ABORT command to cleanup any resources that may have
been created during processing.

Try this:

????
Ive done that

that is the command that i wrote

thanks it worked
my life is save now

Can anyone post the corrected code as an example. I have been fighting a very similar problem all day and cant seem to find a working example

The trick is to use the correct (shortened) directory path in Windows. Look carefully at the path statements in the backup and restore above to figure it out.

what if i move the file to f:\backup ?
my code
db2 restore database NAMTEST from f:\backup taken at 20051028165340 to FB2TEST into NAMTEST Redirect

DB2 on Windows needs the full path structure to be in place, but only wants the top level directory in the command.

It won't work any other way.

so I need on the server
f:\namdwh.0\db2test\node0000\catn0000\
but i only put f:\namdwh.0?

You'd actually only put f:\ in that case.

Although I expect you'd want a sub directory, ie. f:\backup or something like that.

ie. f:\backup\namdwh.0\db2test\node0000\catn0000\

and supply f:\backup to the command.

my code:


D:\Program Files\IBM\SQLLIB\BIN>db2 restore database NAMTEST user db2admin using 29DmJj13 from f:\NAMDWH.0 taken at 20051028165340 to f:\DB2TEST into NAMTEST redirect

my error:
SQL2542N No match for a database image file was found based on the source
database alias "NAMTEST" and timestamp "20051028165340" provided.

I have moved the backup file under its native file directory of F:\NAMDWH.0\DB2TEST\NODE0000\CATN0000\20051028

The file name is 165340.001

I realy dont know what I am doing wrong. It has to be something simple...

Read my last post again...

FROM f:\NAMDWH.0 won't work.

from f:\ should.

I have to be overlooking something because by changing my code to "From f:\" I recieved the same error.

Is this case sensitive? Is there a way to validate my backup image?