Now, two leading IBM solution architects show you how to use DB2 to create flexible infrastructures that simplify the construction of any enterprise-class business solution.

The IBM® Db2® Analytics Accelerator (Accelerator) is a logical extension of Db2 for IBM z/OS® that provides a high-speed query engine that efficiently and cost-effectively runs analytics workloads. The Accelerator is an integrated back-end component of Db2 for z/OS. Together, they provide a hybrid workload-optimized database management system that seamlessly manages queries that are found in transactional workloads to Db2 for z/OS and queries that are found in analytics applications to Accelerator. Each query runs in its optimal environment for maximum speed and cost efficiency. The incremental update function of Db2 Analytics Accelerator for z/OS updates Accelerator-shadow tables continually. Changes to the data in original Db2 for z/OS tables are propagated to the corresponding target tables with a high frequency and a brief delay. Query results from Accelerator are always extracted from recent, close-to-real-time data. An incremental update capability that is called IBM InfoSphere® Change Data Capture (InfoSphere CDC) is provided by IBM InfoSphere Data Replication for z/OS up to Db2 Analytics Accelerator V7.5. Since then, an extra new replication protocol between Db2 for z/OS and Accelerator that is called IBM Integrated Synchronization was introduced. With Db2 Analytics Accelerator V7.5, customers can choose which one to use. IBM Integrated Synchronization is a built-in product feature that you use to set up incremental updates. It does not require InfoSphere CDC, which is bundled with IBM Db2 Analytics Accelerator. In addition, IBM Integrated Synchronization has more advantages: Simplified administration, packaging, upgrades, and support. These items are managed as part of the Db2 for z/OS maintenance stream. Updates are processed quickly. Reduced CPU consumption on the mainframe due to a streamlined, optimized design where most of the processing is done on the Accelerator. This situation provides reduced latency. Uses IBM Z® Integrated Information Processor (zIIP) on Db2 for z/OS, which leads to reduced CPU costs on IBM Z and better overall performance data, such as throughput and synchronized rows per second. On z/OS, the workload to capture the table changes was reduced, and the remainder can be handled by zIIPs. With the introduction of an enterprise-grade Hybrid Transactional Analytics Processing (HTAP) enabler that is also known as the Wait for Data protocol, the integrated low latency protocol is now enabled to support more analytical queries running against the latest committed data. IBM Db2 for z/OS Data Gate simplifies delivering data from IBM Db2 for z/OS to IBM Cloud® Pak® for Data for direct access by new applications. It uses the special-purpose integrated synchronization protocol to maintain data currency with low latency between Db2 for z/OS and dedicated target databases on IBM Cloud Pak for Data.

Manufacturing Databases and Computer Integrated Systems is the first book to probe the problems and solutions presented by the diversity of databases within the manufacturing industry. The author examines these heterogeneous databases at both the macro (national/international) level and micro (intracompany and intercompany) level. This book is the result of an extensive international research project that involved 87 leading organizations. Manufacturing Databases and Computer Integrated Systems presents the compelling argument for using computers as database integrators, a concept beyond the obvious applications of number crunching and data storage. The book addresses several different areas of manufacturing technology, including product policies in manufacturing, fuzzy controls in plant operations, concurrent engineering, practical applications for expert systems, organizational prerequisites in manufacturing, heterogenous database environments, the benefits of object-oriented databases, and the requirements for virtual database integration. Manufacturing Databases and Computer Integrated Systems also presents case studies, including the TRW solution applied in Operation Desert Storm, Project CRONUS by BBN, the Intelligent Database Assistant (IDA) by GTE, General Motor's DATAPLEX solution, and Project Carnot by the Microelectronics and Computer Development Corporation (MCC). The book is a "must" for computer and database technologists, engineers, and senior management at most companies worldwide.

“Terry’s style is always direct, approachable, and pragmatic. Abstraction is hard, and visualizing abstractions is as well, but here she’ll guide you in doing both using Rational Software Architect.” —From the Foreword by Grady Booch, IBM Fellow Master UML 2.0 Visual Modeling with IBM Rational Software Architect Using IBM Rational Software Architect, you can unify all aspects of software design and development. It allows you to exploit new modeling language technology to architect systems more effectively and develop them more productively. Now, two of IBM’s leading experts have written the definitive, start-to-finish guide to UML 2-based visual modeling with Rational Software Architect. You’ll learn hands-on, using a simplified case study that’s already helped thousands of professionals master analysis, design, and implementation with IBM Rational technologies. Renowned UML expert Terry Quatrani and J2EE/SOA evangelist Jim Palistrant walk you through visualizing all facets of system architecture at every stage of the project lifecycle. Whether you’re an architect, developer, or project manager, you’ll discover how to leverage IBM Rational’s latest innovations to optimize any project. Coverage includes Making the most of model-driven development with Rational Software Architect’s integrated design and development tools Understanding visual modeling: goals, techniques, language, and processes Beginning any visual modeling project: sound principles and best practices Capturing and documenting functional requirements with use case models Creating analysis models that begin to reveal your optimal system implementation Building design models that abstract your implementation model and source code Using implementation models to represent your system’s physical composition, from subsystems to executables and data Transforming these models to actual running code The IBM Press developerWorks® Series is a unique undertaking in which print books and the Web are mutually supportive. The publications in this series are complemented by resources on the developerWorks Web site on ibm.com. Icons throughout the book alert the reader to these valuable resources.

