Conor O'Mahony's Database Diary

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

Want to get DB2 pureScale at an Affordable Price?

with 4 comments

Last year, IBM released the pureScale feature for DB2, which allows you to create shared-disk clusters for database transaction processing. One of the great things about DB2 pureScale is that it provides near linear scale-out efficiency, which means that when you add a node to the cluster, you almost get a full node worth of additional processing power. In other words, the overhead involved in coordinating cluster activities for DB2 pureScale is relatively small.

Of course, this is in contrast to Oracle RAC, where there are numerous public accounts of poor scale-out performance. Although, to be fair, many of those Oracle RAC horror stories are probably due to people not making their applications cluster-aware, or due to people not having the skills to properly tune those systems. In other words, if you are willing to spend enough time and money, I reckon a lot of those Oracle RAC systems can achieve reasonable scale-out-efficiency. Of course, with DB2 pureScale, you don’t have to worry about any of that. With DB2 pureScale, you simply add or remove nodes as you please. The DB2 pureScale approach does not require that your applications be cluster-aware, and does not require complex tuning. DB2 pureScale actually delivers on the promise of being truly application transparent.

Okay, that’s enough background information… on to the actual subject of the blog post. A few months ago, IBM made DB2 pureScale available on x86 servers. That was a big first step towards making DB2 pureScale clusters more affordable. And last week, IBM took another big step in that direction by announcing that DB2 pureScale is now included in DB2 Workgroup Server Edition. DB2 Workgroup Server Edition is our mid-range offering with a list price of $15k per socket.

This means that, for instance, you could purchase a couple of these $15k DB2 Workgroup Server Edition licenses for use with two x86-based servers, each of which has one socket with 4 CPU cores. You could then create a 2-node cluster, where each node has a hefty 4 CPU cores. You would enjoy the great performance of DB2, as well as the continuous availability offered by DB2 pureScale. And all this for a very good price (that is subject to standard software discounts).

DB2 pureScale and DB2 Workgroup Server Edition offer a great alternative to running Oracle RAC for small clusters. Not only is the IBM combination attractive from a pricing standpoint, it is also attractive from a performance and subsequent ease of scaling standpoint.

Written by Conor O'Mahony

October 14, 2010 at 3:38 pm

Posted in DB2 for LUW, pureScale

4 Responses

Subscribe to comments with RSS.

  1. Hello,

    Interesting move. I am curious, at what pricepoint would this place a minimal, but complete PureScale cluster (commodity server, standard storage, Infiniband hardware, software)?

    Frederik Engelen

    October 15, 2010 at 2:37 pm

    • We are 10 years old and run mysql. (lamp stack) open source roll your own etc. Now we have a 6.5 gigabyte heavy text full indexes this way and that for our sec comment letter data. We are looking for a vertical partitioning solution to speed up web queries which can take a minute or more. We do not want to recode an application solution – but want a database architecture that knows what to do.

      ted turner

      November 4, 2010 at 3:50 pm

  2. Hi Frederik,

    It all depends on the configuration. There are almost endless possibilities. But let’s take one possible configuration…

    – Two IBM System x 3650 M3 servers. Each server has 6 CPU cores, 96 GB of RAM, and InfiniBand. List price: $35k.
    – DB2 Workgroup Edition at $15k/socket. List price: $30k.

    This is a decent system, which would give you good performance with a total list of $65k. Of course, discounting (especially on the software side) will reduce this.

    Note that you could go less expensive hardware by reducing the number of CPU cores and the amount of RAM.

    And, if you have a relatively small number of users, you could instead choose Authorised User licensing for the DB2 software, which is $442/user.

    Regards,
    Conor.

    Conor O'Mahony

    October 17, 2010 at 11:12 pm

    • Hi Conor, I think in your configuration extra hardware are needed for hosting CFs of db2 purescale.

      Jack Li

      February 11, 2011 at 11:43 pm


Leave a comment