473,327 Members | 1,896 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,327 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 2435
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.