Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature


Book Description

The IBM® DB2® pureScale® feature offers clustering technology that helps deliver high availability and exceptional scalability transparent to applications. The DB2 pureScale feature helps you to meet your business needs around availability and scalability, and is also easy to configure and administer. This IBM Redbooks® publication addresses the DB2 pureScale feature that is available in IBM DB2 10.1 for Linux, UNIX, and Windows operating systems. It can help you build skills and deploy the DB2 pureScale feature. This book bundles all the information necessary for a in-depth analysis into the functions of the DB2 pureScale feature, including the actual hardware requirements. It includes validated step-by-step hardware and software installation instructions. In addition, this book provides detailed examples about how to work effectively with a DB2 pureScale cluster and how to plan and run an upgrade for all DB2 related components to DB2 10.1. This book is intended for database administrators (DBAs) who use IBM DB2 10.1 for Linux, UNIX, and Windows operating systems who want to explore and get started with the DB2 pureScale feature.




IBM SAN Volume Controller Stretched Cluster with PowerVM and PowerHA


Book Description

This IBM® Redbooks® publication describes the IBM Storage Area Network and IBM SAN Volume Controller Stretched Cluster solution when combined with PowerVM® and PowerHA®. We describe guidelines, settings, and the implementation steps that are necessary to achieve a successful implementation. This book is for administrators who are familiar with the SAN, IBM SAN Volume Controller, and IBM PowerVM and PowerHA Systems.







Oracle to DB2 Conversion Guide: Compatibility Made Easy


Book Description

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.




IBM Power Systems High Availability and Disaster Recovery Updates: Planning for a Multicloud Environment


Book Description

This IBM® Redpaper publication delivers an updated guide for high availability and disaster recovery (HADR) planning in a multicloud environment for IBM Power. This publication describes the ideas from studies that were performed in a virtual collaborative team of IBM Business Partners, technical focal points, and product managers who used hands-on experience to implement case studies to show HADR management aspects to develop this technical update guide for a hybrid multicloud environment. The goal of this book is to deliver a HADR guide for backup and data management on-premises and in a multicloud environment. This document updates HADR on-premises and in the cloud with IBM PowerHA® SystemMirror®, IBM VM Recovery Manager (VMRM), and other solutions that are available on IBM Power for IBM AIX®, IBM i, and Linux. This publication highlights the available offerings at the time of writing for each operating system (OS) that is supported in IBM Power, including best practices. This book addresses topics for IT architects, IT specialists, sellers, and anyone looking to implement and manage HADR on-premises and in the cloud. Moreover, this publication provides documentation to transfer how-to skills to the technical teams and solution guidance to the sales team. This book complements the documentation that is available at IBM Documentation and aligns with the educational materials that are provided by IBM Systems Technical Training.




Best Practices for DB2 on AIX 6.1 for POWER Systems


Book Description

This IBM® Redbooks® publication presents a best practices guide for DB2® and InfoSphereTM Warehouse performance on a AIX® 6L with Power SystemsTM virtualization environment. It covers Power hardware features such as PowerVMTM, multi-page support, Reliability, Availability, and Serviceability (RAS) and how to best exploit them with DB2 LUW workloads for both transactional and data warehousing systems. The popularity and reach of DB2 and InfoSphere Warehouse has grown in recent years. Enterprises are relying more on these products for their mission-critical transactional and data warehousing workloads. It is critical that these products be supported by an adequately planned infrastructure. This publication offers a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems. IBM Power Systems have been leading players in the server industry for decades. Power Systems provide great performance while delivering reliability and flexibility to the infrastructure. This book presents a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems. It aims to demonstrate the benefits DB2 and InfoSphere Warehouse can derive from a Power Systems infrastructure and how Power Systems support these products. The book is intended as a guide for a Power Systems specialist to understand the DB2 and InfoSphere Warehouse environment and for a DB2 and InfoSphere Warehouse specialist to understand the facilities available for Power Systems supporting these products.




DB2 pureScale: Risk Free Agile Scaling


Book Description

Extreme Availability and Scalability--Up and Running With DB2 pureScale DB2 is a leading-edge hybrid data server that offers optimum storage, scalability, and availability. DB2 pureScale is a new technology primarily optimized for scale-out transactional processing clusters in an active-active manner. This succinct guide will show you how DB2 with pureScale can deliver transparent application scalability, the ability to deliver agile-like computing to your transaction systems, and extreme availability. This book, together with IBM DB2 9 New Features (McGraw-Hill, 2007) and Break Free with DB2 9.7 (McGraw-Hill, 2009), provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try the new features by downloading DB2 Express-C 9.7--it is free to develop, deploy, and distribute (with no user and database size limitations) and features pureXML technology. Go to ibm.com/db2/express. Discover the benefits your business can achieve with the agility provided by DB2 pureScale Find out how applications can be transparently scaled Reduce the risk and cost of business growth through umlimited capacity




IBM Power Systems SR-IOV: Technical Overview and Introduction


Book Description

This IBM® RedpaperTM publication describes the adapter-based virtualization capabilities that are being deployed in high-end IBM POWER7+TM processor-based servers. Peripheral Component Interconnect Express (PCIe) single root I/O virtualization (SR-IOV) is a virtualization technology on IBM Power Systems servers. SR-IOV allows multiple logical partitions (LPARs) to share a PCIe adapter with little or no run time involvement of a hypervisor or other virtualization intermediary. SR-IOV does not replace the existing virtualization capabilities that are offered as part of the IBM PowerVM® offerings. Rather, SR-IOV compliments them with additional capabilities. This paper describes many aspects of the SR-IOV technology, including: A comparison of SR-IOV with standard virtualization technology Overall benefits of SR-IOV Architectural overview of SR-IOV Planning requirements SR-IOV deployment models that use standard I/O virtualization Configuring the adapter for dedicated or shared modes Tips for maintaining and troubleshooting your system Scenarios for configuring your system This paper is directed to clients, IBM Business Partners, and system administrators who are involved with planning, deploying, configuring, and maintaining key virtualization technologies.




Implementing the IBM General Parallel File System (GPFS) in a Cross Platform Environment


Book Description

This IBM® Redbooks® publication provides a documented deployment model for IBM GPFSTM in a cross-platform environment with IBM Power SystemsTM, Linux, and Windows servers. With IBM GPFS, customers can have a planned foundation for file systems management for cross-platform access solutions. This book examines the functional, integration, simplification, and usability changes with GPFS v3.4. It can help the technical teams provide file system management solutions and technical support with GPFS, based on Power Systems virtualized environments for cross-platform file systems management. The book provides answers to your complex file systems management requirements, helps you maximize file system availability, and provides expert-level documentation to transfer the how-to skills to the worldwide support teams. The audience for this book is the technical professional (IT consultants, technical support staff, IT architects, and IT specialists) who is responsible for providing file system management solutions and support for cross-platform environments that are based primarily on Power Systems.




IBM GDPS Active/Active Overview and Planning


Book Description

IBM® Geographically Dispersed Parallel SysplexTM (GDPS®) is a collection of several offerings, each addressing a different set of IT resiliency goals. It can be tailored to meet the recovery point objective (RPO), which is how much data can you are willing to lose or recreate, and the recovery time objective (RTO), which identifies how long can you afford to be without your systems for your business from the initial outage to having your critical business processes available to users. Each offering uses a combination of server and storage hardware or software-based replication, and automation and clustering software technologies. This IBM Redbooks® publication presents an overview of the IBM GDPS active/active (GDPS/AA) offering and the role it plays in delivering a business IT resilience solution.