IBM DB2® for z/OS® is a high-performance database management system (DBMS) with a strong reputation in traditional high-volume transaction workloads that are based on relational technology. IBM WebSphere® Application Server is web application server software that runs on most platforms with a web server and is used to deploy, integrate, execute, and manage Java Platform, Enterprise Edition applications. In this IBM® Redbooks® publication, we describe the application architecture evolution focusing on the value of having DB2 for z/OS as the data server and IBM z/OS® as the platform for traditional and for modern applications. This book provides background technical information about DB2 and WebSphere features and demonstrates their applicability presenting a scenario about configuring WebSphere Version 8.5 on z/OS and type 2 and type 4 connectivity (including the XA transaction support) for accessing a DB2 for z/OS database server taking into account high-availability requirements. We also provide considerations about developing applications, monitoring performance, and documenting issues. DB2 database administrators, WebSphere specialists, and Java application developers will appreciate the holistic approach of this document.

Today, organizations are responding to market demands and regulatory requirements faster than ever by extending their applications and data to new digital applications. This drive to deliver new functions at speed has paved the way for a huge growth in cloud-native applications, hosted in both public and private cloud infrastructures. Leading organizations are now exploiting the best of both worlds by combining their traditional enterprise IT with cloud. This hybrid cloud approach places new requirements on the integration architectures needed to bring these two worlds together. One of the largest providers of application logic and data services in enterprises today is IBM Z, making it a critical service provider in a hybrid cloud architecture. The primary goal of this IBM Redpaper publication is to help IT architects choose between the different application integration architectures that can be used for hybrid integration with IBM Z, including REST APIs, messaging, and event streams.

The IBM® DB2® Analytics Accelerator Version 2.1 for IBM z/OS® (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documentation) is a marriage of the IBM System z® Quality of Service and Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analysis. This IBM Redbooks® publication provides technical decision-makers with a broad understanding of the IBM DB2 Analytics Accelerator architecture and its exploitation by documenting the steps for the installation of this solution in an existing DB2 10 for z/OS environment. In this book we define a business analytics scenario, evaluate the potential benefits of the DB2 Analytics Accelerator appliance, describe the installation and integration steps with the DB2 environment, evaluate performance, and show the advantages to existing business intelligence processes.

This IBM® Redbooks® publication uses the same practical solution and is an extension to Creating Integrated WebSphere Solutions using Application Lifecycle Management, SG24-8243-00. This paper demonstrates how to take an existing application that was built in a legacy environment, and bring that application to IBM PureApplication® Systems, using preferred practices for deployment and automation. The process is illustrated using a business scenario. This publication is intended for architects, developers, and administrators who want to know about the next generation of technology that modern IT organizations are moving rapidly towards: Application integration and systems development.

This IBM® Redbooks® publication provides information about the concepts, planning, and design of IBM WebSphere® Application Server V8 environments. The target audience of this book is IT architects and consultants who want more information about the planning and designing of application-serving environments, from small to large, and complex implementations. This book addresses the packaging and features in WebSphere Application Server V8 and highlights the most common implementation topologies. It provides information about planning for specific tasks and components that conform to the WebSphere Application Server environment. Also in this book are planning guidelines for WebSphere Application Server V8 and WebSphere Application Server Network Deployment V8 on distributed platforms and for WebSphere Application Server for z/OS® V8. This book contains information about migration considerations when moving from previous releases.

Building on the business intelligence (BI) framework and capabilities that are outlined in InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence, SG24-7813, this IBM® Redbooks® publication focuses on the new business insight challenges that have arisen in the last few years and the new technologies in IBM DB2® 10 for Linux, UNIX, and Windows that provide powerful analytic capabilities to meet those challenges. This book is organized in to two parts. The first part provides an overview of data warehouse infrastructure and DB2 Warehouse, and outlines the planning and design process for building your data warehouse. The second part covers the major technologies that are available in DB2 10 for Linux, UNIX, and Windows. We focus on functions that help you get the most value and performance from your data warehouse. These technologies include database partitioning, intrapartition parallelism, compression, multidimensional clustering, range (table) partitioning, data movement utilities, database monitoring interfaces, infrastructures for high availability, DB2 workload management, data mining, and relational OLAP capabilities. A chapter on BLU Acceleration gives you all of the details about this exciting DB2 10.5 innovation that simplifies and speeds up reporting and analytics. Easy to set up and self-optimizing, BLU Acceleration eliminates the need for indexes, aggregates, or time-consuming database tuning to achieve top performance and storage efficiency. No SQL or schema changes are required to take advantage of this breakthrough technology. This book is primarily intended for use by IBM employees, IBM clients, and IBM Business Partners.