I had a 3 day training last year on db2 udb 7.2 when we were looking at it for a Siebel project who died. Yes, DB2 is not as Oracle who works the same on all platforms. I found db2 udb 7.2 missing basic functionnalities like there is no truncate table, you had to use the DB2 loader and load /dev/null in order to empty/truncate a table...
The only time I used Oracle on different platforms was a while ago when we were using SQL*Forms 2.3 on DOS / Oracle 5 then moving the code to Oracle/MVS. Stephane -----Original Message----- Ryan Sent: Sunday, September 07, 2003 9:34 AM To: Multiple recipients of list ORACLE-L have you used DB2? How does it compare to Oracle? Ive seen tom kyte write that each platform that DB2 runs on is in essence a different database and you cant take code from one platform and move it to another. are the features comparable? what about cost? ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, September 07, 2003 8:54 AM > VERY interesting. They refused to do site licensing at a 20000 > installation here. Thank you for this tip. > > Rachel Carmichael wrote: > > >Oracle does site licensing... but only if you are a very very large > >corporation. Citibank (when I worked there) had one. The company I work > >for now has one. > > > >So I don't ask "do we have a license" when I want to install a new > >version of Oracle, even if it is a new platform > > > >One of the few things that is easier working in a rigid corporate > >environment > > > > > >--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > > > > > >>There's one thing that IBM can do, which Microsoft and Oracle can't > >>offer: They do site licenses as well as cpu and user licensing. That > >>just gives them an incredible advantage to management and others who > >>can > >>stop thinking about whether they should buy another server, move > >>stuff > >>from one server to the other, etc. I can't believe Oracle and > >>Microsoft > >>are not doing it (I think I can guess, but it's still not good). > >> > >>Mladen Gogala wrote: > >> > >> > >> > >>>I believe that the answer to Stephane's question is obvious: > >>>Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" > >>>is coming from. > >>> > >>>-- > >>>Mladen Gogala > >>>Oracle DBA > >>> > >>> > >>> > >>>-----Original Message----- > >>>DENNIS WILLIAMS > >>>Sent: Friday, September 05, 2003 5:30 PM > >>>To: Multiple recipients of list ORACLE-L > >>> > >>> > >>>Stephane > >>> We've been very excited about Oracle Standard Edition. Helped > >>> > >>> > >>stave off > >> > >> > >>>the interest in MS SQL. Given the budget pressures at many > >>> > >>> > >>organizations, > >> > >> > >>>I'm surprised we don't hear more about this alternative. > >>> > >>>Dennis Williams > >>>DBA, 80%OCP, 100% DBA > >>>Lifetouch, Inc. > >>>[EMAIL PROTECTED] > >>> > >>> > >>>-----Original Message----- > >>>Sent: Friday, September 05, 2003 4:09 PM > >>>To: Multiple recipients of list ORACLE-L > >>> > >>> > >>>Hi all, > >>> > >>>We're an Oracle shop, over 140 Oracle instances. > >>>Today, architecture has chosen IBM DB2 for BI projects. > >>>The next step I guessed will be to choose DB2 for the new > >>> > >>> > >>transactionnal > >> > >> > >>>applications also. > >>> > >>>IBM offers DB2 at 25% less than Oracle. > >>> > >>>I wonder if Oracle 10G will come with a new pricing structure ? > >>> > >>> > >>>Stephane Paquette > >>>Administrateur de bases de donnees > >>>Database Administrator > >>>Standard Life > >>>www.standardlife.ca > >>>Tel. (514) 499-7999 7470 and (514) 925-7187 > >>>[EMAIL PROTECTED] > >>> > >>> > >><mailto:[EMAIL PROTECTED]> > >> > >> > >>> > >>> > >>> > >>> > >>> > >>> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >>San Diego, California -- Mailing list and web hosting services > >>--------------------------------------------------------------------- > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB ORACLE-L > >>(or the name of mailing list you want to be removed from). You may > >>also send the HELP command for other information (like subscribing). > >> > >> > > > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! SiteBuilder - Free, easy-to-use web site design software > >http://sitebuilder.yahoo.com > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
