This is a discussion on Backup in Db2 Linux and Restore in DB2 Windows within the DB2 forums, part of the Database Server Software category; --> I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.00 1 and I want to restore it on Windows (in another ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.00 1 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure: D:\DADOSADV.0\db2\NODE0000\CATN0000\20060812\ and rename the backup image file to 230006.001 When I type (Prompt DOS) > db2ckbkp -H 230006.001 and I receive this result ===================== MEDIA HEADER REACHED: ===================== Server Database Name -- DADOSADV Server Database Alias -- DADOSADV Client Database Alias -- DADOSADV Timestamp -- 20060812230006 Database Partition Number -- 0 Instance -- db2 Sequence Number -- 1 Release ID -- A00 Database Seed -- 6D0ED4BC DB Comment's Codepage (Volume) -- 0 DB Comment (Volume) -- DB Comment's Codepage (System) -- 0 DB Comment (System) -- Authentication Value -- 255 Backup Mode -- 0 Includes Logs -- 0 Compression -- 0 Backup Type -- 0 Backup Gran. -- 0 Status Flags -- 1 System Cats inc -- 1 Catalog Partition Number -- 0 DB Codeset -- UTF-8 DB Territory -- LogID -- 1149180924 LogPath -- /microsiga/db2/db2log/ Backup Buffer Size -- 4194304 Number of Sessions -- 1 Platform -- 12 The proper image path would be: DADOSADV.0\db2\NODE0000\CATN0000\20060812\230006.0 01 Image header dumped -- NO VERIFICATION PERFORMED. ================================================== But when I type (Prompt DOS) > db2ckrst -d DADOSADV -t 20060812230006 -d database I receive this error: Error: db2ckrst - No image found for timestamp 20060812230006 Return code of -8 seen at line 1363 ================================================== ======== QUESTIONS: Itīs possible restore a linux backup at another system? Windows Plataform? What I have to do? Iīd tryed many possibles but nothing work!!! Can anybody help me??? Thanks a lot. Abel Babini Filho |
| |||
| No, you cannot restore a backup from linux to windows. They are not binarily compatible. You can restore Windows to Windows, Linux to Linux and Unix to Unix. To go crossplatform you have to use db2move or the like. |
| |||
| jdokos wrote: > > No, you cannot restore a backup from linux to windows. They are not > binarily compatible. You can restore Windows to Windows, Linux to > Linux and Unix to Unix. To go crossplatform you have to use db2move or > the like. Things have improved in V9 compared to V8. As long as the endianess between the backup-platform and the restore-platform is the same, you can restore the backup image - except for Windows. Thus, moving backups between Linux and the various Unix platforms is not an issue any longer: http://publib.boulder.ibm.com/infoce...c/c0005960.htm -- Knut Stolze DB2 Information Integration Development IBM Germany |
| |||
| "Knut Stolze" <stolze@de.ibm.com> wrote in message news:ej06ec$3bh$1@lc03.rz.uni-jena.de... > Things have improved in V9 compared to V8. As long as the endianess > between > the backup-platform and the restore-platform is the same, you can restore > the backup image - except for Windows. Thus, moving backups between Linux > and the various Unix platforms is not an issue any longer: > http://publib.boulder.ibm.com/infoce...c/c0005960.htm > > -- > Knut Stolze > DB2 Information Integration Development > IBM Germany It looks like it only helps with Linux on zSeries and Linux on Power PC being compatible with UNIX. DB2 backups on all other Linux platforms are still incompatible with DB2 UNIX backups. |
| |||
| Mark A wrote: > It looks like it only helps with Linux on zSeries and Linux on Power PC > being compatible with UNIX. DB2 backups on all other Linux platforms are > still incompatible with DB2 UNIX backups. It's the endianess that matters. I don't know about the PC-version of Solaris and if DB2 is supported on that platform. If it is, I'd think that you can move Linux little-endian backups to such an environment. -- Knut Stolze DB2 Information Integration Development IBM Germany |
| ||||
| Ok thankīs a lot for all responses... []īs Abel Knut Stolze escreveu: > Mark A wrote: > > > It looks like it only helps with Linux on zSeries and Linux on Power PC > > being compatible with UNIX. DB2 backups on all other Linux platforms are > > still incompatible with DB2 UNIX backups. > > It's the endianess that matters. I don't know about the PC-version of > Solaris and if DB2 is supported on that platform. If it is, I'd think that > you can move Linux little-endian backups to such an environment. > > -- > Knut Stolze > DB2 Information Integration Development > IBM Germany |