Iam new to DB2..just started working on it
worked previously on SQL Server..need to do data migration from a database to another both in DB2 but different versions..
can someone tell the pitfalls to look for while doing the migration

also i dont know how to transfer data from one database to another using Stored procedures..in SQL Server we could just put the name of the database eg:<dbname>.<username>.<tablename> and do the necessary operations..
how is it done in DB2??

and while restoring the database its giving the following error
"Not able to write to a read-only file"
actually i took back in one server and copied the dump file to another system and trying to restore it there ...what might be the possible reason for the error...tried a lot but no solution

Advanced thanx to ppl with solutions

hi

what is your db2 version and os?

In my case, the migration between as400 and db2 8.2 is via DRDA (federated server) and stores procedure.

abel.

My OS is Win 2k Pro and Db2 versions are 7.2 and 8.1
But the client i'm working for uses z/OS so i need to write stored procedures compatible with both WIN2K and z/OS

canu help me in this matter too along with the questions in the first msesage

you can use the db2 replication center of 8.1 or federated all db2 server in you 8.1 and view all system how if this was local system.

example.
in your db2 8.1 federated the server db2 7.1 as db27, and create nickname of a table exam. create nickname mytable for db27.mydb.mytable

you can user this table how if this was local table.

select * from mytable

IBM provide a migration tool now to help with SQL*Server to DB2 migrations.

http://www-306.ibm.com/software/data/db2/migration/

There's likely a redbook on it as well