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.

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

“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” – Sandra Barker, Lecturer, University of South Australia, Australia “Databases are a critical infrastructure technology for information systems and today’s business. Mike Hernandez has written a literate explanation of database technology–a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better.” – Michael Blaha, consultant and trainer, author of A Manager’s Guide to Database Technology “If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn’t have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!” – Matt Greer, Process Control Development, The Dow Chemical Company “Mike’s approach to database design is totally common-sense based, yet he’s adhered to all the rules of good relational database design. I use Mike’s books in my starter database-design class, and I recommend his books to anyone who’s interested in learning how to design databases or how to write SQL queries.” – Michelle Poolet, President, MVDS, Inc. “Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you’re just getting started developing with data or are a seasoned pro; whether you've read Mike’s previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself–this is the book for you. Mike’s ability to explain these concepts in a way that’s not only clear, but fun, continues to amaze me.” –From the Foreword by Ken Getz, MCW Technologies, coauthor ASP.NET Developer's JumpStart “The first edition of Mike Hernandez’s book Database Design for Mere Mortals was one of the few books that survived the cut when I moved my office to smaller quarters. The second edition expands and improves on the original in so many ways. It is not only a good, clear read, but contains a remarkable quantity of clear, concise thinking on a very complex subject. It’s a must for anyone interested in the subject of database design.” – Malcolm C. Rubel, Performance Dynamics Associates “Mike’s excellent guide to relational database design deserves a second edition. His book is an essential tool for fledgling Microsoft Access and other desktop database developers, as well as for client/server pros. I recommend it highly to all my readers.” – Roger Jennings, author of Special Edition Using Access 2002 “There are no silver bullets! Database technology has advanced dramatically, the newest crop of database servers perform operations faster than anyone could have imagined six years ago, but none of these technological advances will help fix a bad database design, or capture data that you forgot to include! Database Design for Mere Mortals™, Second Edition, helps you design your database right in the first place!” – Matt Nunn, Product Manager, SQL Server, Microsoft Corporation “When my brother started his professional career as a developer, I gave him Mike’s book to help him understand database concepts and make real-world application of database technology. When I need a refresher on the finer points of database design, this is the book I pick up. I do not think that there is a better testimony to the value of a book than that it gets used. For this reason I have wholeheartedly recommended to my peers and students that they utilize this book in their day-to-day development tasks.” – Chris Kunicki, Senior Consultant, OfficeZealot.com “Mike has always had an incredible knack for taking the most complex topics, breaking them down, and explaining them so that anyone can ‘get it.’ He has honed and polished his first very, very good edition and made it even better. If you're just starting out building database applications, this book is a must-read cover to cover. Expert designers will find Mike’s approach fresh and enlightening and a source of great material for training others.” – John Viescas, President, Viescas Consulting, Inc., author of Running Microsoft Access 2000 and coauthor of SQL Queries for Mere Mortals “Whether you need to learn about relational database design in general, design a relational database, understand relational database terminology, or learn best practices for implementing a relational database, Database Design for Mere Mortals™, Second Edition, is an indispensable book that you’ll refer to often. With his many years of real-world experience designing relational databases, Michael shows you how to analyze and improve existing databases, implement keys, define table relationships and business rules, and create data views, resulting in data integrity, uniform access to data, and reduced data-entry errors.” – Paul Cornell, Site Editor, MSDN Office Developer Center Sound database design can save hours of development time and ensure functionality and reliability. is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work. Database Design for Mere Mortals™, Second Edition, Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations. This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process. This book will give you the knowledge and tools you need to create efficient and effective relational databases.

If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them. There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done. Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. A complete reference to the MySQL version of SQL, this pocket guide also serves as a convenient companion to our large, in-depth volume, Managing and Using MySQL. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world. O'Reilly's Pocket References have become a favorite among programmers everywhere. By providing important details in a succinct, well-organized format, these pocket-sized books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new MySQL Pocket Reference is the book you'll want to have.

TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.

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.