This IBM Redbooks publication describes the copy functions available with the IBM TotalStorage Enterprise Storage Server (ESS). The powerful ESS Copy Services functions are explained in detail, and their characteristics are thoroughly covered. This book also provides information on how to manage the various ESS Copy Services functions, and discusses their implementation. This book applies to the ESS Models when used in the IBM eServer zSeries environments. Because this book provides a broad understanding of the ESS Copy Services functions, as well as presenting details about the management interfaces and the implementation considerations, it is a recommended manual for IT professionals who are planning the implementation of any of the ESS Copy Services functions in a zSeries environment, as well as for those who will manage these environments. This fifth edition of the book has been updated with the latest ESS Copy Services announcements: Asynchronous PPRC can be used for a two site Disaster Recovery solution, a FlashCopy target can now be a PPRC primary, and there are several other updates associated with ESS LIC 2.4.0. These include the ESS Model 750 overview, minor additions for ESS API support, Multiple Device Manager Replication Manager, Asynchronous PPRC Utilities for Open System Environment, and Asynchronous PPRC Utilities for ICKDSF User.

This IBM Redbooks publication provides a first look at the Solution Installation capability that is a key component of the IBM Autonomic Computing initiative. Autonomic computing technologies enable complex computing systems to be self-configuring, self-healing, self-optimizing, and self-protecting. One aspect of this is the ability to automate the change management processes associated with deploying and managing software required for business solutions. The Solution Installation technologies that are described are evolving and will be enhanced over time. This publication provides the reader with an opportunity to understand the underlying concepts and facilities. This publication is based on Version 1.2 of the Solution Installation toolkit and describes both architectural concepts as well as specific examples that apply to the current version. We attempt to make clear when a key architectural concept is not fully implemented at this time. Readers of this book will gain an understanding of the basic concepts, and how the architecture described will provide business value as it becomes fully implemented and utilized by IBM and other software vendors. Please note that the additional material referenced in the text is not available from IBM.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment. “In my experience in the security world, including 32 years at the Central Intelligence Agency, I’ve not found anyone with more experience in the theory and practice of protecting your data than David Knox.” --Dave Carey, former Executive Director of the CIA

XML in Data Management is for IT managers and technical staff involved in the creation, administration, or maintenance of a data management infrastructure that includes XML. For most IT staff, XML is either just a buzzword that is ignored or a silver bullet to be used in every nook and cranny of their organization. The truth is in between the two. This book provides the guidance necessary for data managers to make measured decisions about XML within their organizations. Readers will understand the uses of XML, its component architecture, its strategic implications, and how these apply to data management. Takes a data-centric view of XML Explains how, when, and why to apply XML to data management systems Covers XML component architecture, data engineering, frameworks, metadata, legacy systems, and more Discusses the various strengths and weaknesses of XML technologies in the context of organizational data management and integration

This IBM Redbooks publication describes and explains the features and functions of the IBM TotalStorage Open Software Family, which is designed to help you simplify your storage infrastructure, optimize storage utilization, and adapt quickly and dynamically to the on demand world. The book introduces storage virtualization, on-demand solutions, and storage management software by explaining the concepts, architecture, and systems management features of the IBM TotalStorage Open Software Family and showing available complementary products. It will help you design solutions to protect data holdings from losses ranging from those caused by user error to complete site disasters. This easy-to-follow guide gives a broad understanding of the IBM TotalStorage Open Software Family software, the key technologies to know, and the solutions available to protect your business. It offers understanding of how the IBM TotalStorage Open Software Family solutions will work in heterogeneous environments including Windows, UNIX/AIX/Linux, OS/400, and z/OS platforms, and with such mission-critical applications as DB/2, Oracle, Lotus Domino, Exchange, mySAP.com, and many more.

SAP is a leading ERP vendor, with a large install base. A key element in their product set is the SAP Business Information Warehouse (BW). The primary objective of this IBM Redbooks publication is to provide guidelines to help you implement your SAP Business Information Warehouse on DB2 UDB ESE. Two major considerations when building a business information warehouse are scalability and performance. In this book, we have demonstrated the wide range of scalability of BW when implemented on DB2, while maintaining the performance requirements that are so critical. The parallelism and data partitioning capabilities of DB2 Universal Database ESE, enables a robust, highly scalable, and high performance business information warehouse. For a common understanding, we first discuss the concepts of data warehousing and then describe the SAP architecture and robust component capabilities of the SAP business information warehouse. To help in your implementation, we provide guidelines for how to configure SAP BW when it is built on DB2. We also describe and discuss the key capabilities and parameters to help you get the best from DB2. Key topics such as sizing, partitioning, performance tuning, and systems administration, are discussed to assist in the implementation and maintenance of your system. This book will help enable you to more quickly and easily implement a robust SAP BW on DB2 UDB ESE.

