We run the I5/OS (AS400) version and Oracle 10g. There is no similarity whatsoever between i5 and z/os or luw versions of db2: completely different products with a common name. Many years ago I pointed that out in c.d.o.s. Only to be derided by the IBM "experts" there. I'm glad nowadays even IBM is finally admitting there are 3 versions of DB2 and they bear no common code whatsoever. Which one is more compatible with Oracle? Don't know and quite frankly: couldn't care less. Any notion that one can switch database products because they are "compatible" is doomed to failure. As IBM has proven for many years, with their different DB2 versions. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx Bill Ferguson wrote,on my timestamp of 13/10/2009 12:21 AM:
Does anybody on here work with both Oracle and DB2? I was wondering, merely for my own information (thankfully nobody has ever suggested this), if what Tom Kyte wrote many years ago is still applicable today (http://asktom.oracle.com/pls/asktom/f?p=100:11:6495007510621886::::P11_QUESTION_ID:1886476148373)? Specifically where he says: "What DB2 do you use on all platforms? Answer -- none, they have different DB2's for different architectures. (that report often seems to confuse things in DB2/OS390 with DB2/UDB -- "features they've had for years", that OS390 -- UDB, totally different code base, totally different architecture." Has IBM improved this 'initial' flaw, or is this still an issue with DB2?
-- //www.freelists.org/webpage/oracle-l