Best Practices for SAP Business Information Warehouse on DB2 UDB for Z/OS V8 PDF Download

Author:
Publisher:
ISBN:
Category : Business
Languages : en
Pages : 0

View

Book Description

Author:
Publisher:
ISBN:
Category : Business
Languages : en
Pages : 268

View

Book Description
This IBM Redbook is designed to aid the reader based on specific needs. After describing the product and summarizing its advantages on the zSeries platform, we list best practices for the PSA, Infocube, ODS, and DB2 components. We give tips on how to gain efficiency when using compression and indexing. We also include a troubleshooting chapter that describes what to do when best practices do not address a problem.

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: Ivan Dobos
Publisher: IBM Redbooks
ISBN: 0738453595
Category : Computers
Languages : en
Pages : 40

View

Book Description
This IBM® Redguide® publication explores the business challenges that CIOs in the banking industry face today. It focuses on three core concerns: Ways to reduce the business risk that is involved with operating IT systems and improving infrastructure resilience, enabling business growth by quickly meeting increasing demands from customers, and meeting rapidly changing regulatory compliance requirements. This guide explains how the technology of the IBM zEnterprise® System running SAP for Banking solution solves these major challenges in a cost-effective manner. It provides insight for banking CIOs, executives, managers, and other decision-makers, including IT architects, consultants, and systems professionals.

Author: Chuck Ballard
Publisher:
ISBN:
Category : Business enterprises
Languages : en
Pages : 0

View

Book Description
SAP is a leading ERP vendor, with a large install base. A key element in their product set is the SAP Business Information Warehouse (BW). The primary objective of this IBM Redbooks publication is to provide guidelines to help you implement your SAP Business Information Warehouse on DB2 UDB ESE. Two major considerations when building a business information warehouse are scalability and performance. In this book, we have demonstrated the wide range of scalability of BW when implemented on DB2, while maintaining the performance requirements that are so critical. The parallelism and data partitioning capabilities of DB2 Universal Database ESE, enables a robust, highly scalable, and high performance business information warehouse. For a common understanding, we first discuss the concepts of data warehousing and then describe the SAP architecture and robust component capabilities of the SAP business information warehouse. To help in your implementation, we provide guidelines for how to configure SAP BW when it is built on DB2. We also describe and discuss the key capabilities and parameters to help you get the best from DB2. Key topics such as sizing, partitioning, performance tuning, and systems administration, are discussed to assist in the implementation and maintenance of your system. This book will help enable you to more quickly and easily implement a robust SAP BW on DB2 UDB ESE.

Author: Lydia Parziale
Publisher: IBM Redbooks
ISBN: 0738489026
Category : Computers
Languages : en
Pages : 270

View

Book Description
This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage. This book is written for SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.

Author:
Publisher: IBM.Com/Redbooks
ISBN: 9780738485973
Category : Business intelligence
Languages : en
Pages : 360

View

Book Description

Author: IBM Redbooks
Publisher: IBM.Com/Redbooks
ISBN: 9780738489216
Category : Computers
Languages : en
Pages : 306

View

Book Description

Author: Viviane Anavi-Chaput
Publisher: IBM Redbooks
ISBN: 0738453072
Category : Computers
Languages : en
Pages : 258

View

Book Description
This IBM Redbooks publication addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP sysplex data sharing environment. It introduces the motivations for utilizing a design based on DB2 data sharing. It includes the principal SAP-DB2 data sharing architecture options and trade-offs used in the industry today and issues that play a role in both high availability and scalability, such as failover design, database connectivity design, workload splitting and load balancing, MCOD, and coupling facility design. The book discusses single point of failure, important failover scenarios and outage avoidance, automation of high availability constructs, and backup and recovery considerations in data sharing environments. Performance issues are detailed in the order you would approach them at planning and implementation time. First, it discusses tuning the sysplex, which is the base for a well-performing DB2 data sharing system, then tuning the DB2 data sharing system, which is the base for a well-performing SAP system, and finally, tuning the SAP system. The book focuses on initial planning for performance and monitoring it afterward, and explains the key points to look for to health-check your system and maintain high performance.

Author: IBM Redbooks
Publisher: IBM
ISBN: 9780738490250
Category : Computers
Languages : en
Pages : 380

View

Book Description