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

DB2® packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of distributed computing, Java™ language, new tools, and upgrades in the platform software and hardware. The best practices back then just might not be optimal today. In this IBM® Redbooks® publication, we take a fresh look at bringing packages into the 21st century. We begin with an overview of packages and explain the advantages of using packages. Because database request module (DBRM) based plans have been deprecated in DB2 9, you need to convert to packages if you did not use packages already. We provide guidance on using a DB2 provided function to convert from DBRM-based plans to packages. We re-examine the application development frameworks for packages: program preparation, package setup, and execution. For distributed applications, we include a discussion of a utility to identify and remove deprecated private protocol and converting to DRDA® as well as an introduction to the new pureQuery function of Data Studio. We also discuss common problems and their resolutions. We then explore administration and operational activities dealing with packages, including security, access path management (where we discuss the newly introduced package stability feature to allow for a seamless fallback), and management and performance aspects. The appendixes include useful queries and mention tools for managing packages effectively.

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.

DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as adds greatly to SQL and XML functions. Optimization improvements include more SQL functions to optimize, improved statistics for the optimizer, better optimization techniques, and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the IBM System z9 Integrated Information Processor (zIIP), but changing to use the native SQL procedures on DB2 V9 makes the work eligible for zIIP processing. The performance of varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates. The key DB2 9 for z/OS performance improvements include reduced CPU time in many utilities, deep synergy with IBM System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths, and better sequential access. Virtual storage use below the 2 GB bar is also improved. This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities. We discuss the overall performance and possible impacts when moving from ve

IBM DATABASE 2 Version 9.1 for z/OS (DB2 9 for z/OS throughout this publication) is the thirteenth release of DB2 for MVS. It brings improved synergy with the zSeries hardware and more opportunities to drive business value in the following areas: -- Business insight innovations - Rich hybrid support for relational and pure XML data. - Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP. - A brand new user interface for the Query Management Facility to view and analyze data from either a workstation client or an ordinary Web browser. -- Cost savings through optimized innovations - Streamlined security and regulatory compliance through the implementation of roles, network-trusted contexts, and enhanced auditing. - Performance-boosting innovations such as load and reorg CPU reductions, improved varying length data, logging, and insert performance. - Query management enhancements to make accessing data even faster and more accurate with indexing improvements. -- Business resiliency innovations - Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages. - DB2 restart improvements enhancing performance usability and availability in data sharing environment. This book introduces the enhancements made available with DB2 9 for z/OS. It helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities

Flexibility in business has become of equal in importance with operational efficiency. Service-oriented architecture (SOA) can help businesses respond more quickly and cost-effectively to the changing market conditions by promoting reuse and interconnection of existing IT assets rather than time-consuming and costly reinvention. SOA has been the top fashionable topic in IT for a few years now, which is because there is a consensus of opinions among enterprise architects that SOA is the key to making the IT department a catalyst for growth and innovation. DB2® for z/OS® integrates with Web services, acts as a service provider, and lets SQL applications consume Web services. DB2 customers can make their heritage DB2 applications easily available in a service-oriented architecture and by supporting native XML data types. Using DB2 you can build new applications and exploit the strategic characteristics that XML provides. In this IBM® Redbooks® publication, we help you to get started with SOA by showing the implementation of the minimum requirements: Creating Web services that allow access to data that is stored in data servers or applications and the realization of interaction services for business to consumer integration. We implement these requirements using functions that DB2 for z/OS provides, such as pureXML™ and SOAP UDFs, in conjunction with the functions that Data Studio, DataPower® , and WebSphere® Application Server provide. For use of a more recent version of Data Studio, see IBM Data Stu

IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information that is 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 WebSphere Information Analyzer is a data profiling and analysis tool that is a critical component of IBM Information Server. It is designed to help business and data analysts understand the content, quality, and structure of their data sources by automating the data discovery process. Bundled with IBM WebSphere Information Analyzer is AuditStage, a data rule monitoring tool that is designed to help business and data analysts validate data and assess ongoing data quality trends. This book describes a usage scenario that covers all dimensions of profiling, rule building, deployment, and quality monitoring through a data integration life cycle.

The number of electronic transactions conducted by financial institutions around the world every day is growing astronomically. Today payments can account for a significant portion of a bank's total cost. The ability to move money quickly and safely and to manage the associated data management flows are necessary components of banking. Banks must also gain critical insights from their data to stay steps ahead of Internet-based theft of bank and customer information. These thefts can dangerously undermine the efficiencies of more cost-effective virtual delivery channels. On the positive side, this data can provide key insights into the way their customers behave and the products and services that they are likely to buy. The FIS approach to enterprise payments puts the consumer account at the core, surrounded by rich functionality that provides access via multiple channels, extensive options for managing customer service, as well as a range of integrated fraud management tools. A complete payments solution for issuing and acquiring, clearing and settlement, FIS Enterprise Payments also contributes unique insight into the customer relationship. This IBM Redbooks publication describes the FIS Enterprise Payments offerings and how to implement them. The book is written for decision makers and financial solutions architects, and assumes a basic knowledge of payments systems.

Enterprises look more and more to business intelligence (BI) to gain a competitive edge. Today's BI systems incorporate large data warehouses that are consolidated with near real-time operational data stores (ODS) and continuously updated from multiple sources. An increasing number of users in the enterprise want to access the data warehouse with BI applications with real-time needs. There is a renewed interest in the ability to implement a data warehouse solution on DB2® for z/OS® and System z™. This is due to the inherent characteristics of security, availability, performance, mixed workload management, and the growing portfolio of data warehousing tools and functions provided by IBM®. In this IBM Redbooks® publication, we focus on today's software components on System z and show how you can use them to realize the infrastructure for a full data warehouse solution. By using a retail business scenario loosely based on the TPC-H benchmark, we guide you through the warehouse implementation steps. In addition, we highlight the available methods, techniques, and technologies for the deployment of this solution, including reporting and analysis with Cognos 8 BI. This book provides an opportunity for you to look at satisfying the operational needs of corporate users in addition to the longer term needs. In addition, business decision makers, architects, implementors, DBAs, and data acquisition specialists can use this book to gain a better understanding of how a data warehouse can be designed, implemented, and

Note: This is a republishing of SG24-6489-00, which was withdrawn in error when we updated it with SG24-6489-01. This -00 book covers DB2 V8 while the -01 version covers DB2 V9, so we are making both books available. This IBM Redbook describes the benefits of DB2® V8 for SAP Business Information Warehouse. It lists best practices and provides performance and tuning recommendations for SAP Business Information Warehouse. In today's fast-moving business environment, there is a need for more and better business information. Data warehousing and business intelligence (BI) systems deliver that information. This imposes new requirements to manage, control, and use this data for business purposes. SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information. InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions. However, this structure can lead to slow performance if the system is not set up and managed according to good database principles. This IBM Redbook describes best practices for this product on a zSeries® platform, and provides performance and tuning recommendations for loading and querying data. It also addre