473,226 Members | 1,518 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,226 software developers and data experts.

Restore backup performed on Unix server to a Windows server

Hi All,

I understand in older versions of DB2/UDB this was not possible. The
following article explains how I might do this


Is this still a restriction in version 9.x? I'd specifically like to
restore a backup performed on an AIX server to a Windows server.

Christian Maslen

Aug 28 '07 #1
4 5720
On Aug 28, 1:55 am, Christian Maslen <christian.mas...@techie.com>
Hi All,

I understand in older versions of DB2/UDB this was not possible. The
following article explains how I might do this


Is this still a restriction in version 9.x? I'd specifically like to
restore a backup performed on an AIX server to a Windows server.

Christian Maslen
I don't know if V9 lets you do this, but definitely not in version 8.
AIX is big-endian and Windows is little-endian (among other problems).

The best way is to use db2look to pull the schema definition, and
db2move export/load to move the data. When doing this, I usually split
the db2look into 2 files, one without the foreign keys, and one with
only foreign keys. I do the following:

1. get db2look on source server (specify your own delimiter other than
semi-colon so triggers and stored procs will be created properly).
2. pull out the foreign keys from db2look into a separate file
3. edit db2look output for new containers for target server
4. run db2look on target server (without foreign keys)
5. run db2move export and zip up all db2move files and send to target
server (optional)
6. unzip db2move files and run db2move load replace on target server
7. create foreign keys extracted from db2look.

Aug 28 '07 #2
On Mon, 27 Aug 2007 22:55:29 -0700, Christian Maslen scribbled:
Hi All,

I understand in older versions of DB2/UDB this was not possible. The
following article explains how I might do this


Sorry, I don't think that article does explain how to backup/restore
between platforms (unless I've misunderstood your intent in referencing

From the article: "In the example provided later, we will be using two
Windows machines that are mapped to each other via a local network (it is
required that both machines have the same OS platform)" and later on: "If
you plan to use a UNIX environment, the same rules apply. Both machines
must have the same OS platform (an exception is a restore between SunOS
and HP)"
Is this still a restriction in version 9.x? I'd specifically like to
restore a backup performed on an AIX server to a Windows server.
The article's talking about v7. As Mark's already pointed out it's
definitely a restriction in v8. Looking at the v9 InfoCenter, the topic
"Backup and restore operations between different operating systems and
hardware platforms" [1] contains the following:

The supported platforms for DB2 backup and restore operations can be
grouped into one of three families:

* Big-endian Linux and UNIX
* Little-endian Linux and UNIX
* Windows

The fact that Windows is its own family doesn't bode well for your
particular situation, and indeed the following seems to confirm that
backup & restore from AIX -Windows is not possible in v9:

A database backup from one platform family can be restored on any system
within the same platform family. For Windows operating systems, you can
restore a database created on DB2 UDB V8 on a DB2 Version 9 database
system. For Linux and UNIX operating systems, as long as the endianness
(big endian or little endian) of the backup and restore platforms is the
same, you can restore backups that were produced on DB2 UDB V8 on DB2
Version 9.

Hence, some combination of db2look & db2move (as detailed in Mark's
response) would seem to be simplest way forward.

[1] http://publib.boulder.ibm.com/infoce...2luw/v9/topic/

Aug 28 '07 #3
My thanks to Mark and Dave for their answers. I suspected it wouldn't
work. The ref quoted from by Dave is at (for others to ref):


Gotta love that word "Endianness"

We develop and deploy on AIX but often want to take a database with
data home on Windows. I thought I could cover this by using the same
table spaces on both. To the DB2 developers, consider this post a
feature request ;o)


Aug 29 '07 #4
Backups can only be restored in the same "family" of OS.
Backup in WIN and restore to a AIX box won't work.
You can use db2move to do this...

Sep 3 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Tim Morrison | last post by:
MSDE2000 I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...
by: mikkel | last post by:
Hello, Im working on a project where I have to bring at production database in house for regression testing. The people who hosts the database (db2 version 7) has made a backup of the base...
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2,...
by: ReeseDog | last post by:
First time DB2 user here. I have a backup from a unix box around 8.1. I am trying to restore this backup on a windows box 8.2 (demo version) I am not sure how the original backup was created...
by: chow.justy | last post by:
Dear all, I'm a new beginner of DB2. I face 2 question during restore the data. I have 2 DB2 servers on my company. Server A is running on V7.2 and Server B is running on v8.2 (Enterprise...
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...
by: abelbfilho | last post by:
I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure:...
by: danceli | last post by:
I have two servers, using SQL server 2000. I was asked for implementing hourly Backup 3 databases in one server and restore those databases to another server. Could anyone give me the detailed...
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
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...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
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...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
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"....
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
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.