Unix Technical Forum

Backup in Db2 Linux and Restore in DB2 Windows

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


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:38 AM
abelbfilho@gmail.com
 
Posts: n/a
Default 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:
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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 08:38 AM
jdokos
 
Posts: n/a
Default Re: Backup in Db2 Linux and Restore in DB2 Windows


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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 08:38 AM
Knut Stolze
 
Posts: n/a
Default Re: Backup in Db2 Linux and Restore in DB2 Windows

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 08:39 AM
Mark A
 
Posts: n/a
Default Re: Backup in Db2 Linux and Restore in DB2 Windows

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-27-2008, 08:39 AM
Knut Stolze
 
Posts: n/a
Default Re: Backup in Db2 Linux and Restore in DB2 Windows

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 02-27-2008, 08:39 AM
abelbfilho@gmail.com
 
Posts: n/a
Default Re: Backup in Db2 Linux and Restore in DB2 Windows


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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:02 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com