This IBM Redbooks publication will help users to select the appropriate tape solution for various backup scenarios found in open systems environments. This book is a tape product selection and differentiation guide that is designed to assist users in finding all the information needed to select the best tape solution for the designated backup environment. This guide describes the information gathering process and product selection criteria to differentiate among the available IBM tape offerings. It provides a basis for tape differentiation. It is not, however, intended as a tape system sizing guide. For this purpose, users should use the sizing tools provided by each product family. This guide focuses primarily on identifying backup environments for the IBM 358x Ultrium product family (LTO) and the environments for the IBM TotalStorage Enterprise Tape System 3590 and 3592. Single user or departmental type backup environments are also addressed through providing information on the entry level tape product lines such as 4mm or This edition of the book has been updated with information about the following: IBM 3592-J1A tape drive; WORM and Economy cartridge support for the IBM 3592; new models of the IBM TotalStorage UltraScalable Tape Library 3584; and new models of the IBM TotalStorage Ultrium Tape 2U Autoloader 3581.

Large IT organizations increasingly face the challenge of integrating various web services, applications, and other technologies into a single network. The solution to finding a meaningful large-scale architecture that is capable of spanning a global enterprise appears to have been met in ESB, or Enterprise Service Bus. Rather than conform to the hub-and-spoke architecture of traditional enterprise application integration products, ESB provides a highly distributed approach to integration, with unique capabilities that allow individual departments or business units to build out their integration projects in incremental, digestible chunks, maintaining their own local control and autonomy, while still being able to connect together each integration project into a larger, more global integration fabric, or grid.Enterprise Service Bus offers a thorough introduction and overview for systems architects, system integrators, technical project leads, and CTO/CIO level managers who need to understand, assess, and evaluate this new approach. Written by Dave Chappell, one of the best known and authoritative voices in the field of enterprise middleware and standards-based integration, the book drills down into the technical details of the major components of ESB, showing how it can utilize an event-driven SOA to bring a variety of enterprise applications and services built on J2EE, .NET, C/C++, and other legacy environments into the reach of the everyday IT professional.With Enterprise Service Bus, readers become well versed in the problems faced by IT organizations today, gaining an understanding of how current technology deficiencies impact business issues. Through the study of real-world use cases and integration patterns drawn from several industries using ESB--including Telcos, financial services, retail, B2B exchanges, energy, manufacturing, and more--the book clearly and coherently outlines the benefits of moving toward this integration strategy. The book also compares ESB to other integration architectures, contrasting their inherent strengths and limitations.If you are charged with understanding, assessing, or implementing an integration architecture, Enterprise Service Bus will provide the straightforward information you need to draw your conclusions about this important disruptive technology.

“A good book for people who deal with SAP systems for a living. I haven’t read another book like this. It’s technical but it’s also an entertaining read. A pleasant departure from the norm.” —David C. Gilliland, Senior Consultant, SAP America, Inc. “Clearly, this book could be used as an excellent development tool and could help a company like mine perfect performance tuning steps and standards.” —Dennis Prince, SAP Development/Support Specialist, Hewlett-Packard “SAP optimization is one of those subjects that developers struggle to find time for and managers don’t know is necessary. Presenting the value of the process up front serves to give the developer ammunition to win time for optimization and the manager an education in the value and necessity of optimization. Even if the manager types don’t read past chapter 3, George’s job is done. They should be convinced that someone technical in their IT department needs to be reading this book. Anderson explains the value, then the core technology, and then when we’re all on the same page, the process. To me, that was very helpful.” —Crew Reynolds, Software Development Manager, Daydots “This book features good discussion on performance tuning the mySAP suite that no other books have so far. This is the perfect book for SAP Stress Test Project Managers, SAP Stress Test Project Teams, SAP Basis Administrators, Oracle DBAs, Unix Administrators managing SAP systems, and project implementation teams. Those who stress test their systems well with the help of this book will have significant returns.” —Sanjoy Rath, SAP Consultant Drive maximum performance and value from your SAP investment! In this book, a leading expert on SAP performance walks through every facet of tuning and optimizing mySAP Solutions, and the technology layers underpinning these solutions, to maximize performance and value. George W. Anderson covers the entire testing and tuning process: planning, staffing, developing, testing, executing, validating, evaluating... and acting on what you’ve learned. Anderson offers unparalleled guidance with regard to predicting the impact of system changes—from new hardware to updated NetWeaver-enabled business processes. Along the way, he shows how to make the most of countless optimization and monitoring tools—from free and low-cost technology stack-based utilities to comprehensive, automated SAP testing suites. His vendor-neutral, unbiased coverage includes: Quantifying concrete performance requirements—even for complex, cross-application business processes Testing and monitoring daily system loads, month-end or seasonal business peaks, key transactions, and complex multi-system business processes Conducting comprehensive server, SAN/disk subsystem, and database testing Managing the testing process, leveraging proven best practices and techniques Analyzing, verifying, and quantifying SAP availability, scalability, and TCO Regardless of the technology infrastructure underpinning your SAP solutions, if you’re responsible for deploying, managing, maintaining, refreshing, upgrading, or supporting SAP technologies, you need this book— now.

