467,922 Members | 1,308 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,922 developers. It's quick & easy.

Backup in Db2 Linux and Restore in DB2 Windows

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:
Its possible restore a linux backup at another system? Windows
Plataform?
What I have to do?
Id tryed many possibles but nothing work!!!
Can anybody help me???
Thanks a lot.

Abel Babini Filho

Nov 9 '06 #1
  • viewed: 4537
Share:
5 Replies

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.

Nov 9 '06 #2
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
Nov 9 '06 #3
"Knut Stolze" <st****@de.ibm.comwrote in message
news:ej**********@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.
Nov 10 '06 #4
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
Nov 10 '06 #5

Ok thanks 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
Nov 10 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Fabian Knopf | last post: by
2 posts views Thread by Buck Turgidson | last post: by
6 posts views Thread by Tim Penhey | last post: by
5 posts views Thread by zgh1970 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.