Db2 Virtualization

Db2 Virtualization Book in PDF, ePub and Kindle version is available to download in english. Read online anytime anywhere directly from your device. Click on the download button below to get a free pdf file of Db2 Virtualization book. This book definitely worth reading, it is an incredibly well-written.

DB2 Virtualization

Whei-Jen Chen,Jason Chan,Olaf Mueller,Malcolm Singh,Tapio Väättänen,IBM Redbooks
DB2 Virtualization Book PDF

Author : Whei-Jen Chen,Jason Chan,Olaf Mueller,Malcolm Singh,Tapio Väättänen,IBM Redbooks
Publisher : IBM Redbooks
Page : 158 pages
File Size : 48,9 Mb
Release : 2009-11-25
Category : Computers
ISBN : 9780738433431

Get Book

DB2 Virtualization by Whei-Jen Chen,Jason Chan,Olaf Mueller,Malcolm Singh,Tapio Väättänen,IBM Redbooks Pdf

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.

DB2 Virtualization

Anonim
DB2 Virtualization Book PDF

Author : Anonim
Publisher : Unknown
Page : 140 pages
File Size : 43,5 Mb
Release : 2009
Category : Client/server computing
ISBN : OCLC:560338336

Get Book

DB2 Virtualization by Anonim Pdf

"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.

POWER7 and POWER7+ Optimization and Tuning Guide

Brian Hall,Mala Anand,Bill Buros,Miso Cilimdzic,Hong Hua,Judy Liu,John MacMillan,Sudhir Maddali,K Madhusudanan,Bruce Mealey,Steve Munroe,Francis P O’Connell,Sergio Reyes,Raul Silvera,Randy Swanberg,Brian Twichell,Brian F Veale,Julian Wang,Yaakov Yaari,IBM Redbooks
POWER7 and POWER7 Optimization and Tuning Guide Book PDF

Author : Brian Hall,Mala Anand,Bill Buros,Miso Cilimdzic,Hong Hua,Judy Liu,John MacMillan,Sudhir Maddali,K Madhusudanan,Bruce Mealey,Steve Munroe,Francis P O’Connell,Sergio Reyes,Raul Silvera,Randy Swanberg,Brian Twichell,Brian F Veale,Julian Wang,Yaakov Yaari,IBM Redbooks
Publisher : IBM Redbooks
Page : 224 pages
File Size : 40,6 Mb
Release : 2013-03-04
Category : Computers
ISBN : 9780738437538

Get Book

POWER7 and POWER7+ Optimization and Tuning Guide by Brian Hall,Mala Anand,Bill Buros,Miso Cilimdzic,Hong Hua,Judy Liu,John MacMillan,Sudhir Maddali,K Madhusudanan,Bruce Mealey,Steve Munroe,Francis P O’Connell,Sergio Reyes,Raul Silvera,Randy Swanberg,Brian Twichell,Brian F Veale,Julian Wang,Yaakov Yaari,IBM Redbooks Pdf

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).

Performance Optimization and Tuning Techniques for IBM Power Systems Processors Including IBM POWER8

Brian Hall,Peter Bergner,Alon Shalev Housfater,Madhusudanan Kandasamy,Tulio Magno,Alex Mericas,Steve Munroe,Mauricio Oliveira,Bill Schmidt,Will Schmidt,Bernard King Smith,Julian Wang,Suresh Warrier,David Wendt,IBM Redbooks
Performance Optimization and Tuning Techniques for IBM Power Systems Processors Including IBM POWER8 Book PDF

Author : Brian Hall,Peter Bergner,Alon Shalev Housfater,Madhusudanan Kandasamy,Tulio Magno,Alex Mericas,Steve Munroe,Mauricio Oliveira,Bill Schmidt,Will Schmidt,Bernard King Smith,Julian Wang,Suresh Warrier,David Wendt,IBM Redbooks
Publisher : IBM Redbooks
Page : 274 pages
File Size : 50,5 Mb
Release : 2017-03-31
Category : Computers
ISBN : 9780738440927

Get Book

Performance Optimization and Tuning Techniques for IBM Power Systems Processors Including IBM POWER8 by Brian Hall,Peter Bergner,Alon Shalev Housfater,Madhusudanan Kandasamy,Tulio Magno,Alex Mericas,Steve Munroe,Mauricio Oliveira,Bill Schmidt,Will Schmidt,Bernard King Smith,Julian Wang,Suresh Warrier,David Wendt,IBM Redbooks Pdf

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).

