Hi,

I found that simply copying a databases' files to the target directory
(C:\MYINST) and then doing "db2 catalog db MYDB" works better than a
(redirected) restore. The restore failed for us on some systems, while
the copying of files always worked. We're not using db2relocatedb/
db2inidb.

But I didn't find anything in the documentation that this is
supported. Are you aware of problems with this method, or anything I
should take care of? Or better still, where in the official
documentation is it written that this is a supported method?

db2inidb seems to assume that the database was online while the files
were copied. But I copy the files while the database is offline.

On 2010-12-01 10:45, Willem Fischer wrote:
My guess is that this method is not supported. I would instead
investigate why the restore failed, what error msg did you get during
the failed restore(s)?

/Lennart

Hi,

As Lennart already mentioned, it would be more important to solve your
redirected restore problem. Why does it not work? Is it possible that
you try to restore an image from a database which you created by your
copy procedure? How did your restore fail? What is the error message?
What does db2diag.log say?

We do not support copying files as a backup/restore solution, except
with db2relocate and flashcopy. Copying files can be unpredictable, even
if the database is offline.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/