• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

This community can have members from outside your organization. DB2 Performance Tuning

  • Log in to participate

▼ Tags

▼ Similar Entries

Compiling with the D...

Blog: COBOL Cafe
DavidHT 0700000V0U
Updated
0 people like thisLikes 0
No CommentsComments 0

Accessing different ...

Blog: QMF Blog
QMFDevelopment 310000NG5J
Updated
0 people like thisLikes 0
No CommentsComments 0

REORG Performance Im...

Blog: Db2 for z/OS ...
ealameida 310002GWAR
Updated
0 people like thisLikes 0
No CommentsComments 0

Why the storage grou...

Blog: Thoughts from...
db2scope 310002R9XW
Updated
0 people like thisLikes 0
No CommentsComments 0

Unable to set DB2COM...

Blog: Thoughts from...
db2scope 310002R9XW
Updated
0 people like thisLikes 0
CommentsComments 1

▼ Similar Ideas

使用Flashcopy Image Co...

Ideation Blog: 主机知刊
tianna 310001QCY5
Updated
Votes 2 No CommentsComments 0

▼ Archive

  • January 2018
  • December 2017
  • October 2017
  • August 2017
  • July 2017
  • April 2015
  • March 2015
  • January 2015
  • September 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011

▼ Blog Authors

DB2 Performance Tuning

View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.) Entry list

Four More Reasons to Migrate from Oracle to DB2

DaveBeulke 2700023WUN | | Tags:  oracle 9.7 db2 vs. | 4,560 Views

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.
  • Add a Comment Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry
Notify Other People
notification

Send Email Notification

+

Quarantine this entry

deleteEntry
duplicateEntry

Mark as Duplicate

  • Previous Entry
  • Main
  • Next Entry
Feed for Blog Entries | Feed for Blog Comments | Feed for Comments for this Entry