473,231 Members | 1,874 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

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
5 4947

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Al | last post by:
Hi, I'm new to DB2 and have what may be a stupid question: Is it possible to backup a DB2 UDB 7.x database on a Linux server and restore it on a Win2k server (both running the same version of...
1
by: Fabian Knopf | last post by:
Hi @ll, how can i backup my DB2 V8.1 database and install it to another machine where DB2 V8.2 is running. Cu, Fabian
2
by: NEXUZ6 | last post by:
Can I restore a backup taken from a DB2 7.2 on Linux to a 8.1 Win ? How ? Tkx
2
by: Buck Turgidson | last post by:
I have an SAP development system running on Linux. It is not a critical system, but I would like a restore-able backup. I have taken an offline backup, but I am unable to restore it. I am...
6
by: Tim Penhey | last post by:
Hi All, I have a java web server (Tomcat) running a web application that uses PostgreSQL for all of the data. All of the management of the application is done through the web application and I...
2
by: maha | last post by:
Dear DB2 experts! I'm stuck with the following issue: from a customer I got a DB2 backup file, created on an AIX-32 machine that I cannot restore on my windows platform. I admit that I posses...
4
by: Christian Maslen | last post by:
Hi All, I understand in older versions of DB2/UDB this was not possible. The following article explains how I might do this ...
5
by: zgh1970 | last post by:
Hi, Friends, default DB2 compression library. I am wondering if this option will have any new restriction on RESTORE in the following. (Can I used that backup imsage for restore at the...
0
by: glubber | last post by:
I have a cronned perl script that runs on a different server. when I try to restore it to the server below things dont copy across correctly. the target server is described below. debian 4.0...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.