IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes. IBM InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components. This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.

This IBM Redbooks publication provides an overview of IBM Information Server, its architecture, and processing flow. It describes the development and implementation of a financial services business scenario that showcases the Service Oriented Architecture (SOA) capabilities of the IBM Information Server product and WebSphere Integration Developer. It includes details on how a DataStage job, QualityStage job, Federated queries, and DB2 Stored Procedures can be surfaced as an SOA service. It describes the development of applications that consume the services generated by IBM Information Server and WebSphere Integration Developer using Rational Application Developer and Microsoft Visual Studio .NET Professional Edition. It is aimed at an audience of IT architects, Information Management specialists, and Information Integration specialists.

This IBM Redbooks publication documents the procedures for implementing IBM OmniFind Enterprise Edition Version 8.4 technology in a single-server Windows environment, two-server Linux environment, and a four-server AIX environment. Supported data sources include DB2, Windows file system, DB2 Content Manager, Lotus Domino, Lotus Quickplace, WebSphere Portal Server, Web Content Management (WCM), and Portal Document Manager (PDM). Tivoli Directory Server (TDS) is the LDAP repository used in the scenarios. It is aimed at IT architects and search administrators who are responsible for managing IBM OmniFind Enterprise Edition on Windows 2003, Red Hat Enterprise Linux, and AIX platforms. The book offers a step-by-step approach to implementing a single-server, two-server, and four-server IBM OmniFind Enterprise Edition environment using typical customer scenarios. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use, automated recovery solution that enables database recovery operations with minimal disruption. Its graphical user interface (GUI) provides powerful reporting and automated recovery capabilities for productive database maintenance and high availability. This book is written for an audience of DB2 for z/OS database administrators (DBA). This book gives you an overview of DB2 Recovery Expert for z/OS, its main features, architecture, recovery semantics, and processing flow. It also describes some of the key considerations in choosing a particular topology to address a business requirement. We provide user scenarios with step-by-step approaches to recover single DB2 for z/OS objects, multiple DB2 for z/OS objects, dropped DB2 for z/OS tables, and DB2 for z/OS subsystems using the IBM Recovery Expert for z/OS tool. We discuss backup and recovery in a DB2 for z/OS environment, the types of failures that might occur, the types of recovery that are supported, the types of objects that can be recovered, the elements and tools of recovery, and the recovery flow. We also provide a brief tutorial of the DB2 Recovery Expert for z/OS GUI client and an overview of the schema level repository (SLR) with recommendations for its maintenance. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution. This publication documents procedures for monitoring existing DB2 II implementations for the purposes of capacity planning. It also documents a methodology for routine and exception monitoring of a DB2 II environment for performance problem determination; and describes some commonly encountered performance problem scenarios and the step-by-step approach used in problem determination and resolution.

This IBM Redbooks publication documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM's Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals responsible for developing e-business solutions that integrate processes and data from multiple distributed heterogeneous systems. This publication provides an overview of IBM’s Patterns for e-business, and the DB2 Information Integration architecture. It also describes the various application and runtime patterns identified to date for Information Aggregation and Data Integration, as defined in "Patterns for e-business". Using a typical customer insight e-business scenario, this publication documents the step-by-step patterns approach to implementing the e-business solution. At each level in the hierarchy, each available pattern is evaluated and chosen before drilling down to the next lower layer where the pattern evaluation and selection process is repeated. The final drill down leads to product selection and implementation information.

This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs). We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance perspective, and describe key performance drivers in OLTP, BI, and mixed workload environments. This book’s primary focus is a single partition (non-DPF) environment, and we provide best practices to achieve optimal application and system performance in OLTP, BI, and mixed workload environments. Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe techniques for problem diagnosis using typical problem scenarios.