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.
- 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
|Article in PDF format||Deploying_DB2_pureScale_with_EMC_Symmetrix_VMAX.pdf||985 KB||HTTP|
- Visit the IBM
DB2 10.1 Information Center.
- Visit the IBM DB2 pureScale Feature Information Center.
- Learn more about the storage configurations validated with the DB2 pureScale
- Learn more about deploying the DB2 pureScale Feature on Linux.This is an excellent
paper on how to deploy a DB2 pureScale cluster in a Linux
- DB2 best practices: SAP applications with the DB2 pureScale Feature on
- EMC product and technical documentation:
- Symmetrix CLI Quick Reference Guide
- Symmetrix Array Controls CLI
- Host Connectivity Guide for Linux
- Storage Provisioning: Transitioning to EMC
Symmetrix VMAX Auto-provisioning groups. This white paper, available from
the EMC Powerlink site, provides a
comprehensive introduction to the VMAX storage provisioning model using
- Visit the developerWorks
Information Management zone to find more resources for DB2
developers and administrators.
- Stay current with developerWorks technical events and webcasts focused on a
variety of IBM products and IT industry topics.
- Attend a free
developerWorks Live! briefing to get up-to-speed quickly on IBM
products and tools as well as IT industry trends.
- Follow developerWorks on
- Watch developerWorks on-demand demos ranging from product installation
and setup demos for beginners, to advanced functionality for experienced
Get products and technologies
- Build your next
development project with IBM trial software, available
for download directly from developerWorks.
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
- Get involved in the My developerWorks
community. Connect with other developerWorks users while exploring
the developer-driven blogs, forums, groups, and wikis.
Aruna 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 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 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.
Kevin 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.