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.
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
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?
Visit the new-look IDUG Website , register to gain access to the excellent content.