Cross Platform db Restore

satish mullapudi

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

Patrick Finnegan

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

Patrick Finnegan

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