tfh
Volume 18, Number 36 -- October 12, 2009

IBM's DB2 Pure Scale--Not Quite iDatabase V1

Published: October 12, 2009

by Timothy Prickett Morgan

A few weeks ago, in the wake of the launch of the Exadata V2 database machine from Oracle and Sun Microsystems, I got all excited about the possibilities that IBM might remember that it had similar database clustering technology back in 1996 for the AS/400 and that it could take today's Power Systems and build a powerful, yet relatively inexpensive, database cluster for i shops, something I dubbed iDatabase V1.

Imagine my excitement when I found out early last week, ahead of IBM's official announcement last Friday, of something Big Blue is calling DB2 PureScale, which is a database clustering technology for DB2 databases running on Power Systems linked together by InfiniBand switches. It was almost like Big Blue finally remembered it could do this and finally listened to five years of yammering on my part, and the past three years of Oracle's marketing for its Real Application Clusters.

DB2 PureScale is no iDatabase V1, however. It does everything right except two things: Support the i 6.1 operating system and the DB2 for i database. Well, at least until a whole lot of you start complaining to IBM and the business partners who manage your i relationship, and Big Blue wakes up and treats the i platform with the same respect it gives to the AIX platform.

DB2 PureScale is not a preconfigured rack of database and storage servers, like the Exadata V2 appliance from Oracle and Sun is. It is rather an add-on feature of IBM's DB2 V9.7 database for Unix, Linux, and Windows operating. This DB2 is radically different from the mainframe version of DB2 and the DB2 for i variant. But, as I think I have said a zillion times, DB2/400 had a feature called DB2 Multisystem that allowed a cluster of Power-based servers running OS/400 V3R7 and V4 releases to link through OptiConnect ports and present a single database image for RPG and COBOL applications to smack against as they ran online transactions. This is more or less what DB2 PureScale (which is being sold as Power HA DB2 PureScale) does because it is as much about adding resiliency to DB2 applications as it is to providing horizontal scaling that feels like the vertical kind of scaling you get with a big SMP box. (I have heard of this clustered databases behaving something like SMP boxes as diagonal scaling.)

The DB2 PureScale feature is only being made available on Power 550 midrange machines and Power 595 high-end servers running AIX 6.1 and DB2 V9.7. The server nodes are clustered together using InfiniBand switches, and the nodes are linked to the InfiniBand switches directly through the 12X I/O ports on the Power Systems. The 12X ports are, as you know, a variant of double-data rate InfiniBand, which provides 20 Gb/sec of bandwidth. (Quad-data rate InfiniBand is now going mainstream, and will almost certainly be a part of the future Power7 servers as a remote I/O linking technology.)

Interestingly, DB2 PureScale takes advantage of a neat little feature of InfiniBand called Remote Direct Memory Access, or RDMA for short, which allows one server to reach out across the InfiniBand fabric and reach right into the cache and main memory of another server node to get data. RDMA is not a new idea, but it has been a real pain in the neck making it work right. But the upshot is that it is wickedly fast and even DDR InfiniBand is fast enough that the database nodes look and act more like system boards in an SMP box than they do like distinct server nodes in a parallel database cluster. In essence, InfiniBand is the backplane in a funky kind of SMP getup. (I am simplifying a bit, but you get the idea.) The point is, this is a lot more efficient and takes a lot less time than having server nodes talk over the InfiniBand backbone through a TCP/IP networking stack and a PCI-Express InfiniBand host channel adapter.

DB2 PureScale also has another interesting architectural feature: a master database locking and caching server that all of the nodes talk to in order to get access to the memory on other nodes or to get access to database fields for updating the data in them. The way Oracle 11g Real Application Clusters works, all of the database nodes in the system are constantly bugging each other to make sure they can update a database field. So there is all of this chatter flying around before they can commit transactions. This central server allows all of the server nodes to see what data is locked all at the same time, which helps make a DB2 PureScale cluster scale more or less linearly as server nodes are added.

According to Bernie Spang, director of product strategy for the Information Management division of IBM's Software Group, this central locking node is mirrored because it would otherwise be a single point of failure for the PureScale cluster. Spang also says that no applications need to be changed for them to run on DB2 PureScale--a claim that Oracle has also made about its Exadata V1 and V2 database appliances--and that customers will not have to tune or tweak their applications for them to perform well.

