By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

Cross Platform db Restore

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.