Xkoto GRIDSCALE, on the other hand, can run DB2 on AIX, Linux, Sun, HP, or Windows. GRIDSCALE can use DB2 Enterprise Server Edition, Workgroup Edition, Express Edition, or Express-C Edition data servers on brand name or white box commodity servers.
Both solutions assert themselves to be "continuous" availability solutions, but
Xkoto GRIDSCALE supports DB2 V8.2, V9.1, V9.5, and V9.7. I wouldn't be surprised if Xkoto is even supporting DB2 9.8. IBM DB2 pureScale supports, well, DB2 V9.8.
If you visit Xkoto's website, you'll note that they also talk about Reducing IT Costs. You might just be able to retire your old 8, 16, or 32-way Sun servers with DB2 Enterprise Edition Licenses, and swap for Linux 4-Way clusters with DB2 Workgroup Edition licenses instead - you could achieve greater performance at a fraction of the hardware and licensing costs.
Some people are looking at DB2 9.7 for its HADR dirty read capability. If you want the 9.7 HADR dirty reads, get ready to buck up for full DB2 LUW licenses for the HADR server instead of just the one CPU cost of DB2 9.5 and earlier. Now, if you are going to have to pay full boat for your DB2 LUW licenses on the active and DR server - but you only get read access on DR - then why not spend a few extra dollars on GRIDSCALE to make both servers active with true continuous availability and the scalability of two actives? If done correctly, there's likely a way to swap out two 8-way servers (one active and one HADR) for two 4-way servers which are BOTH active and realize net cost savings with improved performance and scalability.
Full disclosure here - when I first learned about Xkoto GRIDSCALE a few years ago I thought "Great, here's another way for organizations to throw money at hardware to try to solve performance problems." It seems that IBM DB2 pureScale is yet another opportunity to spend a lot of money on expensive hardware in pursuit of solving performance problems.
Well, let me shoot you straight (as we say in Texas). The world has an obesity problem. People are increasingly overweight (I read this in Reader's Digest ). And, you know what? Our data centers are overweight and bloated too - energy is wasted and license costs are inflated.
If you put your DB2 database server transaction processing costs on a diet (yes, this means tuning) so that transactions complete with lower CPU and I/O costs, then:
So, if the "saved" system capacity is re-invested to double throughput on a given server (2X), and you clone a tuned server instead of a bloated, un-tuned server (1X), now your Active-Active pair can achieve performance at a factor of 4X (2 x 2X) instead of (2 x 1X) 2X. In fact, it would take 4 un-tuned servers (1X) to achieve the same 4X performance as two well-tuned servers.
Ouch - that last paragraph might have hurt your brain. Let me spell it out for you in dollars. Working with 8-way servers, each server might cost $300K and database licenses might cost 8x33K, or $250K (rounding down to allow some discounts). So, each server runs $550K (plus energy costs). If you put your database transaction processing costs on a diet and tune your servers, 4X performance will cost you two servers at $550K, or $1.1M. If you just throw hardware at performance and don't optimally tune, then 4X performance will cost your organization 4 x $550K, or $2.2M - plus double the energy costs and floor space. If you spend $80K on performance analysis and tuning tools and only 1/4 FTE on database tuning efforts, you still just saved $1M. In this economy, your fiscal prudence will shine.
Using DBI's Brother-Panther®, you can achieve 30-90% CPU utilization reductions in SIX mouse clicks or fewer. Your first mouse click could show:
With just one more mouse click, you can discover all of the Tables contributing I/O to a tablespace and quickly learn which tables are the I/O heavy hitters along with which tables have I/O problems:
Give us a third mouse click, and we will show you which SQL/XML statements are driving I/O to any selected table:
Grant us just one more mouse click, and we'll give you a physical design solution or solutions that will likely reduce your overall workload cost by 30-90%, lower your CPU utilization, increase your SRP and lower I/O costs, and measurably improve application response times and SLA attainments.
That's it. If you work with DBI, we'll help you lower your IT costs and improve application performance in fewer than a half dozen (6) mouse clicks. If we made database tuning any easier or more fun, we'd have to reclassify our company with the Internal Revenue Service (IRS, or taxing authority for non-US readers) as a shrink wrapped video game provider. Look for the Nintendo Wii Edition of our software next year.
Get started with a Proof of Concept. CONTACT DBI or give us a call toll free in the US at 1-866-773-8789 or international at 1-512-249-2324. We'd be happy to give you a briefing on Xkoto Gridscale as well - just let us know.
Thanks for reading. Hope this helped you learn about the differences between IBM DB2 pureScale and Xkoto Gridscale. This blog post took four hours to write.
Post from : http://www.dbisoftware.com/blog/db2_performance.php
President & CEO, DBI
IBM GOLD Consultant and Data Management Champion
Host of The DB2Night Show™