----- Original Message ----- From: "Rivian - RS Husada" <[EMAIL PROTECTED]> Sent: Monday, October 08, 2001 3:14 PM Subject: Fw: Oracle/DB2
> > ----- Original Message ----- > From: "Adityo Kristianto" <[EMAIL PROTECTED]> > To: "DB2 Community" <[EMAIL PROTECTED]> > Cc: "Software Group" <[EMAIL PROTECTED]>; "Ayu A. Bisono" > <[EMAIL PROTECTED]> > Sent: Monday, October 08, 2001 8:17 AM > Subject: Re: Oracle/DB2 > > > > DB2ers, > > > > Please pass this on to your colleagues as many as possible.. Some good > > points why DB2 is better that oracle.. > > THanks.. > > > > best regards, > > Adityo Kristianto ([EMAIL PROTECTED]) > > IBM Certified Solution Expert - DB2/Business Intelligence > > IT (DM/CM/BI) Specialist > > Software Group - IBM Indonesia > > Phone : (62-21) 523-8699, Fax : (62-21) 251-2933 > > > > > > I'm not sure I agree with the statement about CCA vs. SQL*Net. We use a > > tool that users can access and install either client. Both work well. > > Early versions of CCA reqired that NT workstation users have local admin > > rights to install it. The software handled this by switching to a > > superuser > > account and then running the install. This may have been your problem but > > without further details, I really can't say. > > > > We converted from Oracle to UDB because of licensing costs. Oracle wanted > > a > > tremendous amount of money after their initial licensing agreement. Web > > access costs were out of this world. Oracle has since changed their > > licensing requirements and have placed it in line with UDB. For example, > > you may be able to negotiate a per CPU license instead of per user for > > Oracle. This is a big difference. We still have several applications > > running Oracle. Our platform preference is IBM. > > > > I find it easier to manage UDB than Oracle. I spend much less time on > UDB. > > > > You really need to look at the locking strategy between Oracle and UDB. > > There is a difference and can have an impact on how your application runs. > > After the conversion, we found that the application was deadlocking under > > UDB but not Oracle. The main reason is because IBM follows the ANSI92 > > standards were Oracle makes some assumptions and follows a different > > strategy. I suggest you talk to your sales rep for both products and > maybe > > even a tech rep if that's possible. > > > > One other advantage of UDB is that it's very easy to take an offline > backup > > of one system and create another. For example, I want to create a > > development database from production. The redirected restore option is > > very > > easy to set up. It's more time consuming to do this with Oracle. > > > > Backups and restores are much faster under UDB. We have a 7gig database > > under UDB that backs up in 8 minutes. The same size database under Oracle > > would take over an hour. Oracle's concept of a hotbackup is to copy files > > from a source location to a backup location outside of the Oracle > database. > > UDB is done through the database itself. Cold backups in Oracle require > > the > > system be shutdown. Again, UDB is done through the database and no > > shutdown. Much easier, much, much faster. > > > > Both databases are very scalable and run on many different platforms. > > > > Peter J. Krawetzky, DBA > > IBM Certified Solutions Expert > > DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 > > > > > > > * Gunadarma Mailing List ----------------------------------------------- * Archives : http://milis-archives.gunadarma.ac.id * Langganan : Kirim Email kosong ke [EMAIL PROTECTED] * Berhenti : Kirim Email kosong ke [EMAIL PROTECTED] * Administrator: [EMAIL PROTECTED]
