Deploying the DB2 pureScale Feature with EMC Symmetrix VMAX

In today's highly competitive marketplace, it is important to deploy a data processing architecture that not only meets your immediate tactical needs but also can grow and change to adapt to your future strategic requirements. In December 2009, IBM introduced the DB2 pureScale Feature for Enterprise Server Edition software (DB2 pureScale Feature). The DB2 pureScale Feature builds on familiar and proven design features from the IBM DB2 for z/OS database software (DB2 for z/OS), bringing the industry-leading technology and reliability of DB2 for z/OS to the open systems platform.

Aruna De Silva (adesilva@ca.ibm.com), Testing Support Specialist, IBM

Aruna De Silva  photoAruna De Silva is a member of the Quality Assurance (QA) team for DB2 on Linux, Unix, and Windows product at the IBM Toronto software laboratory. Aruna is an IBM Certified Advanced Database Administrator for DB2 9. In addition, he holds numerous IT certifications from IBM and other vendors in database, hardware, and systems administration. Aruna is actively involved in DB2 product integration, implementing and testing complex product stacks, and designing and testing HA and DR solutions. He is also the key contact person for EMC Storage within IBM Information Management Software division. He holds a Bachelor of Science degree in Computer Science from York University.



Aslam Nomani (aslam@ca.ibm.com), DB2 Quality Assurance Manager, IBM

Photo of author Aslam NomaniAslam Nomani is a Quality Assurance Manger with the DB2 for Linux, Unix, and Windows product. He has worked for the IBM Toronto Lab for over 13 years. His focus area is high availability and he also works very closely with the IBM storage partners.



Roger E. Sanders (roger_e_sanders@yahoo.com), Consultant Corporate Systems Engineer, EMC Corporation

Roger Sanders photoRoger E. Sanders is the president of Roger Sanders Enterprises Inc. and a senior consultant corporate systems engineer with EMC Corp. He has been working with DB2 for Linux, UNIX, and Windows since DB2 was introduced on the IBM Personal Computer (as part of OS/2 1.3 Extended Edition) and has been working in the storage industry for over a decade. He has written articles for IDUG Solutions Journal and Certification Magazine, authored DB2 tutorials and articles for IBM developerWorks, presented at several International DB2 Users Group (IDUG) and regional DB2 Users Group (RUG) conferences/meetings, taught numerous classes on DB2 Fundamentals and DB2 for LUW database administration, and is the author of 21 books on DB2 and one book on ODBC. For the past nine years, he has authored the Distributed DBA column in IBM Data Management Magazine (formerly DB2 Magazine), and he has helped IBM develop 18 DB2 for LUW certification exams. In 2008-2012, he was recognized as an IBM Champion (for data management); in 2010, he was recognized as an IBM developerWorks Contributing Author; and in 2011, he was recognized as an IBM developerWorks Professional Author.


developerWorks Master author level
        2

Kevin Richards (kevin.richards@emc.com ), Engineer, EMC Corporation

Author photoKevin Richards has been with EMC Corp for sixteen years and is a Consultant Systems Integration Engineer. He has been working with AIX since its introduction with version 3 for IBM Power based RS/6000 platform. For the past ten years he has lead the integration and development requirements in Virtual I/O Server (VIOS) focusing on EMC storage virtualization interoperability. Kevin has led the storage development requirements for EMC products: Solutions Enabler, PowerPath, and Replication Manager, as well as, AIX MPIO, GPFS and PowerHA. Prior to this Kevin was the technical lead for AIX, Clustered Solutions, and Fibre Channel Protocol integration with EMC Symmetrix and CLARiiON storage. In the past Kevin has worked as an EMC Mainframe and Open Systems North East Regional Technical Specialist and IBM Scalable POWERparallel High Performance Computing Top Gun. He is currently based in Hopkinton, MA.



06 September 2012

A key aspect of the IBM® DB2® pureScale® solution is related to the capabilities of the underlying storage. The storage must not only provide best-of-breed performance but must also possess best-of-breed availability characteristics. In addition, the DB2 pureScale Feature takes advantage of specific storage capabilities to enhance the solution. This paper takes you through the value proposition of deploying DB2 pureScale databases on EMC® Symmetrix® VMAX® storage arrays, demonstrating a solution that meets the needs of even the most demanding businesses.

The DB2 pureScale feature helps to meet the availability and capacity needs of your organization by providing the following:

  • Extreme capacity. The ability to scale out your system by easily adding additional server systems to your cluster.
  • Application transparency. The ability to use your existing applications with minimal or no changes.
  • Continuous availability. The inherent redundancy that an active-active architecture provides.
  • Reduced total cost of ownership (TCO). Savings through simplified deployment and management of advanced technology.

In this paper

  • DB2 pureScale Feature exploitation of storage
  • DB2 cluster services tiebreaker disk
  • Ultra-fast failover using SCSI-3 persistent reserve
  • Device drivers and storage protocols
  • Multipath I/O drivers
  • Supported storage subsystems
  • Configuring EMC Symmetrix VMAX for pureScale storage
  • Validation matrix
  • Advantages of using the DB2 pureScale Feature
  • Deploying the DB2 pureScale Feature on an EMC Symmetrix VMAX storage array
  • Validating the configuration of a DB2 pureScale deployment
  • Configuring multipath I/O with EMC Symmetrix VMAX in a pureScale environment
  • Configuring AIX MPIO for VMAX
  • Configuring the Device Mapper Multipath module on Linux operating systems
  • Enabling and testing SCSI-3 PR with Symmetrix EMC VMAX storage controllers
  • Appendix A. Storage provisioning in Symmetrix VMAX with Enginuity code 5874 and higher
  • Appendix B. List of references for more information

Download

DescriptionNameSize
Article in PDF formatDeploying_DB2_pureScale_with_EMC_Symmetrix_VMAX.pdf985 KB

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.
  • Evaluate IBM products in the way that suits you best: Download a product trial, try a product online, use a product in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement Service Oriented Architecture efficiently.

Discuss

  • Get involved in the My developerWorks community. Connect with other developerWorks users while exploring the developer-driven blogs, forums, groups, and wikis.
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=833124
SummaryTitle=Deploying the DB2 pureScale Feature with EMC Symmetrix VMAX
publish-date=09062012