Virtualized Business Intelligence with InfoSphere Warehouse

Adriana Carvajal,Thomas Chong,IBM Redbooks
Virtualized Business Intelligence with InfoSphere Warehouse Book PDF

Author : Adriana Carvajal,Thomas Chong,IBM Redbooks
Publisher : IBM Redbooks
Page : 246 pages
File Size : 49,8 Mb
Release : 2012-10-05
Category : Computers
ISBN : 9780738437415

Get Book

Virtualized Business Intelligence with InfoSphere Warehouse by Adriana Carvajal,Thomas Chong,IBM Redbooks Pdf

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.

IBM Midmarket Software Buying and Selling Guide

LindaMay Patterson,IBM Redbooks
IBM Midmarket Software Buying and Selling Guide Book PDF

Author : LindaMay Patterson,IBM Redbooks
Publisher : IBM Redbooks
Page : 204 pages
File Size : 53,7 Mb
Release : 2010-07-12
Category : Computers
ISBN : 9780738450070

Get Book

IBM Midmarket Software Buying and Selling Guide by LindaMay Patterson,IBM Redbooks Pdf

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

Accelerating Digital Transformation on Z Using Data Virtualization

Blanca Borden,Calvin Fudge,Jen Nelson,Jim Porell,IBM Redbooks
Accelerating Digital Transformation on Z Using Data Virtualization Book PDF

Author : Blanca Borden,Calvin Fudge,Jen Nelson,Jim Porell,IBM Redbooks
Publisher : IBM Redbooks
Page : 38 pages
File Size : 53,5 Mb
Release : 2021-04-13
Category : Computers
ISBN : 9780738457291

Get Book

Accelerating Digital Transformation on Z Using Data Virtualization by Blanca Borden,Calvin Fudge,Jen Nelson,Jim Porell,IBM Redbooks Pdf

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.

Power Systems Enterprise Servers with PowerVM Virtualization and RAS

Dino Quintero,JinHoon Baek,Guillermo Diez,Hassan Elsetohy,Debra Francis,Bing He,Rajesh Jeyapaul,Anil Kalavakolanu,Tejaswini Kaujalgi,David Kgabo,Ricardo Puig,Vani Ramagiri,IBM Redbooks
Power Systems Enterprise Servers with PowerVM Virtualization and RAS Book PDF

Author : Dino Quintero,JinHoon Baek,Guillermo Diez,Hassan Elsetohy,Debra Francis,Bing He,Rajesh Jeyapaul,Anil Kalavakolanu,Tejaswini Kaujalgi,David Kgabo,Ricardo Puig,Vani Ramagiri,IBM Redbooks
Publisher : IBM Redbooks
Page : 424 pages
File Size : 49,5 Mb
Release : 2013-03-06
Category : Computers
ISBN : 9780738436265

Get Book

Power Systems Enterprise Servers with PowerVM Virtualization and RAS by Dino Quintero,JinHoon Baek,Guillermo Diez,Hassan Elsetohy,Debra Francis,Bing He,Rajesh Jeyapaul,Anil Kalavakolanu,Tejaswini Kaujalgi,David Kgabo,Ricardo Puig,Vani Ramagiri,IBM Redbooks Pdf

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.

High Availability IT Services

Terry Critchley
High Availability IT Services Book PDF

Author : Terry Critchley
Publisher : CRC Press
Page : 527 pages
File Size : 50,8 Mb
Release : 2014-12-17
Category : Business & Economics
ISBN : 9781482255911

Get Book

High Availability IT Services by Terry Critchley Pdf

This book starts with the basic premise that a service is comprised of the 3Ps-products, processes, and people. Moreover, these entities and their sub-entities interlink to support the services that end users require to run and support a business. This widens the scope of any availability design far beyond hardware and software. It also increases t

IBM Cloud Pak for Data with IBM Spectrum Scale Container Native

Gero Schmidt,Tara Astigarraga,Paulina Acevedo,JJ Miller,Dessa Simpson,Austen Stewart,Todd Tosseth,Jayson Tsingine,Israel Andres Vizcarra Godinez,IBM Redbooks
IBM Cloud Pak for Data with IBM Spectrum Scale Container Native Book PDF

