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

Cross Platform db Restore

Hi Everyone,
Am facing an issue. Am using DB2 UDB EE v8.2 on AIX platform. I have
taken the offline backup of a db( say SAMPLE ) on AIX platform. Now I
want to restore the same on Linux platform. In fact on any other
platform like Win<->UNIX / Win<->LInux / Win<->AIX etc. I have heard
that DB2 supports cross platform restore operation, but am not sure on
how to perform. Can anybody pls help me out !

Thanks in Advance....

Satish
Jun 27 '08 #1
4 2806
On Jun 6, 8:00 am, satish mullapudi <satishmullapud...@gmail.com>
wrote:
Hi Everyone,
Am facing an issue. Am using DB2 UDB EE v8.2 on AIX platform. I have
taken the offline backup of a db( say SAMPLE ) on AIX platform. Now I
want to restore the same on Linux platform. In fact on any other
platform like Win<->UNIX / Win<->LInux / Win<->AIX etc. I have heard
that DB2 supports cross platform restore operation, but am not sure on
how to perform. Can anybody pls help me out !

Thanks in Advance....

Satish
Possible work around.............

Log on to Linux or Windows box.
Catalog the remote AIX database. Remote AIX machine must be visable
on the network.
Backup the remote AIX database locally i.e. on to the Linux or Windows
machine.
Restore the backup to the Windows/Linux machine.


Jun 27 '08 #2
Ian
Patrick Finnegan wrote:
>
Possible work around.............

Log on to Linux or Windows box.
Catalog the remote AIX database. Remote AIX machine must be visable
on the network.
Backup the remote AIX database locally i.e. on to the Linux or Windows
machine.
Restore the backup to the Windows/Linux machine.
This will not work. BACKUP requires an instance attachment, and the
backup is done at the database server, not at the client.

Jun 27 '08 #3
On Jun 7, 12:49 am, Ian <ianb...@mobileaudio.comwrote:
Patrick Finnegan wrote:
Possible work around.............
Log on to Linux or Windows box.
Catalog the remote AIX database. Remote AIX machine must be visable
on the network.
Backup the remote AIX database locally i.e. on to the Linux or Windows
machine.
Restore the backup to the Windows/Linux machine.

This will not work. BACKUP requires an instance attachment, and the
backup is done at the database server, not at the client.

I have done this several times from AIX to Windows.
Catalog the remote database.
Attach to the remote database.
Backup the remote database to a local drive.
Restore the database locally.

Jun 27 '08 #4
Ian
Patrick Finnegan wrote:
On Jun 7, 12:49 am, Ian <ianb...@mobileaudio.comwrote:
>Patrick Finnegan wrote:
>>Possible work around.............
Log on to Linux or Windows box.
Catalog the remote AIX database. Remote AIX machine must be visable
on the network.
Backup the remote AIX database locally i.e. on to the Linux or Windows
machine.
Restore the backup to the Windows/Linux machine.
This will not work. BACKUP requires an instance attachment, and the
backup is done at the database server, not at the client.


I have done this several times from AIX to Windows.
Catalog the remote database.
Attach to the remote database.
Backup the remote database to a local drive.
Restore the database locally.
Not using BACKUP DATABASE you haven't. Maybe using 'db2look' and/or
db2move, but that's not the same thing as a database backup.

Jun 27 '08 #5

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

Similar topics

7
by: Web Master | last post by:
Are there any good websites or books that deal with cross platform XML? I'd like to target Internet Explorer/Netscape Navigator 5 or later, as well as Opera, possibly konqueror on Linux as well. ...
0
by: demibee | last post by:
Thought this might be of interest to some out there... For those who've never encountered it, it's a free, open-source, cross-platform GUI library (Windows/Mac/Linux). Forte's Agent 2.0 will be...
1
by: Ian | last post by:
I'm trying to restore a database backup taken from a server running DB2 8.1 FP6a on Windows 2000 Server on to a new machine running Windows Server 2003 (also 8.1 FP6a), but I'm getting the...
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...
7
by: Charles | last post by:
I'd like to develop a simple cross-platform application in C++. I'd like it to run in Windows, OS X, PC-BSD and Linux. From my research, it seems I should use Qt or Gtk as a graphical library. Do...
5
by: Michael Reichenbach | last post by:
After working with script languages, notepad(++) and co. and several other ide`s I found something which really improved my productivity (Visual Studio 2005). It`s imho better then dev-cpp... I...
12
by: Tomás Ó hÉilidhe | last post by:
I don't know the first thing about cross-platform GUI programming, so I'd like to ask a few quick questions. Which library is best for someone who appreciates portable programming and correct...
1
by: Vinod Sadanandan | last post by:
Cross Platform Migration An Unproblematic Approach (Windows-UNIX ) Oracle 10\11g The principal restriction on cross-platform transportable database is that the source and destination platform...
1
by: soumajit | last post by:
Hi.. I use db2 udb v9.5 on AIX platform. now i need to shift the db to a windows box. is it possible to take a db back up from the AIX platform and restore the same on the windows platform?
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.