Mastering IBM Tivoli Access Manager is a very important factor in successfully deploying contemporary e-business solutions. Access Manager is the key element in an e-business security framework that needs thorough understanding to achieve maximum security, functionality, and performance. Based on expandable security policies for users, groups, and protected resources, Tivoli Access Manager manages authentication and authorization for application servers, Web sites, and virtually any other resource that requires protection, including custom-written applications. This IBM Redbooks publication describes how to build an integrated enterprise business portal with Tivoli Access Manager Version 4.1, WebSphere Portal, mySAP Workplace, and the SAP Enterprise Portal. It also describes how to implement a federated single sign-on solution within a Web Services scenario. This book is partitioned into general and customer scenario based sections. This book is a valuable resource for security administrators and architects who wish to understand and implement a centralized security infrastructure. Please note that the additional material referenced in the text is not available from IBM.

Data warehouses in the 1990s were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher levels of RDBMS scalability and ease of use, being delivered through Web portals. To support this emerging e-Business Intelligence world, the challenges that face the enterprises for their centralized data warehouse RDBMS technology are scalability, performance, availability and smart manageability. This IBM Redbooks publication focuses on the innovative technical functionalities of DB2 UDB ESE V8.1 and discusses: This book positions the new functionalities, so you can understand and evaluate their applicability in your own enterprise data warehouse environment, and get started prioritizing and implementing them. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication discusses how to install, tailor, and configure the INRANGE FC/9000 FICON Director, in conjunction with the FICON topologies supported by zSeries and 9672 Generation 5 and Generation 6 servers. It focuses on the hardware installation as well as the software definitions needed to provide connectivity for supported FICON environments. This book provides planning information and FICON Director setup information. Also included are helpful utilities for monitoring and managing the INRANGE FC/9000 FICON Director environment. This document is intended for system engineers, SAN administrators, and system programmers who will plan and install INRANGE FC/9000 FICON Directors. A good background in systems planning, hardware and cabling infrastructure planning, and zSeries I/O definitions (HCD or IOCP), as well as Fibre Channel or FICON Directors, is assumed.

IBM Tivoli License Manager is a new IBM product that fills a growing need to reconcile software licenses that are already in use in an organization, with the licenses owned by the organization. It offers a technical way to control and apply the software vendors’ pre-defined licensing policies. It allows the Administrator to easily manage different products in different ways, reflecting the rules of each products license agreement. The primary objective of this IBM Redbooks publication is to introduce the new IBM offering for designing and creating a license management solution, and it is targeted at the technical professional responsible for providing license management services in an IT organization. It can be used as a reference book for the deployment of IBM Tivoli License Manager Version 1.1, guiding you during the planning, installation, configuration, administration, tuning, and general product usage phases - focusing on how to effectively deploy this product in a way that quickly generates real business value for customers. This book is a valuable addition to the existing product documentation and should be read in conjunction with the official product documentation, which complements the concepts explained in this book. Please note that the additional material referenced in the text is not available from IBM.

"This is an excellent book that combines a practical and analytical look at the subject." —Leo Korman, Principal Software Engineer, KANA Software As organizations begin to employ XML within their information-management and exchange strategies, data management issues pertaining to storage, retrieval, querying, indexing, and manipulation increasingly arise. Moreover, new information-modeling challenges also appear. —with its contributions from experts at the forefront of the XML field—addresses these key issues and challenges, offering insights into the advantages and drawbacks of various XML solutions, best practices for modeling information with XML, and developing custom, in-house solutions. XML Data Management In this book, you will find discussions on the newest native XML databases, along with information on working with XML-enabled relational database systems. In addition, thoroughly examines benchmarks and analysis techniques for performance of XML databases. XML Data Management Topics covered include: The power of good grammar and style in modeling information to alleviate the need for redundant domain knowledge Tamino's XML storage, indexing, querying, and data access features The features and APIs of open source eXist Berkeley DB XML's ability to store XML documents natively IBM's DB2 Universal Database and its support for XML applications Xperanto's method of addressing information integration requirements Oracle's XMLType for managing document centric XML documents Microsoft SQL Server 2000's support for exporting and importing XML data A generic architecture for storing XML documents in a relational database X007, XMach-1, XMark, and other benchmarks for evaluating XML database performance Numerous case studies demonstrate real-world problems, industry-tested solutions, and creative applications of XML data management solutions. Written for both XML and relational database professionals, provides a promising new approach to data management, one that is sure to positively impact the way organizations manage and exchange information. XML Data Management 0201844524B01302003

The Multiple Components in One Database (MCOD) feature of SAP enables a reduction in the number of DB2 systems that need to be installed and maintained. This significantly simplifies overall database administration and is considered one of the major DB2 competitive advantages. Please note that the additional material referenced in the text is not available from IBM.

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 Redbooks publication 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.