Author : Gero Schmidt,Tara Astigarraga,Paulina Acevedo,JJ Miller,Dessa Simpson,Austen Stewart,Todd Tosseth,Jayson Tsingine,Israel Andres Vizcarra Godinez,IBM Redbooks
Publisher : IBM Redbooks
Page : 120 pages
File Size : 53,7 Mb
Release : 2021-12-17
Category : Computers
ISBN : 9780738460093

Get Book

IBM Cloud Pak for Data with IBM Spectrum Scale Container Native by Gero Schmidt,Tara Astigarraga,Paulina Acevedo,JJ Miller,Dessa Simpson,Austen Stewart,Todd Tosseth,Jayson Tsingine,Israel Andres Vizcarra Godinez,IBM Redbooks Pdf

This IBM® Redpaper® publication describes configuration guidelines and best practices when IBM Spectrum® Scale Container Native Storage Access is used as a storage provider for IBM Cloud® Pak for Data on Red Hat OpenShift Container Platform. It also provides the steps to install IBM Db2® and several assemblies within IBM Cloud Pak® for Data, including Watson Knowledge Catalog, Watson Studio, IBM DataStage®, Db2 Warehouse, Watson Machine Learning, Watson OpenScale, Data Virtualization, Data Management Console, and Apache Spark. This IBM Redpaper publication was written for IT architects, IT specialists, developers, and others who are interested in installing IBM Cloud Pak for Data with IBM Spectrum Scale Container Native.

IBM Cloud Pak for Data

Hemanth Manda,Sriram Srinivasan,Deepak Rangarao
IBM Cloud Pak for Data Book PDF

Author : Hemanth Manda,Sriram Srinivasan,Deepak Rangarao
Publisher : Packt Publishing Ltd
Page : 337 pages
File Size : 54,5 Mb
Release : 2021-11-24
Category : Computers
ISBN : 9781800567405

Get Book

IBM Cloud Pak for Data by Hemanth Manda,Sriram Srinivasan,Deepak Rangarao Pdf

Build end-to-end AI solutions with IBM Cloud Pak for Data to operationalize AI on a secure platform based on cloud-native reliability, cost-effective multitenancy, and efficient resource management Key FeaturesExplore data virtualization by accessing data in real time without moving itUnify the data and AI experience with the integrated end-to-end platformExplore the AI life cycle and learn to build, experiment, and operationalize trusted AI at scaleBook Description Cloud Pak for Data is IBM's modern data and AI platform that includes strategic offerings from its data and AI portfolio delivered in a cloud-native fashion with the flexibility of deployment on any cloud. The platform offers a unique approach to addressing modern challenges with an integrated mix of proprietary, open-source, and third-party services. You'll begin by getting to grips with key concepts in modern data management and artificial intelligence (AI), reviewing real-life use cases, and developing an appreciation of the AI Ladder principle. Once you've gotten to grips with the basics, you will explore how Cloud Pak for Data helps in the elegant implementation of the AI Ladder practice to collect, organize, analyze, and infuse data and trustworthy AI across your business. As you advance, you'll discover the capabilities of the platform and extension services, including how they are packaged and priced. With the help of examples present throughout the book, you will gain a deep understanding of the platform, from its rich capabilities and technical architecture to its ecosystem and key go-to-market aspects. By the end of this IBM book, you'll be able to apply IBM Cloud Pak for Data's prescriptive practices and leverage its capabilities to build a trusted data foundation and accelerate AI adoption in your enterprise. What you will learnUnderstand the importance of digital transformations and the role of data and AI platformsGet to grips with data architecture and its relevance in driving AI adoption using IBM's AI LadderUnderstand Cloud Pak for Data, its value proposition, capabilities, and unique differentiatorsDelve into the pricing, packaging, key use cases, and competitors of Cloud Pak for DataUse the Cloud Pak for Data ecosystem with premium IBM and third-party servicesDiscover IBM's vibrant ecosystem of proprietary, open-source, and third-party offerings from over 35 ISVsWho this book is for This book is for data scientists, data stewards, developers, and data-focused business executives interested in learning about IBM's Cloud Pak for Data. Knowledge of technical concepts related to data science and familiarity with data analytics and AI initiatives at various levels of maturity are required to make the most of this book.

