"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.

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.

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.

This edition of the IBM eServer zSeries 900 Technical Guide contains additional and updated information on the following topics:

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

More Java developers today want to work with XML, the technology that enables data to be transported intact over the Internet, but they don't have time to become XML experts. If this describes you, then you'll appreciate data binding, the new way of converting XML documents into Java objects, so those documents can be worked on and manipulated like any other Java object, then converted back to XML This new title provides an in-depth technical look at XML Data Binding. The book offers complete documentation of all features in both the Sun Microsystems JAXB API and popular open source alternative implementations (Enhydra Zeus, Exolabs Castor and Quick). It also gets into significant detail about when data binding is appropriate to use, and provides numerous practical examples of using data binding in applications. As Author Brett McLaughlin says "Too many books are written about technologies by people who barely understand them. I've already written two data binding implementations (Zeus, and a previous one for IBM DeveloperWorks.) I've actually used data binding for longer than the official specification has been in existence, and I've really been able to dig into what it takes to code an effective data biding implementation, as well as use one correctly. This book is part user guide, part under-the-hood manual, and part use-case. It's a powerful combination, and one I think people need."

Web services enable the new generation of Internet-based applications. These services support application-to-application Internet communication--that is, applications at different network locations can be integrated to function as if they were part of a single, large software system. Examples of applications made possible by Web services include automated business transactions and direct (nonbrowser) desktop and handheld device access to reservations, stock trading, and order-tracking systems. Several key standards have emerged that together form the foundation for Web services: XML (Extensible Markup Language), WSDL (Web Services Definition Language), SOAP (Simple Object Access Protocol), and UDDI (Universal Description, Discovery, and Integration). In addition, ebXML (Electronic Business XML) has been specified to facilitate automated business process integration among trading partners. This book introduces the main ideas and concepts behind core and extended Web services' technologies and provides developers with a primer for each of the major technologies that have emerged in this space. In addition, summarizes the major architectural approaches to Web services, examines the role of Web services within the .NET and J2EE communities, and provides information about major product offerings from BEA, Hewlett-Packard, IBM, IONA, Microsoft, Oracle, Sun Microsystems, and others. Understanding Web Services Key topics include: XML facilities for structuring and serializing data How WSDL maps services onto communication protocols and transports WSDL support for RPC-oriented and document-oriented interactions SOAP's required and optional elements Message processing and the role of intermediaries in SOAP UDDI data formats and APIs How ebXML offers an alternative to Web services that supports reliable messaging, security, and trading-partner negotiations With , you will be well informed and well positioned to participate in this vast, emerging marketplace. Understanding Web Services

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage. This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.

Dive into the details of DB2 Universal Database for iSeries advanced functions and database administration. This IBM Redbooks publication aims to equip programmers, analysts, and database administrators with all the skills and tools necessary to take advantage of the powerful features of the DB2 Universal Database for iSeries relational database system. It provides suggestions, guidelines, and practical examples about when and how to effectively use DB2 Universal Database for iSeries. This book contains information that you may not find anywhere else, including programming techniques for the following functions: - Referential integrity and check constraints - DRDA over SNA, DRDA over TCP/IP, and two-phase commit - DB2 Connect - Import and Export utilities This book also offers a detailed explanation of the new database administration features that are available with Operations Navigator in V5R1. Among the tools, you will find: - Database Navigator - Reverse engineering and Generate SQL - Visual Explain - Database administration using Operations Navigator With the focus on advanced functions and administration in this fourth edition of the book, we moved the information about stored procedures and triggers into a new book -- "Stored Procedures and Triggers on DB2 Universal Database for iSeries", SG24-6503.

This redbook is designed as a study guide for professionals wishing to prepare for the certification exam to achieve: IBM eServer Certified Specialist - pSeries AIX System Administration. The system administration certification validates a broad scope of AIX administration skills and the ability to perform general AIX software system maintenance. This redbook helps AIX administrators seeking a comprehensive and task-oriented guide for developing the knowledge and skills required for the certification. It is designed to provide a combination of theory and practical experience needed for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This redbook does not replace practical experience you should have, but is an effective tool that, when combined with education activities and experience, should prove to be a very useful preparation guide for the exam. Due to the practical nature of the certification content, this publication can also be used as a desk-side reference. So, whether you are planning to take the pSeries AIX System Administration certification exam, or if you just want to validate your AIX system administration skills, this redbook is for you.