Advertisements

Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for July 2009

High Performance Database for .NET Developers

leave a comment »

The Credit Union Times has a story about how 240 credit unions have moved to the Fiserv XP2 system. The story mentions that XP2 uses a .NET development framework and an IBM DB2 database. This is one of a number of recent successes for DB2 in .NET environments, and reflects the investment IBM has made in building DB2 support for .NET. Not only does DB2 offer drivers for .NET, it also provides tools that are fully integrated in to Visual Studio .NET. When you consider that IBM makes available a fully-functional version of DB2 called DB2 Express-C for no charge, it makes a very compelling proposition for .NET developers. They can take advantage of DB2’s industry-leading performance for the price of an open source database 🙂

Advertisements

Written by Conor O'Mahony

July 30, 2009 at 9:26 am

Posted in Uncategorized

The Benefits of a Conference While Sitting at your Desk

leave a comment »

On 19 August, IBM will host another Data in Action virtual conference. The conference will feature:

  • Donald Feinberg, Distinguished Analyst at Gartner, who will answer your questions about the IT challenges, trends, and innovations that are shaping the data management world.
  • A special panel of database users who will discuss their experiences with the latest release of DB2 and answer your questions.
  • Interactive booths like DBA Efficiency, Developer Productivity, and Optimized Infrastructure that allow you to download literature, view demos, and chat with IBM experts.
  • The Networking Lounge where you can chat with Michael McBride, President of IDUG, who will help you locate the best in DB2 training and information.
  • And much, much more…

Make sure to register for this virtual conference today!

Written by Conor O'Mahony

July 27, 2009 at 10:50 am

Posted in Uncategorized

Oracle Price Increases Examined for Sample Configuration

leave a comment »

Last week, I blogged about More Oracle Price Hikes.

  • In June 2008, Oracle raised the prices of its products by between 15 percent and 20 percent.
  • In March 2009, Oracle changed their multiplier for systems using the POWER6 CPU, in effect raising their prices by 33 percent on POWER6.
  • In July 2009, Oracle raised the price of their Management and Tuning packs for Oracle Database Enterprise Manager by more than 40 percent.

That’s a lot of price increases in little over a year! It can be difficult to picture what these price increases mean. To help, let’s consider a sample configuration: a server with 4 POWER6 CPUs running Oracle Database Enterprise Edition, Partitioning, Diagnostic Pack, and Tuning Pack. For this relatively simple configuration, Oracle has increased its list prices by 61 percent in the time period between May 2008 and July 2009.

Oracle Price Increases Between May 08 and Jul 09

This is quite a large price increase in such a short mount of time. Especially when you consider that, in this tough economic climate, everyone is operating under increasingly tight budgets. Depending on the status of contracts with Oracle, it could mean a 61 percent increase in annual maintenance and support costs for this sample configuration. Hopefully, Oracle customers have price increase protection in their current contracts, and are not being hit too hard by these increases. Of course, even if they were smart enough to put such protections in place, then they still need to worry about what happens when their current contracts expire and they need to renegotiate with Oracle. One can’t help wondering why companies should pay 61 percent more for the exact same levels of maintenance and support.

Written by Conor O'Mahony

July 27, 2009 at 9:50 am

Posted in Cost, Oracle Database

Solitaire Compares IBM DB2 and Oracle Database

with one comment

The Solitaire Report titled Whitepaper: DB2 Performance on IBM System p® and System x® contains lots of interesting information.

Solitaire analyzed different aspects of database operations on the IBM® System p® platform and the IBM® System x® platform. Their report is not based on benchmarking. It is based on “real world” data from more than 4,100 production systems. It is part of the ongoing Operational Characterization Master Study (OPMS) that has been conducted over the last 19 years.

The report has information about performance, reliability, staffing, and time-to-market effects. For instance, here is a chart that show the normalized amount of monthly outage time for IBM DB2 and Oracle Database on IBM System p. Note that this data was drawn from an analysis of 653 core systems.

Normalized Monthly Outages on IBM System p

Also, here is a chart that show the normalized staffing levels for IBM DB2 and Oracle Database on IBM System p. If you sum the data, IBM DB2 requires 43% less staff than Oracle Database on System p.

Relative Staffing for IBM DB2 and Oracle Database on IBM System p

You can get all the details behind these charts and a lot more interesting information in the Solitaire Report.

Written by Conor O'Mahony

July 24, 2009 at 12:07 pm

DB2’s New Features for Oracle Database Users

with one comment

As I’m sure you’ve heard by now, DB2 9.7 has several new features that make it easy for Oracle Database users to work with IBM DB2. They even make it easier to switch from Oracle Database to DB2:-) Today, IBM developerWorks published an article from Serge Reilau about the new Oracle Compatibility features in DB2. You can read the article at DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows. It includes information about the new concurrency features, data types, built-in functions, SQL support, PL/SQL support, script support, and more. Of course, Serge also talks about the restrictions and limitations.

Written by Conor O'Mahony

July 23, 2009 at 7:15 pm

How to Scale Transaction-Intensive Workloads in the Cloud

leave a comment »

IBM is actively working on making DB2 in the Cloud easy to deploy for its users. You may have read the recent announcements regarding DB2 in the cloud, including the partnerships with Amazon, Rightscale, and others. You may also have seen the news that you can transfer DB2 licenses for use in the cloud. Ready-to-deploy Amazon Machine Images, RightScripts, ServerTemplates, and more help you get up and running quickly.

There are already videos on the Web that show you how to deploy DB2 in the cloud. Next week, IBM is taking you on the next step on this journey by hosting a Webcast titled Scalability in the Cloud—Fact or Fiction?. In this Webcast, IBM and xkoto will show you step-by-step, how to scale transaction-intensive workloads in the cloud. They will also discuss the pitfalls that are commonly encountered when doing this.

Written by Conor O'Mahony

July 22, 2009 at 6:20 pm

Posted in Cloud, DB2 for LUW

IDUG North America 2010 – Call for Presentations

with one comment

Independent DB2 Users Group (IDUG)The International DB2 Users Group (IDUG) is currently accepting proposals for sessions at the IDUG North America Conference, which will be held in Tampa, Florida on 10-14 May, 2010. You can submit proposals at www.idug.org/call-for-presentations-idug-2010-north-america.html.

Written by Conor O'Mahony

July 21, 2009 at 5:03 pm

%d bloggers like this: