SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 04:37 PM
| ||||
| ||||
 Unable to restore a v7.02 saved database into v8.1 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      |
|
02-26-2008, 04:37 PM
| |||
| |||
| Re: Unable to restore a v7.02 saved database into v8.1 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 ================================================== =================== |
|
02-26-2008, 04:37 PM
| |||
| |||
| 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 |
|
02-26-2008, 04:38 PM
| ||||
| ||||
| Re: Unable to restore a v7.02 saved database into v8.1 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 |
Linear Mode
