This IBM Redbooks publication recommends strategies that you can use to replace the Distributed Computing Environment (DCE) dependencies in your environment and move to new technologies. The following topics are covered: This book is a valuable information source if you are an executive, administrator, or developer of an IBM customer environment that uses IBM DCE for a distributed systems and application infrastructure. Although strategies for replacing DCE are described, the book does not cover strategies for replacing dependencies to IBM products that use DCE, such as DFS and TXSeries. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication is the third volume of a series of redbooks called IMS in the Parallel Sysplex. These redbooks describe how IMS exploits the Parallel Sysplex functions and how to plan for, implement, and operate IMS systems working together in a Parallel Sysplex. This book encompasses two parts. Part 1, Implementation, is a description of the tasks an IMS installation must execute to enable each of the functions. Part 2, Operations, addresses the operational issues associated with running an IMSplex that include startup and shutdown, steady state operations, online change, and recovery from failure. IMS in Parallel Sysplex, Volume I: Reviewing the IMSplex Technology, SG24-6908

This IBM Redbooks publication will help you to migrate batch VSAM applications to exploit transactional VSAM. DFSMStvs is available in a z/OS environment and offers the ability for VSAM data to be shared for both read and write operations while maintaining integrity and recoverability. DFSNStvs allows logging of changes to recoverable VSAM data sets. Batch programs can use commit and backout functions. This book assumes that you are familiar with the material in the companion book DFSMStvs Overview and Planning, SG24-6971, and refers extensively to material published in that book. We also assume some familiarity with CICS Transaction Server and z/OS. The book is intended for application developers who want to understand how to change applications to make best use of the facilities offered by DFSMStvs and to coexist well with other batch applications and with CICS systems sharing the same VSAM data sets. We assume that you are familiar with the development of batch applications and with the facilities and use of VSAM. The tasks involved in setting up DFSMStvs and the hardware and software prerequisites are not discussed in this book; they are described in DFSMStvs Overview and Planning, SG24-6971.

This IBM Redbooks publication describes the High Availability Large Database (HALDB) capability available with IMS. IMS HALDB was introduced with IMS Version 7. It allows IMS databases to grow to almost unlimited sizes while providing increased availability. This book updates IMS Version 7 High Availability Large Database Guide, SG24-5751, as well as adding topics that were not covered in the previous book. This publication provides a broad explanation of HALDB and its uses. Specific areas covered include: -HALDB overview, definition, and structure This publication documents our hands-on experience in a test environment. It includes migration and administration examples. Some IBM Data Management Tools for IMS are also discussed in this publication. Special emphasis is given to the IMS HALDB Conversion and Maintenance Aid product. Examples of the use of these tools are provided.

Today's corporate computing environment is too often characterized by silos of data in enterprise applications like ERP, CRM, and supply chain management. Integrating these applications involves hardwiring connections between them, often resulting in a rigid and inefficient IT infrastructure.Packaged Composite Applications (PCAs) are an innovative answer to this dysfunctional scenario. Originated by SAP, one of the worlds foremost technology companies, PCAs represent a new architectural paradigm for enterprise computing. Using web services, they combine new functionality with services from existing applications to enable flexible, cross-functional automation. But is this new model right for your business? That's where this book comes in.Packaged Composite Applications is the result of a systematic search through the brain trust of SAP for all of the relevant arguments, examples, concepts, and analogies related to Packaged Composite Applications. This book is not a marketing treatise about neatly-shaped colored boxes. It is not a backward-looking, outdated description of a product without context. This book, rather, combines the approach of a forward-looking analyst with the perspective of an executive who must make things work, without skimping on the relevant technical details. The author examines the ideas driving PCAs forward in the marketplace and the problems and solutions that an executive and technologist will encounter in implementation. The result is an authoritative text that allows all interested parties to assess the value of PCAs for their lives as executives, technologists, analysts, sales representatives, and users.

The definitive, real-world guide to Oracle data warehousing Maximizing performance, flexibility, and manageability in production environments Hardware/software architectures, star schema design, partitioning, and more Industrial strength data loading and query optimization techniques By the world-renowned architect of 7-Eleven's multi-terabyte datawarehouse Maximize Oracle data warehouse performance, flexibility, and manageability Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes: Data warehousing fundamentals for DBAs--including what a data warehouse isn't Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more Planning hardware architecture: CPUs, memory, disk space, and configuration Radically different star schema design for radically improved performance Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs Improving manageability: The right ways to partition Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including · formulating SQL queries, · understanding how queries are processed by the DBMS,· maximizing performance,· using SQL to enter, modify, or delete data,· creating and maintaining database structural elements, and· embedding SQL in applications.Features· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.· Web enhanced with extra features available online at www.mkp.com. * Second edition of classic SQL handbook Updated to cover changes in the SQL language standard (SQL:1999) Includes CD with MySQL software

