By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,333 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,333 IT Pros & Developers. It's quick & easy.

Migrate DB2

P: n/a
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

Mar 28 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
Mar 28 '06 #2

P: n/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.
Mar 28 '06 #3

P: n/a
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


Mar 28 '06 #4

P: n/a
Thank you very much for the responses.

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

Thanks

Mar 29 '06 #5

P: n/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).
Mar 29 '06 #6

P: n/a
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
Mar 29 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.