Db2 Virtualization

Server virtualization technologies are becoming more popular to help efficiently utilize resources by consolidating servers. IBM® , the first company that developed and made available the virtual technology in 1966, offers advanced, powerful, reliable, and cost-saving virtualization technologies in various hardware and software products including DB2® for Linux, UNIX, and Windows. This IBM Redbooks® publication describes using IBM DB2 9 with server virtualization. We start with a general overview of virtualization and describe specific server virtualization technologies to highlight how the server virtualization technologies have been implemented. With this introduction anyone new to virtualization will have a better understanding of server virtualization and the industry server virtualization technologies available in the market. Following the virtualization concept, we describe in detail the setup, configuration, and managing of DB2 with three leading server virtualization technologies: IBM Power SystemsTM with PowerVMTM VMware Hyper-V We discuss the virtual machine setup with DB2 in mind to help IT support understand the effective ways of setting up a virtual environment specific for DB2. We explain the architecture and components of these three server virtualization technologies to allow DBAs to understand how a database environment using DB2 can benefit from using the server virtualization technologies. In addition, we discuss the DB2 features and functions that can take advantage of using server virtualization. These features are put into practice when describing how to set up DB2 with the three virtualization technologies discussed in this book. This book also includes a list of best practices from the various tests performed while using these virtualization technologies. These best practices can be used as a guideline or a reference when setting up DB2 using these virtualization technologies.

"Server virtualization technologies are becoming more popular to help efficiently utilize resources by consolidating servers. IBM, the first company that developed and made available the virtual technology in 1966, offers advanced, powerful, reliable, and cost-saving virtualization technologies in various hardware and software products including DB2 for Linux, UNIX, and Windows. This IBM Redbooks publication describes using IBM DB2 9 with server virtualization"--Resource description page.

This IBM® Redbooks® publication provides advice and technical information about optimizing and tuning application code to run on systems that are based on the IBM POWER7® and POWER7+TM processors. This advice is drawn from application optimization efforts across many different types of code that runs under the IBM AIX® and Linux operating systems, focusing on the more pervasive performance opportunities that are identified, and how to capitalize on them. The technical information was developed by a set of domain experts at IBM. The focus of this book is to gather the right technical information, and lay out simple guidance for optimizing code performance on the IBM POWER7 and POWER7+ systems that run the AIX or Linux operating systems. This book contains a large amount of straightforward performance optimization that can be performed with minimal effort and without previous experience or in-depth knowledge. This optimization work can: Improve the performance of the application that is being optimized for the POWER7 system Carry over improvements to systems that are based on related processor chips Improve performance on other platforms The audience of this book is those personnel who are responsible for performing migration and implementation activities on IBM POWER7-based servers, which includes system administrators, system architects, network administrators, information architects, and database administrators (DBAs).

This IBM® Redbooks® publication focuses on gathering the correct technical information, and laying out simple guidance for optimizing code performance on IBM POWER8® processor-based systems that run the IBM AIX®, IBM i, or Linux operating systems. There is straightforward performance optimization that can be performed with a minimum of effort and without extensive previous experience or in-depth knowledge. The POWER8 processor contains many new and important performance features, such as support for eight hardware threads in each core and support for transactional memory. The POWER8 processor is a strict superset of the IBM POWER7+TM processor, and so all of the performance features of the POWER7+ processor, such as multiple page sizes, also appear in the POWER8 processor. Much of the technical information and guidance for optimizing performance on POWER8 processors that is presented in this guide also applies to POWER7+ and earlier processors, except where the guide explicitly indicates that a feature is new in the POWER8 processor. This guide strives to focus on optimizations that tend to be positive across a broad set of IBM POWER® processor chips and systems. Specific guidance is given for the POWER8 processor; however, the general guidance is applicable to the IBM POWER7+, IBM POWER7®, IBM POWER6®, IBM POWER5, and even to earlier processors. This guide is directed at personnel who are responsible for performing migration and implementation activities on POWER8 processor-based systems. This includes system administrators, system architects, network administrators, information architects, and database administrators (DBAs).

