Re: Unable to restore a v7.02 saved database into v8.1 Your command should only be:db2 => restore database TESTDB from "/my/path"
taken at 20040108142834
Then:
db2 catalog db TESTDB as EAD on <whichever path TESTDBwas restored on>
db2 uncatalog db TESTDB
I presume here that the instance is also db2inst1 on the new system.
DB2 will recognize DB2 V7 as the source and the migration to V8 will be
automatic during the restore.
HTH, Pierre.
"Frank Stefani" <fs@despammed.com> a écrit dans le message de
news:4006A8CB.9A0ED7B8@despammed.com...
> Hi,
>
> due to an upgrade from a former DB2 v7.02, I backed up an entire
> database to a file in the local filesystem under Linux.
>
> I removed the old version completely an installed a fresh v8.1 DB2.
> After initialisation, I tried to restore the old database into
> the new DB2 version with db2cc or db2 command line interface.
>
> The process fails with the following error message:
>
> db2 => restore database EAD from
"/my/path/TESTDB.0.db2inst1.NODE0000.CATN0000.20040108142834 .001"
> SQL2036N The path for the file or device
> "TESTDB.0.db2inst1.NODE0000.CATN0000.2004010814283 4.001" is not valid.
>
> The path is doubtless correct, though ...
>
> Any help appreciated, TIA,
> Frank |