Author: Alex Louwe Kooijmans
Publisher: IBM Redbooks
ISBN: 0738451274
Category : Computers
Languages : en
Pages : 60

View

Book Description
Many companies have built data warehouses (DWs) and have embraced business intelligence (BI) and analytics solutions. Even as companies have accumulated huge amounts of data, however, it remains difficult to provide trusted information at the right time and in the right place. The amount of data collected and available throughout the enterprise continues to grow even as the complexity and urgency of receiving meaningful information continues to increase. Producing meaningful and trusted information when it is needed can only be achieved by having a proper information architecture in place and a powerful underlying infrastructure. The amounts of data to mine, cleanse, and integrate are becoming so large that increasingly the infrastructure is becoming the bottleneck. This results in low refresh rates of the data in the data warehouse and in not having the information available in time where it is needed. And even before information can become available in a BI dashboard or a report, many preceding steps must take place: the collection of raw data; integration of data from multiple data stores, business units or geographies; transformation of data from one format to another; cubing data into data cubes; and finally, loading changes to data in the data warehouse. Combining the complexity of the information requirements, the growing amounts of data, and multiple layers of the information architecture requires an extremely powerful infrastructure. This IBM® RedguideTM publication explains how you can use IBM System z® as the foundation for your information management architecture. The System z value proposition for information management is fueled by the traditional strengths of the IBM mainframe, the specific strengths of DB2® for z/OS®, and the broad functionality of the IBM information management software portfolio. For decades, System z has proven its ability to manage vast amounts of mission-critical data for many companies throughout the world; your data is safe on System z. The available information management functionality on System z has grown from database management systems to a full stack of solutions including solutions for content management, master data management, information integration, data warehousing, and business intelligence and analytics. The availability of Linux® on System z provides an excellent opportunity to place certain components in an easy-to-manage and scalable virtualized Linux server, while benefitting from the System z hardware strengths. DB2 on z/OS can remain the operational data store and the underlying database for the data warehouse. The next generation of System z is growing into a heterogeneous architecture with which you can take advantage of System z-managed "accelerators" running on IBM System x® or IBM Power Blades. The first of these accelerators is the IBM Smart Analytics Optimizer for DB2 for z/OS V1.1, an "all-in-one" solution in which System z, z/OS, DB2 on z/OS, an IBM BladeCenter®, and IBM storage work together to accelerate certain queries by one to two orders of magnitude. With the IBM Smart Analytics Optimizer, slices of data are periodically offloaded from DB2 on z/OS to the BladeCenter. After a query is launched against that data, it will automatically run against the data kept on the BladeCenter. The BladeCenter will process the query an order of magnitude faster than DB2 on z/OS, because all data is cached in internal memory on the BladeCenter and special compression techniques are used to keep the data footprint small and efficient. As a solid information management architecture ready for the future, System z has it all.

Author: Mike Ebbers
Publisher: IBM Redbooks
ISBN: 0738434787
Category : Computers
Languages : en
Pages : 540

View

Book Description
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

Author: Octavian Lascu
Publisher: IBM Redbooks
ISBN: 073843891X
Category : Computers
Languages : en
Pages : 542

View

Book Description
The popularity of the Internet and the affordability of information technology (IT) hardware and software have resulted in an explosion dramatic increase in the number of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on a variety of platforms, and the IBM® System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. This IBM Redbooks® publication provides information about the IBM zEnterprise® BC12 (zBC12), an IBM scalable mainframe server. IBM is taking a revolutionary approach by integrating separate platforms under the well-proven System z hardware management capabilities, while extending System z qualities of service to those platforms. The zEnterprise System consists of the zBC12 central processor complex, the IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension (zBX). The zBC12 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The zBC12 provides the following improvements over its predecessor, the IBM zEnterprise 114 (z114): Up to a 36% performance boost per core running at 4.2 GHz Up to 58% more capacity for traditional workloads Up to 62% more capacity for Linux workloads The zBX infrastructure works with the zBC12 to enhance System z virtualization and management through an integrated hardware platform that spans mainframe, IBM POWER7®, and IBM System x® technologies. The federated capacity from multiple architectures of the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment through the Unified Resource Manager. This book provides an overview of the zBC12 and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. This book is intended for systems engineers, consultants, planners, and anyone who wants to understand zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z technology and terminology.

