Migrating from DB2 UDB 6.x on Solaris to UDB 7.2 on Linux

[Cam Chapman]

Does anyone have any experience migrating a DB2 database off UDB 6.1
(Solaris) to 7.2 (Linux)? The database does not already exist on the
Linux box. Have created a DB2 instance fine. DB2 installation went ok
(no fixpacks installed yet though!) and can create sample database and
query.

In my naiivity as a non dba reformed developer, I've dumped the
database on the solaris box and am trying to perform a restore on the
Linux box using the dump file. The restore is stalling.

Everything I've read indicates no 'conversion' is required on the
database to promote the version so in theory the restore should work
ok - apparently not!

Anyone have any ideas around a solution for creating the database on
Linux.

I'm wondering if there's a way to generate a schema file from the
Solaris based database and run that into the Linux version? Is there
an easier way?

Cheers,

[dotyet]

Hi,

As far as my knowledge goes you cannot restore a soalris 6.1 database
backup on a linux 7.2 database. Cross Platform Backup/Restores are not
available for these versions of databases. It has something to do the
big-endian and little-endian stuff. They way to go would be like this:

Generate a Complete database schema from the solaris box.

$>db2look -d <db_name> {options}

Look at the db2look command in the reference manual for more or just
type db2look at your shell prompt, it will give some help.

Now take an export of all your tables using db2move utility. The data
files will be in ixf format.

$>db2move <db_name> export

Move the schema file and all the db2move related files to your linux
box using ftp or whatever.

Log in your Linux box and execute the above generated Database Schema
file. Make sure you have created the database before hand either using
db2 "create database" command or using some other scripts which might
be there in your scripts list.

$>db2 -tvf <schema_file>

Once that is done successfully, then go to the directory where you
have downloaded those export files, and then import/load them using
either of the following commands:

$>db2move <db_name> import

OR

$>db2move <db_name> load
This will populate your database with all the data you have in the
solaris box.

I can give you further help on importing stored procedures as well, if
you need.

Rest is fine..

hth,
dotyet

ca************* @infinity.co.nz (Cam Chapman) wrote in message news:<cb******* *************** ****@posting.go ogle.com>...

Does anyone have any experience migrating a DB2 database off UDB 6.1
(Solaris) to 7.2 (Linux)? The database does not already exist on the
Linux box. Have created a DB2 instance fine. DB2 installation went ok
(no fixpacks installed yet though!) and can create sample database and
query.

In my naiivity as a non dba reformed developer, I've dumped the
database on the solaris box and am trying to perform a restore on the
Linux box using the dump file. The restore is stalling.

Everything I've read indicates no 'conversion' is required on the
database to promote the version so in theory the restore should work
ok - apparently not!

Anyone have any ideas around a solution for creating the database on
Linux.

I'm wondering if there's a way to generate a schema file from the
Solaris based database and run that into the Linux version? Is there
an easier way?

Cheers,

[Cam Chapman]

Cheers,

Worked a treat.

C

do****@yahoo.co m (dotyet) wrote in message news:<6c******* *************** ****@posting.go ogle.com>...

Hi,

As far as my knowledge goes you cannot restore a soalris 6.1 database
backup on a linux 7.2 database. Cross Platform Backup/Restores are not
available for these versions of databases. It has something to do the
big-endian and little-endian stuff. They way to go would be like this:

Generate a Complete database schema from the solaris box.

$>db2look -d <db_name> {options}

Look at the db2look command in the reference manual for more or just
type db2look at your shell prompt, it will give some help.

Now take an export of all your tables using db2move utility. The data
files will be in ixf format.

$>db2move <db_name> export

Move the schema file and all the db2move related files to your linux
box using ftp or whatever.

Log in your Linux box and execute the above generated Database Schema
file. Make sure you have created the database before hand either using
db2 "create database" command or using some other scripts which might
be there in your scripts list.

$>db2 -tvf <schema_file>

Once that is done successfully, then go to the directory where you
have downloaded those export files, and then import/load them using
either of the following commands:

$>db2move <db_name> import

OR

$>db2move <db_name> load
This will populate your database with all the data you have in the
solaris box.

I can give you further help on importing stored procedures as well, if
you need.

Rest is fine..

hth,
dotyet

ca************* @infinity.co.nz (Cam Chapman) wrote in message news:<cb******* *************** ****@posting.go ogle.com>...

Does anyone have any experience migrating a DB2 database off UDB 6.1
(Solaris) to 7.2 (Linux)? The database does not already exist on the
Linux box. Have created a DB2 instance fine. DB2 installation went ok
(no fixpacks installed yet though!) and can create sample database and
query.

In my naiivity as a non dba reformed developer, I've dumped the
database on the solaris box and am trying to perform a restore on the
Linux box using the dump file. The restore is stalling.

Everything I've read indicates no 'conversion' is required on the
database to promote the version so in theory the restore should work
ok - apparently not!

Anyone have any ideas around a solution for creating the database on
Linux.

I'm wondering if there's a way to generate a schema file from the
Solaris based database and run that into the Linux version? Is there
an easier way?

Cheers,