Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    5

    Unanswered: Oracle to DB2 migration question

    We are planning a miration from Oracle to DB2 9.7 fp7.
    The migration will be from 1 Oracle db to 3 separate DB2 db's, each containing data not in the other 2 db2 dbs.

    In Oracle the application has been referencing and using a record's sequential ID.

    We will have to come up with a solution that will mimic the properties of a seuqential ID in Oracle in DB2.

    However the real question is that since the 3 db2 databases are currently planned to be separate, how can we do this to ensure that each record in the 3 different databases will be unique to the entire system.

    I am thinking go dpf or have a 4th db which funstions as one that issues the id/sequence or whatever.

    Would appreciate your thoughts.

    Thanks
    Last edited by sarge2013; 03-27-13 at 11:26.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Can't you define ranges in each of the db? Using a fourth db to have the sequence generation seems a bit of over kill.

    For eg, if you can define the column as bigint, then
    in db-A - the ids can be from 1 to 3 000 000 000 000 000 000
    in db-B- the ids can be from 3 000 000 000 000 000 001 to 6 000 000 000 000 000 000
    etc


    The possible range of int and bigint values in db2 are :

    Smallest INTEGER value -2 147 483 648
    Largest INTEGER value +2 147 483 647
    Smallest BIGINT value -9 223 372 036 854 775 808
    Largest BIGINT value +9 223 372 036 854 775 807


    BTW, what is the reason behind separating the Databases?

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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