Search results

Distributed Relational Database Architecture™ (DRDA®) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of relational database management products that use DRDA can be connected to form a distributed relational database management system. DRDA coordinates communication between systems by defining what can be exchanged and how it must be exchanged. DB2® for z/OS® Distributed Data Facility (DDF) is a built-in component which provides the connectivity to and from other servers or clients over the network. DDF is a full-function DRDA compliant transaction monitor which, equipped with thread pooling and connection management, can support very large networks. Different z/OS workload management priorities can be assigned to different, user-specified classes of DDF-routed application work. In this IBM® Redbooks® publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases. We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination. In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types

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.

Moving data across different databases and even different platforms has been a common task in IT shops for quite some time. Applications may have been developed independently and over time, using packages and different technology; and data might reside on different platforms exploiting the specific platform strong points. However, there still is a growing need for applications that need to access all of this data for overall processing. While new Web related technologies are emerging with the intent to provide functions to collect and integrate information across multiple databases and applications for access in real time, moving data to one location for overall processing is still a very common requirement. This IBM Redbook provides an overview of what is currently available within the DB2 Family of products (specifically DB2 for z/OS, and DB2 for UNIX and Windows) in terms of functions, tools, and utilities to satisfy the need for moving data. We focus on discussing High Performance Unload and Cross Loader; the first one is a tool, the second one is a new option of the Load utility, since they are the latest functions that IBM has released. We also introduce the concepts and some examples of using the Federated Database support.

Web-to host integration has become a well-known term and is understood as an integral part of any e-business. A majority of business-critical data and applications reside on IBM host systems such as IBM S/390, IBM AS/400 and IBM RS/6000. Making this information available to new users and using it in new ways across intranets, extranets and the Internet enable companies to reduce costs, improve services, generate new sources of revenue and establish a competitive advantage. The term legacy application extension is used to describe the trend where companies quickly move existing host applications to the intranet, extranet and the Internet without modifying existing applications. IBM Host Integration products provide a complete solution to address the legacy application extension space with solutions to address the needs of all user groups. This book provides a high-level technical overview of IBM Host Integration solutions. It addresses the issues of choosing a solution. The book features WebSphere network products that can be used to integrate the Web with existing customer host systems, including Host On-Demand, Host Publisher, and Screen Customizer. The functions they provide are compared to other Web-to-host products and features such as CICS Transaction Gateway, IMS Connect, etc.

This redbook describes the e-business options available to VSE customers to open their VSE environments to the e-business world. It offers a broad understanding of 2-tier and 3-tier solutions and of the products you need to implement these solutions. For the 2-tier solution, the use of products like IpServer from Data 21, Inc. and Web/VSE-Host from IntelliWare Systems, Inc. is described. The 3-tier solution is based on the IBM Application Framework for e-business and is implemented through a set of e-business connectors. These include CICS connectors (CICS Transaction Gateway), MQSeries connectors (MQSeries Client for Java) or DB2 connectors (DB2 for VSE & VM and DB2 Connect). This redbook will help you plan for an e-business transition. Detailed examples will help you install, configure, and set up the required products. The book is based on a business scenario that was developed to illustrate how the products implementing the IBM Application Framework for e-business can be used to develop e-business applications. You will learn how Friendly Foods - a fictitious company - accomplished the transition, step-by-step, from a traditionally operating company to an e-business enterprise. The provided examples can readily be adopted by companies of different industries.

This IBM Redbook describes how to install and use the new DB2 Management Tools Package. The DB2 Management Tools Package is a no-charge feature of DB2 for OS/390 Version 5 and Version 6 that delivers the DB2 UDB for OS/390 Control Center, and that can be used along with the existing DB2 client no-charge tools: DB2 Installer, Visual Explain, DB2 Estimator, and DB2 Stored Procedure Builder. The book shows how the DB2 Management Tools Package feature, together with DB2 Connect, brings graphical ease of use to help you install or migrate your DB2 for OS/390, analyze access paths, estimate your DB2 application performance, manage your DB2 systems on UNIX, Windows, OS/2, and OS/390 platforms, and develop stored procedures. This redbook also includes a section on the Workstation Online Monitor, function of DB2 PM, because of its interactions and integration with the DB2 Management Tools. The book is of particular interest for the traditional DB2 for OS/390 specialist who wishes to quickly gain an understanding of these useful client tools.