Search results

This IBM Redbook provides an overview of WebSphere Information Integrator Q replication, and provides guidelines for exploiting its high throughput, low latency, and other capabilities in the design and implementation of high-availability and high-performance distributed business solutions on the z/OS and AIX platforms. It also describes a step-by-step approach to implementing bidirectional and peer-to-peer replication solutions in a two-server environment on the z/OS and AIX platforms.

Having more, and more current, information is fast becoming a requirement for business survival. The need permeates the enterprise because it enables proactive decision-making for problem avoidance, rather than reactive problem impact minimization. And that is the key. Thus the need for, and focus on, is real-time. Companies no longer have the long strategic time-frames in which to plan, design, and manage their business processes. Yearly revenue goals and measurements are fast becoming quarterly goals and measurements. Investors and share-holders are more demanding. They are more critical, and less forgiving, of missed performance goals. And these demands are coming at a time when the volume of data is growing, there is an increase in business mergers and acquisitions, the use of strategic outsourcing is growing, and there is an increasing requirement for faster and faster turnaround on information requests. This has put an enormous burden on the information technology (IT) organizations. And most of this change is centered around business intelligence, because that is the environment responsible for providing information for management decision-making. This IBM Redbook explores the techniques and capabilities for evolving to a real-time enterprise. It also demonstrates approaches for that evolution and provides examples to help guide you in developing your strategy and implementation methodology to become a real-time enterprise.

This IBM Redbook provides detailed instructions and scripts on managing failover and switchback in a bidirectional Q replication environment for the AIX platform. A typical business scenario is used to showcase the bidirectional failover/switchback implementation. The redbook also includes a HADR high availability scenario for the source system in a Q replication environment involving unidirectional replication. Key considerations in designing and implementing such environments are discussed. This redbook is organized into the following topics: - High availability concepts - WebSphere Replication Server Q replication overview - Failover and switchback scenarios - HADR and Q replication coexistence scenario - Summary of code and scripts used in the scenarios - Exception processing in a bidirectional Q replication environment - Overview of HADR and DB2 Client Reroute

This IBM Redbook provides detailed instructions and scripts for managing failover and switchback in a WebSphere Replication Server for z/OS bidirectional Q replication environment for the z/OS platform. A typical business scenario is used to showcase the bidirectional failover/switchback implementation. This book also includes a WebSphere MQ shared disk and WebSphere MQ shared queue high availability scenario for the source system in a Q replication environment involving unidirectional replication. Key considerations in designing and implementing such environments are discussed. This book is aimed at an audience of IT architects and database administrators (DBAs) responsible for developing high-availability solutions on the z/OS platform.

This IBM Redbook provides an overview of IBM's event publishing solution delivered via its WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher products, and documents the procedure for implementing a replication and event publishing solution using these products. The book is aimed at an audience of IT architects and database administrators (DBA) responsible for leveraging the WebSphere Information Integrator event publishing capabilities in a variety of business solutions involving replication and event alert systems. Using an insurance industry acquisition scenario involving auto insurance and home insurance companies, this book documents a step-by-step approach to implementing an integrating Customer Information Facility (CIF) application, and an Event Alert System application using WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher.

Many companies across a host of industries are looking at cross-functional business processes to provide better customer-centric services. Companies want to understand and react faster to the immediate concerns of a customer by improving on activities such as customer service, campaign management, and real-time fraud detection. These services require the ability to access and update an integrated, consolidated, current view of detailed operational data. In this IBM Redbook we describe how an Operational Data Store (ODS) can be used to address all of these business issues. We describe how an ODS fits within the business intelligence architecture, and we explain the differences between the ODS and the data warehouse. The capabilities of IBM Data Replication, WebSphere MQ Family, and DB2 Warehouse Manager are explored to show how they can be used to integrate heterogeneous legacy systems and solve many of the ODS issues. Various data integration and transformation methods are described. We show how DB2 Warehouse Manager can be used to manage and monitor the population subsystem. We also take an in-depth look at how DB2 UDB EEE for UNIX and DB2 UDB for z/OS can be used as target ODS databases.

Businesses of all sizes are recognizing the powerful effect that data analysis can have on decision-making, resulting in the increasing deployment of Business Intelligence (BI) applications and solutions. This IBM Redbook contains approaches and methodologies that help you do capacity planning for the system resources that support BI applications accessing DB2 on OS/390. Written for S/390 capacity planners, it includes the following: A discussion of the fundamental concepts of BI environments A structured methodology for doing a capacity plan for the S/390 BI hardware and software infrastructure A detailed description of how experienced capacity planners can modify traditional S/390 capacity planning techniques to address the unique characteristics of BI environments A set of worksheets to help you and your team members develop a S/390 BI infrastructure capacity plan This redbook addresses capacity planning for the S/390 Business Intelligence infrastructure, which includes processors, memory, I/O subsystems and DASD; it does not address capacity planning of network or non-S/390 hardware platforms.

DB2 DataPropagator (DProp) is IBM's strategic data replication solution. As a tightly integrated component of IBM's DB2 Universal Database (UDB) products, IBM DProp enables cross-platform data replication among all members of the DB2 UDB family. DProp is a separately orderable feature for DB2 for OS/390, DB2 for AS/400, DB2 for VM or VSE. In combination with other IBM products, such as IBM DataPropagator NonRelational (DPropNR), DataRefresher, or IBM DataJoiner, IBM DProp easily integrates non-relational data as well as data stored in non-IBM relational database systems into an enterprise-wide distributed multi-platform replication scenario. In this redbook we focus on how IBM's data replication solution is extended to non-IBM relational database systems. IBM DataPropagator and IBM DataJoiner will be used to integrate non-IBM relational databases, such as Informix, Oracle, Sybase Open Server or Microsoft SQL Server, into IBM's enterprise-wide replication solution. Additionally, we will demonstrate how mobile clients using Microsoft Access or other Microsoft Jet databases as a data store can be supplied with data maintained on central DB2 database servers. To make the redbook most useful to support both the design and the implementation phase of a heterogeneous replication project, the book covers general guidelines and specific case studies separately. First, we discuss general implementation options that are available to exploit the flexibility of IBM's data replication solution. We present guidelines to help