I received some great comments and questions based on the blog entry/video about the many new features in DB2 Cobra. One of the more interesting questions was asked “How much work or how compatible is the new DB2 with Oracle?”The answer DB2 is very compatible, so compatible in fact, that many people have migrated from Oracle to DB2 in only days.
So what are the reasons or justification for management to consider changing their database from Oracle to DB2? The top four reasons I have heard recently are:
· Oracle contract pricing continues to go up. Every time we look Oracle wants more money because we had to add CPU cores to get application performance.
· Application performance for our BI OLAP Oracle work does not respond. We always have to rewrite the SQL or create new indexes to make it work. When we tried it on DB2, their optimizer automatically rewrites the SQL avoiding the manual SQL rewrite, improving application performance and overall response time.
· DB2 disaster recovery and HADR feature is much better than any Oracle’s stand-by or their fail-over solution. Now that the application is compatible with DB2 there is no reason to risk the business because of an Oracle failure.
· Saving IT budget money is paramount these days and with our Oracle database, we continue to spend money on expanding disk requirements. DB2 data compression and the new index compression provide a way to reduce disk costs, improve database performance and minimize backup and recovery while reducing disk requirements and saving money.
Converting your database from Oracle to DB2 is very easy. You can save money for your company, your IT department, and maybe your job by migrating today.
_______________________________________________________Dave Beulke is an internationally recognized DB2 consultant, DB2 training and DB2 education instructor. Dave helps his clients improve their strategic direction, dramatically improve DB2 performance and reduce their CPU demand, saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments. Search for more of Dave Beulke’s DB2 Performance blogs on DeveloperWorks and at www.davebeulke.com.