The IBM TotalStorage Expert V2R1 is the rebranded name for the IBM Storwatch Expert. It provides all the function in the StorWatch versions you have come to rely on - and then some. The IBM Total Storage Expert is made up of two component features: Enterprise Storage Server (ESS) Expert and Enterprise Tape Library (ETL) Expert. IBM TotalStorage Expert helps storage administrators boost the productivity of storage resources. It gathers and presents information that helps administrators manage the Enterprise Storage Server (ESS) and three Enterprise Tape Library (ETL) solutions: IBM TotalStorage Enterprise Automated Tape Library, IBM TotalStorage Virtual Tape Server, and IBM TotalStorage Peer-to-Peer Virtual Tape Server. The TotalStorage Expert prepares reports and graphical charts from the data it has collected. These reports and charts can be used in managing assets, capacity, and performance for your ESSs and ETLs. This IBM Redbooks publication will help you to install, tailor, and configure the TotalStorage Expert, and will show you how to use TotalStorage Expert.

Today data mining is no longer thought of as a set of stand-alone techniques, far from the business applications, and used only by data mining specialists or statisticians. Integrating data mining with mainstream applications is becoming an important issue for e-business applications. To support this move to applications, data mining is now an extension of the relational databases that database administrators or IT developers use. They use data mining as they would use any other standard relational function that they manipulate. This IBM Redbooks publication positions the new DB2 data mining functions: Part 1 of this book helps business analysts and implementers to understand and position these new DB2 data mining functions. Part 2 provides examples for implementers on how to easily and quickly integrate the data mining functions in business applications to enhance them. And part 3 helps database administrators and IT developers to configure these functions once to prepare them for use and integration in any application. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication introduces the new Geac commerce platform .connect applications -- the call.connect and vendor.connect applications. These applications extend and enhance the capabilities of Geac System21 into the intranet and Internet. This book targets consultants or customers who work with these .connect applications. It explains how to install, maintain, integrate, and manage these applications on the IBM eServer iSeries server. It also helps you to understand the architecture and middleware used by the applications. Prior to reading this book, you must be familiar with the basic, traditional use of the iSeries or AS/400 and System21. For example, you should know how to enter simple commands and understand such concepts as the library list. Similarly for System21, you should be familiar with the menus and such tasks as defining a System21 user. As necessary throughout the book, detail is provided about the newer, less traditional features of the iSeries such as the integrated files system (IFS), Qshell, Java, and WebSphere.

IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514) Expert DB2 programming tips, techniques, and guidelines from application development experts Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more CD-ROM contains complete DB2 application development sample exam The definitive, authoritative guide to DB2 OS/390 application development certification Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more Includes a full section on object-relational programming and other advanced techniques Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514) About the CD The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam. IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514). This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application development exam for the OS/390 and z/OS platforms. IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes: Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder Best practices for application testing, debugging, and performance tuning The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF Object-relational programming, including user-defined functions, user-defined data types, and triggers In-depth coverage of locking and concurrency Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource. IBM DB2 Series

"Contextual collaboration" is a new term whirling in the industry today. This phenomenal new type of business asset can be realized by two major mechanisms: the components managing mechanism and the services delivery mechanism. The component managing mechanism deals with calendar, workflow, messaging, e-mail, and so on, while the services delivery mechanism deals with receiving and responding to a request. In terms of IBM product offerings, we have Domino for the component managing mechanism and WebSphere for the services delivery mechanism. We need standards to connect the applications from different business entities: your customers, your suppliers, your business partners, and you. These business entities may run their business applications on different platforms, different application languages, different networks, and so on. To connect these un-identical entities together, we need standards. For that, we have Web Service standards such as SOAP, WSDL, XML, and UDDI. This IBM Redbooks publication provides real application scenarios which illustrate how to transform existing Domino applications into either a Web Service provider or a Web Service requester. This is achieved and served through the integration of Domino and WebSphere Application Server.

IMS DataPropagator (IMS DPROP) is a licensed program that maintains consistency between two copies of the same data, where one copy of the data is stored in an IMS Database Manager (IMS DB) database and the other copy is stored in a DB2 database. IMS DPROP is a key component of IBM's Data Replication Solution and IBM's Business Intelligence Solution. Please note that the additional material referenced in the text is not available from IBM.

The Lotus Discovery Server is a knowledge server. It provides search and expertise location solutions designed to ensure that the relevant knowledge and collective experience of an organization is readily available to help individuals and teams solve everyday business problems. In this IBM Redbooks publication we provide an in-depth discussion of the architecture and capabilities of the newest release of the Discovery Server - Discovery Server 2.0. We discuss the key aspects involved in planning for the deployment of this product, from both organizational and technical viewpoints. We also discuss: the key elements of a solid infrastructure design to ensure scalability and reliability, development and maintenance of an enterprise taxonomy, integration of Discovery Server into your existing environment and applications, use of the Discovery Server API toolkit, and ongoing Discovery Server maintenance. This book is appropriate for technologists and project managers who are involved with Lotus Discovery Server-related projects. Please note that the additional material referenced in the text is not available from IBM.

