468,272 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

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 2631
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Web Master | last post: by
reply views Thread by demibee | last post: by
7 posts views Thread by Charles | last post: by
5 posts views Thread by Michael Reichenbach | last post: by
12 posts views Thread by Tomás Ó hÉilidhe | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.