Author: Lydia Parziale
Publisher: IBM Redbooks
ISBN: 0738435651
Category : Computers
Languages : en
Pages : 142

View

Book Description
The IBM® Smart Analytics System 9600 is a single, end-to-end business analytics solution to accelerate data warehousing and business intelligence initiatives. It provides integrated hardware, software, and services that enable enterprise customers to quickly and cost-effectively deploy business-changing analytics across their organizations. As a workload-optimized system for business analytics, it leverages the strengths of the System z® platform to drive: Significant savings in hardware, software, operating, and people costs to deliver a complete range of data warehouse and BI capabilities Faster time to value with a reduction in the time and speed associated with deploying Business Intelligence Industry-leading scalability, reliability, availability, and security Simplified and faster access to the data on System z

Author: Octavian Lascu
Publisher: IBM Redbooks
ISBN: 0738438863
Category : Computers
Languages : en
Pages : 568

View

Book Description
The popularity of the Internet and the affordability of IT hardware and software have resulted in an explosion of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on various platforms, and the IBM® System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. This IBM Redbooks® publication addresses the new IBM zEnterprise® System. This system consists of the IBM zEnterprise EC12 (zEC12), an updated IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension (zBX) Model 003. The zEC12 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The superscalar design allows the zEC12 to deliver a record level of capacity over the prior System z servers. It is powered by 120 of the world's most powerful microprocessors. These microprocessors run at 5.5 GHz and are capable of running more than 75,000 millions of instructions per second (MIPS). The zEC12 Model HA1 is estimated to provide up to 50% more total system capacity than the IBM zEnterprise 196 (z196) Model M80. The zBX Model 003 infrastructure works with the zEC12 to enhance System z virtualization and management. It does so through an integrated hardware platform that spans mainframe, IBM POWER7®, and IBM System x® technologies. Through the Unified Resource Manager, the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment. This book provides information about the zEnterprise System and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. It is intended for systems engineers, consultants, planners, and anyone who wants to understand the zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z® technology and terminology.

Author: Bill White
Publisher: IBM Redbooks
ISBN: 0738436119
Category : Computers
Languages : en
Pages : 418

View

Book Description
The popularity of the Internet and the affordability of IT hardware and software have resulted in an explosion of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on a variety of platforms, and the System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. This IBM® Redbooks® publication discusses the IBM zEnterprise System, an IBM scalable mainframe server. IBM is taking a revolutionary approach by integrating separate platforms under the well-proven System z hardware management capabilities, while extending System z qualities of service to those platforms. The zEnterprise System consists of the IBM zEnterprise 114 central processor complex, the IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension. The z114 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The z114 provides up to 18% improvement in uniprocessor speed and up to a 12% increase in total system capacity for z/OS®, z/VM®, and Linux on System z over the z10TM Business Class (BC). The zBX infrastructure works with the z114 to enhance System z virtualization and management through an integrated hardware platform that spans mainframe, POWER7TM, and System x technologies. The federated capacity from multiple architectures of the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment through the Unified Resource Manager. This book provides an overview of the zEnterprise System and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. This book is intended for systems engineers, consultants, planners, and anyone wanting to understand the zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z technology and terminology.

Author: Bill White
Publisher: IBM Redbooks
ISBN: 0738436054
Category : Computers
Languages : en
Pages : 440

View

Book Description
The popularity of the Internet and the affordability of IT hardware and software have resulted in an explosion of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on a variety of platforms, and the System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. The zEnterprise System consists of the IBM zEnterprise 196 central processor complex, the IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension. The z196 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The z196 Model M80 provides up to 1.6 times the total system capacity of the z10TM EC Model E64, and all z196 models provide up to twice the available memory of the z10 EC. The zBX infrastructure works with the z196 to enhance System z virtualization and management through an integrated hardware platform that spans mainframe, POWER7TM, and System x® technologies. Through the Unified Resource Manager, the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment. This IBM® Redbooks® publication provides an overview of the zEnterprise System and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. This book is intended for systems engineers, consultants, planners, and anyone wanting to understand the zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z technology and terminology. The changes to this edition are based on the System z hardware announcement dated July 12, 2011.