In this IBM Redbooks publication, we describe the new features and functions in IMS Version 8. We document the tasks necessary to exploit the features, and identify migration, coexistence, and fallback considerations. We also identify specific hardware and software requirements that are needed to exploit certain enhancements. First we provide an overview, where we have grouped the various enhancements and their discussion into the categories availability and recoverability, performance and capacity, systems management, and application enablement. Then we have more detailed chapters for describing the individual enhancements. The base enhancements part of the book describes the base product enhancements that apply to all users migrating to IMS Version 8. The Parallel Sysplex enhancements part of the book describes enhancements in IMS Version 8 that apply to both existing users of IMS Version 6 or IMS Version 7 in a Parallel Sysplex environment and users that are considering sysplex functionality. The Common Service Layer part documents the Common Service Layer (CSL), new in IMS Version 8, which is the next step in IMS Parallel Sysplex evolution. The CSL enables IMS systems to operate in unison in an OS/390 Parallel Sysplex. The CSL components provide the infrastructure for an IMSplex. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication deals with exploiting DB2 UDB’s materialized views (also known as ASTs/MQTs), statistics, analytic, and OLAP functions in e-business applications to achieve superior performance and scalability. This book is aimed at a target audience of DB2 UDB application developers, database administrators (DBAs), and independent software vendors (ISVs). We provide an overview of DB2 UDB’s materialized views implementation, as well as guidelines for creating and tuning them for optimal performance. We introduce key statistics, analytic, and OLAP functions, and describe their corresponding implementation in DB2 UDB with usage examples. Finally, we describe typical business level queries that can be answered using DB2 UDB’s statistics, analytic, and OLAP functions. These business queries are categorized by industry, and describe the steps involved in resolving the query, with sample SQL and visualization of results.

The Patterns for e-business are a group of proven, reusable assets that can be used to increase the speed of developing and deploying Web applications. The pattern discussed in this IBM Redbooks publication, Self-Service::Directly Integrated Single Channel application pattern, covers Web applications needing one or more point-to-point connections with back end applications. Part 1 of the book guides you through the process of selecting an Application and Runtime pattern. Next, the platform-specific product mappings are identified based upon the selected Runtime pattern. Part 2 of the book provides a set of guidelines for building your Web application with the enterprise tier using Web services, JCA and JMS. These guidelines include technology options, application design, application development, systems management, and security. Part 3 of the book teaches you by example how to design and build sample solutions using IBM WebSphere Application Server V4.0 with Web services, JCA and IBM CICS, and JMS and IBM MQSeries. Please note that the additional material referenced in the text is not available from IBM.

Mastering the IBM Tivoli Access Manager is the most important factor for successfully deploying contemporary e-business solutions. Access Manager is the key element in an e-business security framework that needs thorough understanding to achieve maximum security, functionality, and performance. Based on expandable security policies for users, groups, and protected resources, the Tivoli Access Manager manages the authentication and authorization to application servers, Web sites, and virtually any other resource that requires protection, including custom-written applications. This IBM Redbooks publication explains the planning steps and describes how to build multi-level enterprise business portals with the new Tivoli Access Manager Version 3.9. It also discusses high-availability scenarios and platform coverage for various involved components like Web servers, registries, and Access Manager management components. It shows the integration of Access Manager into the IBM WebSphere Application Server, IBM WebSphere Everyplace Suite, BEA WebLogic application server, Siebel, and other products. This book is a valuable resource for security administrators and architects who wish to understand and implement a centralized security infrastructure.

iSeries Access for Web (5722-XH2) - the latest offering in the iSeries Access Family (5722-XW1) product - offers Web browser-based access to IBM eServer iSeries servers. iSeries Access for Web helps leverage business information, applications, and resources across an enterprise by extending the iSeries resources to the client desktop through a Web browser. IBM WebSphere Host Publisher 4.0 (5724-B81) can modernize host applications or replace traditional character-based interfaces with a Web look and feel. These host applications can run directly from any standard Web browser. Host Publisher integrates multiple sources of data, including host and database applications, into a single Web page with no change to backend applications. Host Publisher and Host Publisher Studio have been bundled with the iSeries Access for Web product to provide a complete Web-to-host integration solution. This IBM Redbooks publication is designed for basic-level users who want to use iSeries Access for Web V5R2 or WebSphere Host Publisher V4.0. It shows you how to install and use iSeries Access for Web and WebSphere Host Publisher on the iSeries server through several example applications. It summarizes the Web-to-host products. Then it presents various circumstances to help you decide which product to choose when you consider integrating enterprise data into the Web.

is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms. SQL Performance Tuning Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization—and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations. Topics covered include: General and specific tuning General sort considerations and options Joins and subqueries Columns and tables Indexes, including B-trees and bitmaps Constraints and stored procedures ODBC and JDBC Data changes and concurrency control (locking) Clients, servers, and middleware Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today's popular database environments. Throughout , ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical examples are written in ANSI/ISO Standard SQL: 1999. SQL Performance Tuning