This IBM Redbooks publication presents a deep and broad understanding about event management with a focus on best practices. It examines event filtering, duplicate detection, correlation, notification, escalation, and synchronization. Plus it discusses trouble-ticket integration, maintenance modes, and automation in regard to event management. Throughout this book, you learn to apply and use these concepts with IBM Tivoli Enterprise Console 3.9, NetView 7.1.4, and IBM Tivoli Switch Analyzer 1.2.1. Plus you learn about the latest features of these tools and how they fit into an event management system. This book is intended for system and network administrators who are responsible for delivering and managing IT-related events through the use of systems and network management tools. Prior to reading this book, you should have a thorough understanding of the event management system in which you plan to implement these concepts. Please note that the additional material referenced in the text is not available from IBM.

With Tivoli Data Warehouse, you can analyze historical trends from various Tivoli and customer applications. The Tivoli Data Warehouse infrastructure enables a set of extract, transform, and load (ETL) utilities to extract and move data from Tivoli application data stores to a central repository. The open architecture of Tivoli Data Warehouse also enables data from non-Tivoli applications to be integrated into its central repository. Data from the central repository can be extracted into data marts that pertain to the reporting needs of selected groups. These data marts can also be used to produce cross application reports. This IBM Redbooks publication focuses on planning, installation, customization, use, maintenance, and troubleshooting topics related to the new features of the Tivoli Data Warehouse version 1.2. This is done using a number of case study scenarios and several warehouse enablement packs. The instructions given in this book are very detailed and explicit. These instructions are not the only way to install the products and related prerequisites. They are meant to be followed by anyone to successfully install, configure, and set up Tivoli Data Warehouse environments of any size.

Introduction to Database Management Systems is designed specifically for a single semester, namely, the first course on Database Systems. The book covers all the essential aspects of database systems, and also covers the areas of RDBMS. The book in

Written by Sun Microsystems' Java™ BluePrints team, is the authoritative guide to the best practices for designing and integrating enterprise-level Web services using the Java 2 Platform, Enterprise Edition (J2EE) 1.4. This book provides the guidelines, patterns, and real-world examples architects and developers need in order to shorten the learning curve and start building robust, scalable, and portable solutions. Designing Web Services with the J2EE™ 1.4 Platform The authors use the Java Adventure Builder application to bring the design process to life and help illustrate the use of Java APIs for XML Processing (JAXP), Java APIs for XML-Based RPC (JAX-RPC), and other Web service and Java-XML technologies. Key topic coverage includes: Web service requirements and design issues Support for Web services provided by the J2EE 1.4 platform Designing and implementing Web service end points Writing efficient Web service client applications Designing and developing XML-based applications Integrating applications and data using Web services The J2EE platform security model as it applies to Web services A coherent programming model for designing and developing Web service endpoints and clients provides the insight, advice, and detail that make it easier to create effective Web service applications using the J2EE 1.4 platform. Designing Web Services with the J2EE™ 1.4 Platform

