Migrate DB2

[DMina]

Hello people,

I would like your assistance here.
I have a DB2 V8 database on Windows 2003.
I would like to migrate this database on AIX 5.3 (keep the same
database version).
Any documentation how to achieve this?
Any procedure or migration tool?
Will a backup and restore do?

Thank you

[Serge Rielau]

DM***@laiki.com wrote:

Hello people,

I would like your assistance here.
I have a DB2 V8 database on Windows 2003.
I would like to migrate this database on AIX 5.3 (keep the same
database version).
Any documentation how to achieve this?
Any procedure or migration tool?
Will a backup and restore do?

Backup/restore will not work due to the difference in endian-nes.
You will need to look at db2move or my backup schema article:
http://www.ibm.com/developerworks/db...dm-0602rielau/

If you have more than one schema and they are not well encapsulated the
procedures can be easily extended.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Mark A]

<DM***@laiki.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

Hello people,

I would like your assistance here.
I have a DB2 V8 database on Windows 2003.
I would like to migrate this database on AIX 5.3 (keep the same
database version).
Any documentation how to achieve this?
Any procedure or migration tool?
Will a backup and restore do?

Thank you

Use db2look to pull all the DDL and run that on your new system (changing
the container names of tablespaces as needed). Make sure you use the right
options to pull all the DDL including the tablespaces and bufferpools.

Then use "db2move export" to pull the data, and then "db2move load" to load
the data back to the new system.

[Mondongo]

Another thing you can do is to create your new AIX db from scratch and
federate it with your existing one on windows 2003.

Use db2look...etc. etc. (as stated in your responses) to create the
empty objects in your AIX db and then import the data either with
insert into or with declare cursor + load (depending on the size of the
table to migrate).

Small tables: use insert into
Big tables: use declare cursor + load.

I hope this helps.

DM***@laiki.com wrote:

Hello people,

I would like your assistance here.
I have a DB2 V8 database on Windows 2003.
I would like to migrate this database on AIX 5.3 (keep the same
database version).
Any documentation how to achieve this?
Any procedure or migration tool?
Will a backup and restore do?

Thank you

[DMina]

Thank you very much for the responses.

Another question: how do i move user defined functions and procedures?

Thanks

[Mark A]

<DM***@laiki.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...

Thank you very much for the responses.

Another question: how do i move user defined functions and procedures?

Thanks

They will be in the db2look output (if you use the correct parms to extract
them). However, you will have put them in a separate file to reapply them,
and include a terminator such as @ at the end of each object The ";"
terminator will be used at the end of each statement), and then use the
following to create them:
db2 -td@ -vf file-name (where file-name contains the syntax of the
procedures, UDF's, and triggers).

[Serge Rielau]

DM***@laiki.com wrote:

Thank you very much for the responses.

Another question: how do i move user defined functions and procedures?

Thanks

SQL Functions and Procedures should be part of db2look.
You may have to run the script a few times due to dependencies.
For external UDF/Procedures (C/Java/CLR) you have to make sure you
migrate the libraries.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab