How does Db2 pureScale work?

Db2 pureScale adopts many of the same concepts and terminology as the well-established Db2 for z/OS data sharing technology.

How does DB2 pureScale work icon Triton Multiple Db2 instances, or “members” accept and service incoming Db2 work with all of them accessing a single copy of the data.

To stop multiple processes all updating the same data the PowerHa pureScale Server (also known as the Coupling Facility) is responsible for co-ordinating the activities of all of the Db2 members in the pureScale group.

The CF holds shared locking information and cached data pages of interest to one or more members of the group. Each member has direct access to the CF via an InfiniBand high-speed network interconnect, minimizing the performance overhead.

 

Transparent Application Scaling

Db2 pureScale has been designed to minimise the impact to the applications running in the cluster. No complex re-writes are required and so extra capacity easily be added with no interruption to service.

 

Db2 Scalability

With Db2 pureScale technology, you can grow and shrink your cluster on demand, as your business needs grow or subside. Along with flexibility, Db2 pureScale offers breakthrough efficiency. To demonstrate this, IBM scaled Db2 pureScale technology out to 128 members on IBM Power systems.

Results show near linear scaling out to 128 members in the cluster:

  • At 64 nodes, 95 percent scalability—or efficiency—in the system
  • And even at 128 nodes, test results show an impressive 84 percent efficiency!

 

Workload Balancing

This allows work to be intelligently distributed to various member Db2 systems based on how busy each one is.

 

Resilience

It is possible to run to coupling facilities in a duplexed arrangement, with Db2 automatically keeping primary and secondary CF in syc. With dual CFs and multiple Db2 members all hosted in separate physical boxes a CF or a physical disk still allows processing to continue this providing true “active/active” Db2 clustering.

Find out more about the latest features and how Db2 purescale works.
 


Why choose Triton for your Db2 pureScale implementation?

We provide Db2 pureScale consultancy and services to help organisations plan and implement IBM’s groundbreaking technology.

Contact Triton for more information


 
 

pureScale-Business-Benefits-Icon

Find out how Db2 pureScale can help you reduce IT costs and bring high availability to critical business applications

purescale-IT-Execs-Icon

Db2 pureScale for IT Execs –
A top level view