Unable to restore a v7.02 saved database into v8.1

[Frank Stefani]

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

[Kelly D. Rodger]

Correct, but incorrect. Try RESTORE... FROM /my/path, without
specifying the file itself. To specify a particular backup image if
there are multiple images in that path, then use the TAKEN AT
<timestamp> option.

The RESTORE path is a directory or device where the backup image exists,
just as with the BACKUP command.

Hope that helps.
kdr
Frank Stefani wrote:

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 ...

--
================================================== ===================
Kelly D. Rodger IBM Canada
DB2 UDB Development Backup & Restore
================================================== ===================

[Pierre Saint-Jacques]

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" <[e-mail]> a écrit dans le message de
news:40***************@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

[Frank Stefani]

Thank you both, Kelly and Pierre, for the successful hint!

FWIW, I don't understand why db2cc prints a different
SQL statement, which was my starting point for doing
it on the DB2 shell. That command *did not* work, your
hint *does*

Regards,
Frank