Web developers rely on XML to separate data from presentation and create a consistent templating system for a web site. Although limited XML-to-HTML conversion is possible within some browsers, web developers creating dynamic or complex sites will find server-side XML transformation a necessity. Unfortunately, until recently, there have been few XML tools available for server-side XML transformation or authoring. AxKit, a mod_perl and Apache-based XML content delivery solution, was designed to meet that need with a cost-effective and efficient plugin architecture. AxKit allows the developer to quickly design modules to create faster web sites, and deliver them in a wide variety of media formats. AxKit also takes care of caching so the developer doesn't have to worry about it. AxKit meets the demands of the web developer nicely, but, as with any new toolkit, there is a learning curve. For developers who want to flatten that learning curve and get right to work with AxKit, XML Publishing with AxKit provides detailed information on how to install, configure, and deploy AxKit effectively. The first book solely devoted to AxKit, XML Publishing with AxKit also offers a concise and focused look at how to create XSLT and XPathScript-based pipelines for XML data transfer. This solidly useful new book presents web programmers with the hands-on knowledge they need to get really creative with AxKit. It features a thorough introduction to XSP (extensible Server Pages), which applies the concepts of Server Pages technologies (embedded code, tag libraries, etc) to the XML world, and covers integrating AxKit with other tools such as Template Toolkit, Apache:: Mason, Apache::ASP, and plain CGI. The book also includes invaluable reference sections on configuration directives, XPathScript, and XSP. With XML Publishing with AxKit, web developers will have all the tools they need to deliver complex XML-based systems quickly, the power to develop their own systems for style sheet negotiation, and the flexibility to design completely new style sheet languages. XML Publishing with AxKit gives those new to XML all the background and the courage they need to jump right in and deploy AxKit. And it gives XML-savvy professionals everything they need to hit the ground running.

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner’s guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. · Includes graph theory and programming techniques. · Running examples throughout the book help illustrate and tie concepts together. · Loads of code, available for download from www.mkp.com.

In Microsoft's Office 2003, users experience the merger of the power of the classic Office suite of applications with the fluidity of data exchange inherent in XML. With XML at its heart, the new version of Microsoft's desktop suite liberates the information stored in millions of documents created with Office software over the past fifteen years, making it available to a wide variety of programs. Office 2003 XML offers an in-depth exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Developers will learn how they can connect Microsoft Office to others systems, while power users will learn to create and analyze XML documents using familiar Office tools. The book begins with an overview of the XML features included in the various Office 2003 components, and explores in detail how Word, Excel, and Access interact with XML. This book covers both the user interface side, creating interfaces so that users can comfortably (and even unknowingly) work with XML, and the back end, exposing Office information to other processes. It also looks at Microsoft's new InfoPath application and how it fits with the rest of Office. Finally, the book's appendices introduce various XML technologies that may be useful in working with Office, including XSLT, W3C XML Schema, RELAX NG, and SOAP. Office 2003 XML provides quick and clear guidance to a anyone who needs to import or export information from Office documents into other systems. Both XML programmers and Office power will learn how to get the most from this powerful new intersection between Office 2003 and XML.

The IBM Grid Toolbox can assist enterprises that deploy, manage, and control grid computing, as well as developers who create products that assist in managing and deploying grids. This grid-enabling toolkit contains standardized development code, much of which was harvested from the open source community, plus an added database and run-time environment. This IBM Redbooks publication is designed to give the reader a comprehensive view of the IBM Grid Toolbox. As the IBM Grid Toolbox is designed in a layered approach, we describe the product by introducing each underlying layer until the whole ecosystem is revealed. The product significantly leverages open standards in the grid computing world, so we show how the IBM Grid Toolbox complements and enhances these standards for the development and deployment of grid services and applications.

The IBM Eserver zSeries® 990 scalable server provides major extensions to the existing zSeries architecture and capabilities. The concept of Logical Channel Subsystems is added, and the maximum number of Processor Units and logical partitions is increased. These extensions provide the base for much larger zSeries servers. This IBM® IBM Redbooks publication is intended for IBM systems engineers, consultants, and customers who need to understand the zSeries 990 features, functions, availability, and services. IBM Eserver zSeries 990 Technical Introduction, SG24-6863 Note that the information in this book includes features and functions announced on April 7, 2004, and that certain functionality is not available until hardware Driver Level 55 is installed on the z990 server.

This IBM Redbooks publication introduces the IBM eServer zSeries 890, which represents the continuation of the scalable servers featured with the IBM eServer zSeries 990. The z890 is based on z/Architecture, the zSeries building blocks of the z990, and the virtualization technology of passed sever families. It is designed to be resilient in the unpredictable on demand world. The z890 is a single model server with a wide range of capacity settings, delivering significantly improved granularity and enriched functions over its predecessor. At the same time, the z890 is also introducing the new eServer zSeries Application Assist Processor (zAAP), which provides a Java execution environment. This publication provides information on the hardware and software features available with the z890. It also includes planning and migration considerations. This technical introduction is intended for hardware planners, system engineers, and consultants who need to understand the capabilities of the z890.

Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft’s customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials—how to architect a report, as well as how to install and program Reporting Services—is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and visual layouts to enable maximum visual understanding of the data analysis. Interactivity features (enhanced in SQL Server 2005) and security are also covered in detail. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you’re a beginning programmer or new to this version of the technology, you’ll understand the fundamental techniques for using Reporting Services. A companion CD includes data sets and sample code.