Copying files instead of restore - 12-01-2010 , 03:45 AM
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/
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.
Re: Copying files instead of restore - 12-01-2010 , 05:42 AM
On 2010-12-01 10:45, Willem Fischer wrote:
investigate why the restore failed, what error msg did you get during
the failed restore(s)?
Re: Copying files instead of restore - 12-01-2010 , 01:03 PM
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?
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.