Pricing for the DB2 PureScale was not divulged. It will be available in December. Scott Handy, vice president of marketing and strategy for the Power Systems division, did not want to talk about why the i 6.1 operating system or its integrated DB2 for i database were not supported or if they would ever be supported. The word on the street is that Linux will get support for this at some point (certainly on Power Systems and maybe on System x boxes), and so will Windows further down the road running on X64 servers. From what I hear, IBM is not going to support DB2 Pure Scale on servers running HP-UX or Solaris Unixes, even though it does support these platforms with DB2 V9.7.

Next week, I'll walk you through how this DB2 PureScale software can allow databases to scale and make some estimates about price and performance compared to standalone SMP boxes.


RELATED STORIES

Oracle-Sun Exadata V2, Meet iDatabase V1

Oracle Steers Through Application Spending Downturn

HP and Oracle Launch Database Machine, and So Can IBM with i

The System iWant, 2007 Edition

Forget Oracle 10g. Let's Talk About i5/OS V5g

DB2/400: The Heart of a Supercomputer Cluster?

Future iSeries Servers, Part 2



                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
HELP/SYSTEMS

Robot/CONSOLE monitors your System i
resources--lines, subsystems, controllers, servers,
printers, message queues, or jobs--automatically.

Anytime a resource is not in its expected state,
Robot/CONSOLE responds. It can start or
stop programs, vary devices off or on, send messages--
practically anything.

Lose the burden of monitoring resources manually.

Request your FREE Information Kit today!


Editor: Timothy Prickett Morgan
Contributing Editors: Dan Burger, Joe Hertvik, Brian Kelly, Shannon O'Donnell,
Mary Lou Roberts, Victor Rozek, Kevin Vandever, Hesh Wiener, Alex Woodie
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Vision Solutions:  Free software for measuring overall i5/OS system health
Manta Technologies:  Fall Sale on i training courses! Order by October 15 and SAVE 25%
S4i Systems:  Express manages System i, mainframe, and any LINUX, UNIX, AIX document files

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
Four Hundred Stuff
No Longer an IBM Partner, Randr Navigates the Open Source Track

Krengel Tech Eases XML Integration with DB2 Web Service Enabler

Aldon Eases Compliance, Project Management Burdens with Reporting Tool

QlikTech Welcomes Competition with IBM Cognos Express

Wine Management Systems Takes to the Cloud

Four Hundred Guru
Getting Started with RDi's Application Diagram, Part 1: Source Call Diagram

Passing an Entire Result Set as a Parameter: Part 1

Admin Alert: The Great CBU Survey and More

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
October 3, 2009: Volume 11, Number 40

September 26, 2009: Volume 11, Number 39

September 19, 2009: Volume 11, Number 38

September 12, 2009: Volume 11, Number 37

September 5, 2009: Volume 11, Number 36

August 29, 2009: Volume 11, Number 35

August 22, 2009: Volume 11, Number 34

TPM at The Register
Alpha-male Ellison issues $10m Exadata challenge

Cisco readies rack servers for the holidays

IBM throws DB2 Power cluster at Ellison's Exadata

EMC outs Atmos compute cloud

Sun adds Oracle Linux to ops tools

Parallels bares all with server hypervisor

Terracotta straps on Ehcache speed engine

Emerson shells out $1.2bn for Avocent

Unisys announces 10-to-1 stock compression

VMware bakes disaster recovery into vSphere stack

Citrix delivers Swiss Army Knife desktop virtualization

Mellanox jacks up revenue and profit guidance

THIS ISSUE SPONSORED BY:

Help/Systems
Infor
Bsafe Information Systems
VAULT400
WorksRight Software


Printer Friendly Version


TABLE OF CONTENTS
IBM's DB2 Pure Scale--Not Quite iDatabase V1

Early Views on iManifest: ISV Expectations, Public Misconceptions

News Flash: IT to Drive Economic Recovery

As I See It: The Greening of IT

The Power Systems Catalog Gets Skinnier

But Wait, There's More:

Reader Feedback on Moore's Law and the Performance Wall . . . Ballmer Dishes on Big Blue; Why Should Ellison Have All the Fun? . . . IBM Deals on Blade Chassis, Tivoli Provisioning Manager . . . Notes/Domino 8.5.1 Dances with the iPhone . . . Much Ado About IBM's Mainframe Monopoly; Once Again, the i Is Overlooked . . .

The Four Hundred

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement