IBM DB2 pureScale hailed as “absolutely ideal” for retail sector
July 23rd, 2010

An ideal fit for the retail sector, DB2 pureScale from IBM is going to allow organisations to increase capacity when they need it at the really busy times like Christmas and the January sales and scale back at times of less demand.

Based on the industry leading System z data sharing architecture, DB2 pureScale integrates IBM technologies to keep critical systems available 24/7. DB2 pureScale allows organisations to have multiple database servers in a system that all share a common set of disks providing both scalability, availability and application transparency.

Triton Consulting recently sent a team of DB2 experts to the IBM labs in Boeblingen Germany on a research and development project into DB2 pureScale. After seeing DB2 pureScale in action, DB2 LUW expert Clair Ross said "If you're a retailer with a high volume online transaction environment then pureScale is going to be absolutely ideal for you. You'll be able to increase capacity when you need to at the really busy times like Christmas and the January sales and scale back at the times when you're experiencing less demand. Plus, we've not mentioned here the need for continuous availability, pretty much every organisation would like continuous availability but for online retailers it's essential."

Continuous Availability
DB2 pureScale keeps critical systems available all the time, giving uninterrupted access to data throughout both planned and unplanned outages. Fast recovery and data availability is assured, even with large clusters, by utilising the centralised locking capability of PowerHA pureScale.

In situations where one or more servers fail, whether due to hardware or software problems; the workload balancer automatically recognises which servers are available and sends transactions across to these servers without application interruption. Whilst this is happening, DB2 pureScale is doing a fast crash recovery on the failing node. By using automatic workload balancing to ensure that no node in the system is over loaded, DB2 will route transactions or connections to the least heavily used server.

Zero Downtime for Planned Outages
DB2 pureScale allows routine hardware maintenance, operating system changes or other configuration changes to be carried out by simply removing the relevant server from the cluster. The workload balancer redistributes transactions to the other servers in the cluster. This is done with complete transparency to the application and no interruption to the environment meaning that planned outages can be carried out whenever necessary rather than waiting for that late-night on Sunday window. This is vital for global organisations with users accessing their systems 24/7.

Capacity on Demand
Being able to quickly respond to rises in workload has become a competitive advantage. IT teams need the ability to respond quickly to change requests and provide extra capacity at peak times.

DB2 pureScale is designed to allow organisations to grow and shrink their server cluster on demand. This can be done without application changes and with no interruption to the business. Organisations that experience large peaks and troughs in their workload can add more capacity during that period and remove it when workloads reduce.

Cost Savings
Instead of over-provisioning environments to handle peak times, organisations can license the machines they want for the time they need. Customers can choose to pay for the additional cores only on the days that they use them. This means that a server can be added for a few days during those peak times and released when it is no longer needed, without additional cost.

Application Transparency
DB2 pureScale is transparent to the application and can be implemented with no changes to the underlying application code. Additional servers can be added without the need for application developers to re-design their applications.

Triton Consulting are IBM Premier Business Partners and have expert knowledge of DB2 both in mainframe and midrange environments. Having expertise in both areas means that our consultants can bring their years of mainframe data sharing experience together with their knowledge of DB2 for midrange and so are ideally placed to provide support on DB2 pureScale implementations.

Download the podcast http://www.triton.co.uk/confessions-of-a-db2-geek/detail.php?id=21&s=2  

IBM DB2 pureScale http://www-01.ibm.com/software/data/db2/linux-unix-windows/editions-features-purescale.html