Author: Makenzie Manna
Publisher: IBM Redbooks
ISBN: 0738459534
Category : Computers
Languages : en
Pages : 90

View

Book Description
Modernization of enterprise IT applications and infrastructure is key to the survival of organizations. It is no longer a matter of choice. The cost of missing out on business opportunities in an intensely competitive market can be enormous. To aid in their success, organizations are facing increased encouragement to embrace change. They are pushed to think of new and innovative ways to counter, or offer, a response to threats that are posed by competitors who are equally as aggressive in adopting newer methods and technologies. The term modernization often varies in meaning based on perspective. This IBM® Redbooks® publication focuses on the technological advancements that unlock computing environments that are hosted on IBM Z® to enable secure processing at the core of hybrid. This publication is intended for IT executives, IT managers, IT architects, System Programmers, and Application Developer professionals.

Author: Dean Brown
Publisher: IBM Redbooks
ISBN: 0738440892
Category : Computers
Languages : en
Pages : 152

View

Book Description
IBM® DB2® for IBM z/OS® helps lower the cost of managing data by automating administration, increasing storage efficiency, improving performance, and simplifying the deployment of virtual appliances. By automating tasks such as memory allocation, storage management, and business policy maintenance, DB2 is able to perform many management tasks itself, freeing up Database Administrators to focus on new projects. This IBM Redbooks® publication introduces autonomics for DB2 for z/OS. IBM provides several different components that, when combined, can create an autonomic database environment. All these respective components cover certain aspects of autonomics, which can collaborate into one coherent solution. In our evolution of autonomics and the need to move to smarter systems there has been a bigger drive to the concept of "Active" versus "Passive" autonomics. With the inclusion of the IBM Management Console for IMSTM and DB2 for z/OS and the Autonomics Director, it is now easier than ever to make that transition by leveraging the strength of the DB2 Utilities Solution Pack for z/OS all in one standardized and centralized interface. This publication guides you through the business reasons for adopting autonomic solutions, and provides step-by-step guidance to implement these capabilities in your DB2 for z/OS configuration. This publication is of interest primarily to DB2 Database Administrators and DB2 Systems Programmers, and for anyone looking to understand the benefits of DB2 autonomic solutions.

Author: Helmut Hellner
Publisher: IBM Redbooks
ISBN: 0738434000
Category : Computers
Languages : en
Pages : 216

View

Book Description
Data is one the most critical and valuable assets of a business. Critical strategic decisions can be made more quickly and effectively when they are based on complete, accurate, and timely operational data. From this point of view, it is important to have an enterprise data management architecture that supports a flexible global view of the business. Many environments today are heterogeneous with a high quantity and diversity of data. In this IBM® Redbooks® publication, we help enterprise architects and IT managers with these environments make decisions for a centralized database or data warehouse. We recommend a centralized data management environment on Linux® on System z®. We include guidance for IBM z/VSETM and Linux specialists to reorganize existing IBM DB2® VSE data and build a database environment with continuous operation in Linux on System z. We begin this book by describing the possibilities and advantages of enterprise data management and different technical ways to realize it. Then we discuss planning, which is important for setting the foundation of the architecture that is implemented. We explain the hardware considerations for capacity and performance planning. For the z/VSE system and Linux on System z, we describe considerations for operation in a logical partition (LPAR) and in a virtualized environment with IBM z/VM®. In addition, we discuss the disk behavior for different workloads, storage dependencies, network connections, and DB2 database considerations. We also guide you in customizing the DB2 server for z/VSE, z/VM, and DB2 on Linux to allow existing z/VSE and z/VM applications to access the database on Linux on System z. We include the data migration, application considerations, dependencies, compatibility, monitoring, and tuning possibilities in such an environment.