Everything a company needs to know to plan, organize, and perform an SAP implementation in one book! This is the only book available that shows the reader how to actually plan an SAP Data Center, install mySAP components, and set up the tools and processes necessary to monitor and manage a productive SAP system. It covers how to perform a Total Cost of Ownership analysis to help refine your SAP Solution Vision, and then how to leverage SAP¿s technology partners to work through the SAP system landscape sizing process. Staffing the project, from the SAP Steering Committee all the way down to the primary SAP basis and computer operations teams, is covered as well. It also covers building high availability and disaster recoverability into your solutions, addressing critical training required by the SAP support team as well as end users, and how to use SAP-provided and a host of other 3rd party tools to manage your mySAP landscape. Finally, this is the only book that covers in detail how to address both functional and stress testing of your solution prior to going live. Throughout the book, knowledge and processes are provided that will help you hit the ground running and help you save money. The book is written by an SAP Technical Certified Consultant with seven years of experience in SAP design and implementation who offers tried and proven approaches, scripts, and tools similar to those used by new and existing SAP customer sites. The accompanying CD of documents, presentations, scripts, checklists, and various tools valued at $50,000 saves time and makes the reader productive fast. Coverage includes notated screen shots of real productive systems; custom checklists, how-to procedures, organization charts that can be leveraged immediately for staffing teams; PowerPoint presentations that can be used by management to sell, present, and provide status updates on their mySAP projects internally; tools, utilities, and XLS spreadsheets used to design, size, and understand SAP system architectures; actual Microsoft Project plans and implementation schedules to get the customer and 3rd party Project Manager's started quickly; and documentation templates and approaches that may be used at once.

This IBM® IBM Redbooks publication explains how to install and configure the new independent auxiliary storage pool (IASP) functionality of OS/400® V5R2. It is designed to help IBM technical professionals, Business Partners, and Customers understand and implement IASP in the IBM eServer iSeries server and under OS/400 V5R2. In addition, this book provides the background information that is necessary to plan, implement, and customize this functionality to your particular environment. It provides advice on running native OS/400 applications with either application data or most application objects residing in an IASP. Considering you can also use IASPs in a cluster environment, this book shows you the basic steps to make your IASP switchable between two iSeries servers in a high-speed link (HSL) loop.

The IBM eServer zSeries 990 provides major extensions to existing zSeries architecture and capabilities. The concept of books and channel subsystems are added to the architecture, and the maximum number of LPARs is increased. These architectural extensions provide the base for much larger zSeries machines. This IBM Redbooks publication provides an overview of these changes, and goes into more detail in selected areas. By removing memory, processor, and channel constraints, z990 can be used for major server consolidation activities. More granular options for nondisruptive maintenance, growth, and alterations provide better 7 x 24 x 365 operation. In general, no changes are needed for existing applications--allowing immediate growth into z990. Readers are assumed to have a general understanding of existing S/390 and zSeries hardware. Terms, acronyms, abbreviations, and concepts associated with existing systems are used without further introduction.

IBM Tivoli Monitoring for Transaction Performance Version 5.1 is part of the Tivoli family of products for managing performance and availability. It combines the functionality of two former Tivoli products, Tivoli Application Performance Management Version 2.1 and Tivoli Internet Services Manager Version 1.7, into one package for transaction performance monitoring. IBM Tivoli Monitoring for Transaction Performance Version 5.1 adds new capabilities for breakdown of e-business transactions that are partly or fully hosted by WebSphere Application Server Version 5.0 servers, as well as functions for simulating transactions run on 3270 and SAP platforms. In addition to discussing the value and benefits of measuring and monitoring transaction performance this book discusses the best use of the new capabilities provided by IBM Tivoli Monitoring for Transaction Performance Version 5.1, and it includes valuable hints and tips for troubleshooting the IBM Tivoli Monitoring for Transaction Performance environment. The information in this book will help Service Level Managers, Network specialists, Web administrators, application owners, and programmers perform their tasks by enabling them to measure, monitor and report end-to-end transaction performance metrics. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Configuration Manager 4.2 was launched in October 2002. Along with many new functional and performance features, it includes an enhanced Web-based device management capability, called Tivoli Web Gateway, running on top of IBM WebSphere Application Server. This IBM Redbooks publication describes in detail the steps required to install and configure the Tivoli Web Gateway and all the prerequisite products, to allow a successful implementation of a pervasive device management environment. While the information provided by this book can be used on deployments of any size, it will be particularly useful to enable the management of pervasive devices by small and medium businesses (SMBs). It will also help Business Partners and IBM services when setting up demonstrations and proofs of concept.

The DFSMShsm control data sets contain information describing the status of the DFSMShsm managed data sets and volumes. Each control data set requires regular maintenance (backup and reorganization) and auditing to ensure the integrity of the data managed by DFSMShsm. The DFSMShsm product provides the AUDIT command to detect, report, diagnose, and often provide automated correction for discrepancies between the control data set, ICF user catalog, and DFSMShsm owned volumes. Mainstar: FastAudit family of products provides the same audit capabilities as with the DFSMShsm AUDIT command, but at faster speeds. Using the FastAudit products, the audits are comprehensive (perform multiple audits with one command), flexible, and easy to use. Audits of some, or all of the z/OS and OS/390 metadata environments can now be done frequently, even daily, to identify and resolve errors before they lead to data loss or failed access. This IBM Redbooks publication outlines the tasks to use DFSMShsm Audit and the use of Mainstar's FastAudit program to manage your HSM environment.