Best Practices for DB2 on AIX 6.1 for POWER Systems

Rakesh Dash,Bernard Goelen,Vasfi Gucer,Rajesh K Jeyapaul,Sunil Kamath,Naveen Kumar Bharatha,Michael Kwok,Anupama Padmanabhan,Punit Shah,Basker Shanmugam,Sweta Singh,Amar Thakkar,Adriana Zubiri,IBM Redbooks
Best Practices for DB2 on AIX 6 1 for POWER Systems Book PDF

Author : Rakesh Dash,Bernard Goelen,Vasfi Gucer,Rajesh K Jeyapaul,Sunil Kamath,Naveen Kumar Bharatha,Michael Kwok,Anupama Padmanabhan,Punit Shah,Basker Shanmugam,Sweta Singh,Amar Thakkar,Adriana Zubiri,IBM Redbooks
Publisher : IBM Redbooks
Page : 426 pages
File Size : 52,8 Mb
Release : 2015-08-27
Category : Computers
ISBN : 9780738434193

Get Book

Best Practices for DB2 on AIX 6.1 for POWER Systems by Rakesh Dash,Bernard Goelen,Vasfi Gucer,Rajesh K Jeyapaul,Sunil Kamath,Naveen Kumar Bharatha,Michael Kwok,Anupama Padmanabhan,Punit Shah,Basker Shanmugam,Sweta Singh,Amar Thakkar,Adriana Zubiri,IBM Redbooks Pdf

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.

Virtualization Security

Dave Shackleford
Virtualization Security Book PDF

Author : Dave Shackleford
Publisher : John Wiley & Sons
Page : 360 pages
File Size : 40,9 Mb
Release : 2012-11-08
Category : Computers
ISBN : 9781118331514

Get Book

Virtualization Security by Dave Shackleford Pdf

Securing virtual environments for VMware, Citrix, and Microsoft hypervisors Virtualization changes the playing field when it comes to security. There are new attack vectors, new operational patterns and complexity, and changes in IT architecture and deployment life cycles. What's more, the technologies, best practices, and strategies used for securing physical environments do not provide sufficient protection for virtual environments. This book includes step-by-step configurations for the security controls that come with the three leading hypervisor--VMware vSphere and ESXi, Microsoft Hyper-V on Windows Server 2008, and Citrix XenServer. Includes strategy for securely implementing network policies and integrating virtual networks into the existing physical infrastructure Discusses vSphere and Hyper-V native virtual switches as well as the Cisco Nexus 1000v and Open vSwitch switches Offers effective practices for securing virtual machines without creating additional operational overhead for administrators Contains methods for integrating virtualization into existing workflows and creating new policies and processes for change and configuration management so that virtualization can help make these critical operations processes more effective This must-have resource offers tips and tricks for improving disaster recovery and business continuity, security-specific scripts, and examples of how Virtual Desktop Infrastructure benefits security.

Co-locating Transactional and Data Warehouse Workloads on System z

Mike Ebbers,Dino Tonelli,Jason Arnold,Patric Becker,Yuan-Chi Chang,Willie Favero,Shantan Kethireddy,Nin Lei,Shirley Lin,Ron Lounsbury,Susan Widing Lynch,Cristian Molaro,Deepak Rangarao,Michael Schapira,IBM Redbooks
Co locating Transactional and Data Warehouse Workloads on System z Book PDF

Author : Mike Ebbers,Dino Tonelli,Jason Arnold,Patric Becker,Yuan-Chi Chang,Willie Favero,Shantan Kethireddy,Nin Lei,Shirley Lin,Ron Lounsbury,Susan Widing Lynch,Cristian Molaro,Deepak Rangarao,Michael Schapira,IBM Redbooks
Publisher : IBM Redbooks
Page : 540 pages
File Size : 52,5 Mb
Release : 2010-12-03
Category : Computers
ISBN : 9780738434780

Get Book

Co-locating Transactional and Data Warehouse Workloads on System z by Mike Ebbers,Dino Tonelli,Jason Arnold,Patric Becker,Yuan-Chi Chang,Willie Favero,Shantan Kethireddy,Nin Lei,Shirley Lin,Ron Lounsbury,Susan Widing Lynch,Cristian Molaro,Deepak Rangarao,Michael Schapira,IBM Redbooks Pdf

