DB2 and System p virtualization

Performance and best practices

Learn best practices for deploying IBM DB2 9 with the IBM System p virtualization technologies.

Punit Shah, IBM Advisory Software Engineer, EMC

Punit's primary responsibilities include advanced solution development, technology exploitation, and enabling IBM middleware software to use the latest System p technologies. He has been working in enterprise application development and performance area, and has authored or coauthored several articles in this area.



Basker Shanmugam, Technical Consultant, ISV Enablement, IBM

Basker works in IBM ISV Business Strategy and Enablement organization as a consultant focusing on performance and benchmarking. Basker has worked in technical support and performance related areas involving Windows, Linux, AIX, Oracle, DB2 and server partitioning for over 16 years.



Sunil Kamath (sunil.kamath@ca.ibm.com), Senior Technical Manager, EMC

Author picture: Sunil KamathSunil is a senior technical manager responsible for DB2 Performance Benchmarks and Solutions Development. He works primarily on database performance and scalability and has led many successful TPC-C and SAP workload benchmarks. In addition, he has also designed and implemented many high performance and leading database solutions. His interest and responsibilities also include exploring and exploiting key hardware (include virtualization), operating systems, storage, and compiler technologies that help improve data server performance.



10 January 2008

Learn best practices for deploying IBM® DB2® 9 with the IBM System p™ virtualization technologies. System p virtualization technologies offer a richer set of platform-deployment features. These features range from simple resource isolation to an array of the most advanced and powerful functions, including: server-resource partitioning, autonomic dynamic-resource reallocation, and workload management.

Introduction

DB2 9 is the industry’s leading information management platform. DB2 9 is enabled to leverage the System p virtualization technology. Innovative features such as host dynamic-resource awareness, online tuning of configuration parameters, and self-tuning memory management enables DB2 to be well suited for the virtualization environment. When running DB2 9 on the System p platform, selecting a right blend of virtualization features to achieve desired business goals can sometimes be challenging. This article is an abbreviated guide and should serve as a starting point for such deployments.

Download

DescriptionNameSize
Article in PDF formatdm-0801shah.pdf108KB

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=281125
SummaryTitle=DB2 and System p virtualization
publish-date=01102008