This IBM Redbooks publication gives a broad understanding of the IBM Tivoli Business Systems Manager architecture and internals. The in-depth discussion covers the product’s inner workings and includes log files to illustrate the processing of its various components. IBM Tivoli Business Systems Manager is designed to display all aspects of the enterprise’s IT system as they affect the users’ business systems. This book enables easy implementation of IBM Tivoli Business Systems Manager in distributed environments. Procedures are illustrated with examples of the installation and configuration process to explain the deployment of IBM Tivoli Business Systems Manager into a customer’s environment. This book also covers the implementation of IBM Tivoli Business Systems Manager in z/OS with most of its major interfaces. IBM Tivoli Business Systems Manager can monitor all major IBM subsystems in z/OS, including IMS, DB2, CICS, storage, and Web solutions. A book about concepts and implementation would not be complete without a comprehensive discussion about using, maintaining, and troubleshooting the system. We devote several sections to these topics. Please note that the additional material referenced in the text is not available from IBM.

XML Schema is the new language standard from the W3C and the new foundation for defining data in Web-based systems. There is a wealth of information available about Schemas but very little understanding of how to use this highly formal specification for creating documents. Grasping the power of Schemas means going back to the basics of documents themselves, and the semantic rules, or grammars, that define them. Written for schema designers, system architects, programmers, and document authors, Modeling Business Objects with XML Schema guides you through understanding Schemas from the basic concepts, type systems, type derivation, inheritance, namespace handling, through advanced concepts in schema design. Reviews basic XML syntax and the Schema recommendation in detail.Builds a knowledge base model step by step (about jazz music) that is used throughout the book.*Discusses Schema design in large environments, best practice design patterns, and Schema's relation to object-oriented concepts.

If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your work Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by.

IBM Tivoli Web Access for Information Management is a sophisticated Web application that combines the power of Information Management for z/OS with the flexibility and usability of a Web browser to enable customers to manage their business environments from the Web. A drop-in problem and change management solution designed for help desk, developer, manager, and end user personnel is provided, along with a toolkit for customization support. Also included with the toolkit are administrative tasks that allow you to manage your application from the Web. Web Access supports e-mail and pager notification, change approval, document attachments, and personal profiles and preferences. Using Information Management for z/OS and Web Access, you can easily add or modify record types for a customized application. The HTML generator supplied with the toolkit lets you create the HTML for your records so that you do not have to create it from scratch. Sample business logic is provided, and additional logic can be easily added by writing simple REXX routines. To provide a complete solution, a guidebook is required. This IBM Redbooks publication describes product usage, installation, customization, and other pertinent information regarding the product.

This IBM Redbooks publication is the first volume of a series of redbooks called IMS in the Parallel Sysplex. These redbooks describe how IMS exploits the Parallel Sysplex functions and how to plan for, implement, and operate IMS systems working together in a Parallel Sysplex. Volume 1 provides an overview of the Parallel Sysplex and the services offered to authorized programs such as IMS. It then continues with the description of the functionality that IMS provides in a Parallel Sysplex environment. Each function supported by IMS is presented in one or more chapters. The topics include: - Introduction to the Parallel Sysplex The other volumes in this series are:

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.

RSS is sprouting all over the Web, connecting weblogs and providing news feeds. Originally developed by Netscape in 1999, RSS (which can stand for RDF Site Summary, Rich Site Summary, or Really Simple Syndication) is an XML-based format that allows web developers to describe and syndicate web site content. Using RSS files allows developers to create a data feed that supplies headlines, links, and article summaries from a web site. Other sites can then incorporate them into their pages automatically. Although RSS is in widespread use, people struggle with its confusing and sometimes conflicting documentation and versions. Content Syndication with RSS is the first book to provide a comprehensive reference to the specifications and the tools that make syndication possible. Content Syndication with RSS offers webloggers, developers, and the programmers who support them a thorough explanation of syndication in general and RSS in particular. Written for web developers who want to offer XML-based feeds of their content, as well as developers who want to use the content that other people are syndicating, the book explores and explains metadata interpretation, different forms of content syndication, and the increasing use of web services in this field. This concise volume begins with an introduction to content syndication on the Internet: its purpose, limitations, and traditions, and answers the question of why would you consider "giving your content away" like this? Next, the book delves into the architecture of content syndication with an overview of the entire system, from content author to end user on another site. You'll follow the flow of data: content, referral data, publish-and-subscribe calls, with a detailed look at the protocols and standards possible at each step. Topics covered in the book include: Creating XML syndication feeds with RSS 0.9x and 2.0 Beyond headlines: creating richer feeds with RSS 1.0 and RDF metadata Using feeds to enrich a site or find information Publish and subscribe: intelligent updating News aggregators, such as Meerkat, Syndic8, and Newsisfree, and their web services Alternative industry-centric standards If you're interested in producing your own RSS feed, this step-by-step guide to implementation is the book you'll want in hand.