With the benefit of advanced analytics such as online analytical processing (OLAP), data mining, and text analytics, the IBM® InfoSphere® Warehouse Enterprise Edition brings sophisticated business intelligence (BI) to warehouse users. InfoSphere Warehouse allows you to run extreme concurrent query volumes that can help answer questions for all types of business users, while consistently meeting service level requirements. Combined with a virtualization platform and a solid BI solution, such as IBM Cognos®, you can deliver BI cloud services with improved flexibility and speed to your clients, thereby presenting a new avenue for which your services can be offered. This IBM Redbooks® publication discusses the deployment of a BI cloud solution. It includes details such as understanding the architecture of a cloud, planning implementation, integrating various software components, and understanding the preferred practices of running a cloud deployment. Essentially, this book can be used as a guide by anyone who is interested in deploying a virtualized environment for a BI cloud solution.

The IBM® Midmarket Software Buying and Selling Guide is tailored specifically to help the management and IT staff of small and midsized businesses evaluate how the IBM midmarket portfolio can provide simple and cost-effective solutions to common business problems. Along with a midmarket customer focus, this IBM RedpaperTM publication is designed to help IBM teams and Business Partners be more effective in serving small and midsized businesses. We illustrate how IBM software for the midmarket can help businesses use the Web to reduce expenses, improve customer service, and expand into new markets. We cover the IBM software offering for the midmarket, which includes what the software does, the platforms it runs on, where to find more information, and how it can help your business become more profitable: - IBM Business Partners often keep a printed copy of this guide in their briefcases for software references - Customers can view this guide online and look up software-value messages and IBM product family offering comparisons - IBM Sales Representatives can print parts of this guide as "leave-behinds" for customers, to give them extra collateral on midmarket software of interest To make sure that you have the latest version of this guide, download it from this web address: http://www.redbooks.ibm.com/abstracts/redp3975.html?Open

This IBM® RedpaperTM publication introduces a new data virtualization capability that enables IBM z/OS® data to be combined with other enterprise data sources in real-time, which allows applications to access any live enterprise data anytime and use the power and efficiencies of the IBM Z® platform. Modern businesses need actionable and timely insight from current data. They cannot afford the time that is necessary to copy and transform data. They also cannot afford to secure and protect each copy of personally identifiable information and corporate intellectual property. Data virtualization enables direct connections to be established between multiple data sources and the applications that process the data. Transformations can be applied, in line, to enable real-time access to data, which opens up many new ways to gain business insight with less IT infrastructure necessary to achieve those goals. Data virtualization can become the backbone for advanced analytics and modern applications. The IBM Data Virtualization Manager for z/OS (DVM) can be used as a stand-alone product or as a utility that is used by other products. Its goal is to enable access to live mainframe transaction data and make it usable by any application. This enables customers to use the strengths of mainframe processing with new agile applications. Additionally, its modern development environment and code-generating capabilities enable any developer to update, access, and combine mainframe data easily by using modern APIs and languages. If data is the foundation for building new insights, IBM DVM is a key tool for providing easy, cost-efficient access to that foundation.

This IBM® Redbooks® publication illustrates implementation, testing, and helpful scenarios with IBM Power® Systems 780 and 795 using the comprehensive set of the Power virtualization features. We focus on the Power Systems functional improvements, in particular, highlighting the reliability, availability, and serviceability (RAS) features of the enterprise servers. This document highlights IBM Power Systems Enterprise Server features, such as system scalability, virtualization features, and logical partitioning among others. This book provides a documented deployment model for Power 780 and Power 795 within a virtualized environment, which allows clients to plan a foundation for exploiting and using the latest features of the IBM Power Systems Enterprise Servers. The target audience for this book includes technical professionals (IT consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing IBM Power Systems solutions and support.