As business cycles speed up, many customers gain significant competitive advantage from quicker and more accurate business decision-making by using real data. For many customers, choosing the path to co-locate their transactional and analytical workloads on System z® better leverages their existing investment in hardware, software, and skills. We created a project to address a number of best practice questions on how to manage these newer, analytical type workloads, especially when co-located with traditional transactional workloads. The goal of this IBM® Redbooks® publication is to provide technical guidance and performance trade-offs associated with resource management and potentially DB2® data-sharing in a variety of mixed transactional / data warehouse System z topologies. The term co-location used here and in the rest of the book is specifically defined as the practice of housing both transactional (OLTP) and data warehouse (analytical) workloads within the same System z configuration. We also assumed that key portions of the transactional and data warehouse databases would reside on DB2 for z/OS®. The databases may or may not reside in a DB2 data-sharing environment; we discuss those pros and cons in this book. The intended audience includes DB2 data warehouse architects and practitioners who are facing choices in resource management and system topologies in the data warehouse arena. This specifically includes Business Intelligence (BI) administrators, DB2 database administrators (DBAs) and z/OS performance administrators / systems programmers. In addition, decision makers and architects can utilize this book to assist in making platform and database topology decisions. The book is divided into four parts. Part I, "Introducing the co-location project" covers the System z value proposition and why one should consider System z as the central platform for their data warehousing / business analytics needs. Some topics are risk avoidance via data consolidation, continuous availability, simplified disaster recovery, IBM Smart Analytics Optimizer, reduced network bandwidth requirements, and the unique virtualization and resource management capabilities of System z LPAR, z/VM® and WLM. Part I also provides some of the common System z co-location topologies along with an explanation of the general pros and cons of each. This would be useful input for an architect to understand where a customer is today and where they might consider moving to. Part II, "Project environment" covers the environment, products, workloads, workload drivers, and data models implemented for this study. The environment consisted of a logically partitioned z10TM 32way, running z/VM, Linux®, and z/OS operating system instances. On those instances we ran products such as z/OS DB2 V9, IBM Cognos® Business Intelligence Version 8.4 for Linux on System z, InfoSphereTM Warehouse for System z, InfoSphere Change Data Capture, z/OS WebSphere® V7, Tivoli® Omegamon for DB2 Performance expert. Utilizing these products we created transactional (OLTP), data warehouse query, and data warehouse refresh workloads. All the workloads were based on an existing web-based transactional Bookstore workload, that's currently utilized for internal testing within the System p® and z labs. While some IBM Cognos BI and ISWz product usage and experiences information is covered in this book, we do not go into the depth typically found in IBM Redbooks publications, since there's another book focused specifically on that

DB2 9 for z/OS and Storage Management

Paolo Bruni,John Iczkovits,Hennie Mynhardt,Peter Zerbini,IBM Redbooks
DB2 9 for z OS and Storage Management Book PDF

Author : Paolo Bruni,John Iczkovits,Hennie Mynhardt,Peter Zerbini,IBM Redbooks
Publisher : IBM Redbooks
Page : 436 pages
File Size : 50,8 Mb
Release : 2010-09-17
Category : Computers
ISBN : 9780738434698

Get Book

DB2 9 for z/OS and Storage Management by Paolo Bruni,John Iczkovits,Hennie Mynhardt,Peter Zerbini,IBM Redbooks Pdf

This IBM® Redbooks® publication can help you tailor and configure DFSMS constructs to be used in an IBM DB2® 9 for z/OS® environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations. This book addresses both the DB2 administrator and the storage administrator. The DB2 administrator can find information about how to use DFSMS for managing DB2 data sets; the storage administrator can find information about the characteristics of DB2 data sets and how DB2 uses the disks. This book describes optimal use of disk storage functions in DB2 for z/OS environments that can best make productive use of the synergy with I/O subsystem on IBM System z®. This book covers the following topics: - Using SMS to manage DB2 catalog, log, data, indexes, image copies, archives, work files - Taking advantage of IBM FlashCopy® for DB2 utilities, striping, copy pools - Setting page sizes and using sliding allocation - A description of PAV, MA, MIDAW, EF, EA, EAV, zHPF and why they are helpful - Compressing data and the use disk and tape for large data sets - Backup and restore, and remote copy services