Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    6

    Question Unanswered: DB2 stored procedures and data migration

    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

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    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.

  3. #3
    Join Date
    Jan 2005
    Posts
    6
    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

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    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

  5. #5
    Join Date
    Aug 2004
    Location
    London, UK
    Posts
    31

    Here's a link

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •