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

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

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,
Nov 12 '05 #1
2 2437
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.google. 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,

Nov 12 '05 #2
Cheers,

Worked a treat.

C

do****@yahoo.com (dotyet) wrote in message news:<6c**************************@posting.google. 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.google. 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,

Nov 12 '05 #3

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

Similar topics

10
by: Markus Enders | last post by:
Hi everybody, currently we use DB2 7.1 on several Solaris machines. Now we are planning, to migrate to SUSE Linux (newest version). I wonder, if we can keep our DB2 version 7.1, or if we need to...
8
by: Xela | last post by:
Hi A have a very annoying problem. I have written java strored procedures for DB2 v8.1. Their deployement and usage is fine as long as the server is a Windows one. But under Solaris 8 and Linux...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
5
by: Dave | last post by:
Compiled using g++ on linux and then I tried to execute it on Solaris. The error message was something like "can't execute a.out" - works ok on linux - ran chmod so Sun user has execute/read/etc...
0
by: Kirt Loki Dankmyer | last post by:
So, I download the latest "stable" tar for perl (5.8.7) and try to compile it on the Solaris 8 (SPARC) box that I administrate. I try all sorts of different switches, but I can't get it to compile....
15
by: Joe Weinstein | last post by:
Hi. Below is a simple JDBC program to insert and extract a numerical value. When ResultSet.getDouble() is called, the same program produces different output on solaris than it does on Linux. I...
0
by: AnonymousFC4 | last post by:
1) Debugger. Is gdb (or ddd) still the best tool to debug C++ prog a) on Linux? b) On Solaris? 2) IDE, can you debug C++ programms, using Eclipse-cdt on both Linux and Solaris? Other tools?...
13
by: Mary Lei | last post by:
Does anyone know the link to obtain the tarball for db2 8.1 for solaris running on AMD 64 bit ? This is the entire db2 installation on a new system that does not have db2. Thanks.
4
by: tkirankumar | last post by:
Hi all, This is regarding the issue I am facing while porting the my application from SuSe Linux to Sun Solaris. The Existing system details: Itanium boxes 1mhz 4 processor 8 gb machines with...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.