IBM, a leader in collaboration, has created IBM Workplace Collaboration Services--a new completely, integrated collaborative environment based on open standards. IBM Workplace Collaboration Services provides a wide range of integrated, ready-to-use communication and collaboration capabilities as services for the IBM Workplace environment. This includes capabilities such e-mail, calendaring and scheduling, presence and awareness, instant messaging, learning, team spaces, Web conferencing, and document and Web content management. This IBM Redbooks publication is an installation and deployment guide for IBM Workplace Collaboration Services Release 2.5. We provide detailed installation procedures for Microsoft Windows and Novell SUSE Linux and highlight clustered deployment.

Deploying a storage management solution for a small or medium-size business begins with a thorough analysis of the existing business and IT environment. The next step after fully understanding the organization is planning and sizing. This is the key stage, because deployment success depends on how well you plan and size. This IBM Redbooks publication takes a step-by-step approach to deploying a storage management solution based on IBM Tivoli Storage Manager. The first two chapters introduce overall planning and sizing issues. Then we focus on the detailed installation and configuration of Tivoli Storage Manager, and offer some deployment scenarios and troubleshooting of storage management implementation. Readers should be familiar with the following topics: This book does not cover whole IBM Tivoli Storage Manager components or other discussions for the planning and sizing experience.

IBM TotalStorage Productivity Center is designed to provide a single point of control for managing networked storage devices that implement the Storage Management Initiative Specification (SMI-S), including the IBM TotalStorage SAN Volume Controller, Enterprise Storage Server, and FAStT. TotalStorage Productivity Center includes the IBM Tivoli Bonus Pack for SAN Management, bringing together device management with fabric management, to help enable the storage administrator to manage the Storage Area Network from a central point. The storage administrator has the ability to configure storage devices, manage the devices, and view the Storage Area Network from a single point. This software offering is intended to complement other members of the IBM TotalStorage Virtualization family by simplifying and consolidating storage management activities. This IBM Redbooks publication includes an introduction to the TotalStorage Productivity Center and its components. It provides detailed information about the installation and configuration of TotalStorage Productivity Center for Disk and TotalStorage Productivity Center for Replication and how to use them. It is intended for anyone wanting to learn about TotalStorage Productivity Center and how it complements an on demand environment and for those planning to install and use the product.

IBM Tivoli Configuration Manager controls software distribution and asset management inventory in a multiplatform environment. It is designed for configuration, distribution, change, version, and asset management in a distributed computing environment. Working on top of IBM Tivoli Management Framework, IBM Tivoli Configuration Manager provides an integrated solution for managing complex, distributed enterprise environments. This IBM Redbooks publication introduces the IBM Tivoli Configuration Manager logical and physical components and covers detailed planning and implementation steps to deploy IBM Tivoli Configuration Manager in small-to-medium and large-sized environments, including IBM AIX 5L, Microsoft Windows, Linux, and IBM OS/400 systems. In addition, we talk about best practices, advanced customization, and tuning topics for IBM Tivoli Configuration Manager. This book will be useful for IT specialists responsible for implementing IBM Tivoli Configuration Manager V4.2.x in customer environments. Please note that the additional material referenced in the text is not available from IBM.

Linux on zSeries offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on zSeries takes advantage of the qualities of service in the zSeries hardware—making it a robust industrial strength Linux. This provides an excellent platform for consolidating Oracle databases that exist in your enterprise. This IBM Redbooks publication describes experiences gained while installing and testing Oracle10g for Linux on zSeries, such as: -Installing a single instance database of Oracle10g instances for Linux on zSeries Interested readers include database consultants, installers, administrators, and system programmers.

This IBM Redbook is a study guide for IBM Tivoli Storage Manager Version 5.3 and is meant for those who want to achieve IBM Certifications for this specific product.

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized database SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints How data sets can interact with queries The importance of subqueries Data conversion and manipulation via SQL's built-in functions How conditional logic can be used in Data StatementsBest of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL. Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

This IBM Redbooks publication is part of a series of documents related to grid computing that IBM is presenting to the IT community to enrich it and all its players: clients, industry leaders, emerging enterprises, universities, and producers of technology. It is mainly oriented to IT architects or those who have the responsibility of analyzing the capabilities of the product used to build a grid solution. We describe the functions of grid computing and the categorizations of the components within it. IBM, ISVs, and open source products will be explained. Some of these products are not specific for grid, but they can be used in a grid computing environment. We hope that this book helps you select functions and products and shows you how grid can fit into your IT picture as new products and services for grid are introduced. Part 1 introduces the concept of grid computing and provides the terminology the readers will use in this book. Part 2 explores the functionality associated with certain products and product families. It also presents some examples of the utilization of these products in the grid computing environment. Part 3 presents grid computing product families that can be used to build a complete grid solution. These bundles, or suites, often implement most of the core grid disciplines. Part 4 gives an overview of the grid computing offerings and services that IBM provides.

This IBM Redbooks publication presents an overview of IBM Tivoli Storage Manager Version 5.3. It is designed as a workshop presentation guide, and therefore uses presentation slides to provide descriptions about the changes made in the new release. This format enables you to easily gain a comprehensive overview and to quickly understand the new features of Tivoli Storage Manager. This book is intended for IBM Clients, Business Partners, consultants, and IBM and Tivoli staff who are familiar with earlier releases of Tivoli Storage Manager and who want to understand what is new in Version 5.3.0, 5.3.1, and 5.3.2. We recommend that you use this book in conjunction with the ITSO workshop, the book "IBM Tivoli Storage Manager Version 5.3 Technical Guide", SG24-6638, manuals and readme files that are provided with the products. This book is not intended to replace any information contained therein.

IBM Workplace Services Express is software that makes it easy for you, your colleagues, your teams, and your entire organization to quickly collaborate and effectively work together. Designed specifically for small and medium-sized organizations with less than a thousand employees, or departmental needs in larger organizations, Workplace Services Express enables you to easily create, edit, and share documents from your own customized Workplace environment. This IBM Redbooks publication will introduce you to Workplace Services Express and its features and tell you how to deploy and customize it. Whether you are a line-of-business manager who wants to understand the business value of Workplace Services Express, an administrator who wants to install it, or an application developer who wants to customize it, this book is for you. Please note that the additional material referenced in the text is not available from IBM.

The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change. This IBM Redbooks publication focuses on strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB). It provides detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities. XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB. The features and functionality of each DBMS are briefly described for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL. It also discusses products and tools to complement these database management systems. With this information, you can better decide which products satisfy your particular requirements, and better plan on how to achieve your objectives as you develop your database management system strategy. You will be better positioned to make informed decisions that can give you the best return on your DBMS investment.

This IBM Redbook introduces the IBM System z9 109 (z9-109), which offers a continuation of the IBM scalable mainframe servers. The z9-109 server is based on z/Architecture and provides extensions to the architecture. In addition to increased performance and expansion options, particular emphasis has been placed on the integration of the z9-109 into a complete system and software environment.

MS/VCR provides a fast, reliable facility with high integrity for the renaming and recataloging of data sets on target volumes after a FlashCopy or Snapshot volume copy, solving the cloned data access dilemma. This facility enables the immediate use of the data from the same system as the original copy. MS/VCR resolves catalog conflicts of like-named datasets that are created by "cloning" a volume. It also solves internal conflicts that are created when copying a volume to a different VOLSER. MS/VCR is designed to rename and catalog target volume datasets in record time. The window of time required to copy and rename a target dataset is a critical factor for many customers. This IBM Redbooks publication provides a broad understanding of the MS/VCR product and how to use it in real situations.

This IBM Redbooks publication provides advice for Business Partners or other technical people about how to plan, implement, and demonstrate IBM Tivoli Storage Manager Version 5.3 in a proof-of-concept simulated environment. This environment can be used to demonstrate the capabilities of the IBM Tivoli Storage Manager solutions using customer data, in order to gain customer acceptance for the next phase of the sell cycle to engage the Business Partner in a real proof-of-concept of IBM Tivoli Storage Manager. Please note that the additional material referenced in the text is not available from IBM.

Deploying and managing distributed systems in hundreds or thousands of branch banks and retail stores, called outlets, requires careful planning of the automation to cope with the sheer numbers of systems involved. This IBM Redbooks publication demonstrates how to architect, establish, and configure a Tivoli systems management environment that supports the central management of thousands of outlet systems based on the open United Linux platform. The main focus of this book is to provide step-by-step instructions, sample scripts, and code to install and deploy the core Tivoli products that enable the organization to: - Deploy and maintain distributed application solutions This book is intended for IT professionals with a basic understanding of the core Tivoli product set and who are responsible for deploying a Tivoli management infrastructure. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication is an easy-to-follow guide that describes how to implement IBM Tivoli Storage Manager Version 5.3 products in highly available clustered environments. The book is intended for those who want to plan, install, test, and manage the IBM Tivoli Storage Manager Version 5.3 in various environments by providing best practices and showing how to develop scripts for clustered environments. The book covers the following environments: IBM AIX HACMP, IBM Tivoli System Automation for Multiplatforms on Linux and AIX, MicrosoftCluster Server on Windows 2000 and Windows 2003, VERITAS Storage Foundation HA on AIX, and Windows Server 2003 Enterprise Edition. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides practical information related to problem determination using IBM Self-Managing Autonomic Technology, with an emphasis on the components provided by the IBM Autonomic Computing Toolkit. The primary objective of this book is to empower software developers to provide facilities to enable applications or other system components to participate in an autonomic environment and focuses on the problem determination capabilities provided by the IBM Autonomic Computing Toolkit and other Self-Managing Autonomic Technology. The tools, components, and techniques used and demonstrated in this book provide the base for automating problem determination and self-healing of applications and components using Self-Managing Autonomic Technology. As with the technologies themselves, components of the IBM Autonomic Computing Toolkit will evolve as new capabilities and tools become available. Software developers are encouraged to check the latest releases of both IBM Autonomic Computing Toolkit and other tools provided by IBM at http://www.ibm.com/developerworks/autonomic. Please note that the additional material referenced in the text is not available from IBM.

DFSMSrmm from IBM is the full function tape management system available in OS/390 and z/OS. With DFSMSrmm, you can manage all types of tape media at the shelf, volume, and data set level, simplifying the tasks of your tape librarian. Are you a new DFSMSrmm user? Then this IBM Redbooks publication introduces you to the DFSMSrmm basic concepts and functions. Are you already using DFSMSrmm? In that case, this book provides the most up-to-date information about the new functions and enhancements introduced with the latest release of DFSMSrmm. You will find useful information for implementing these new functions and getting more benefits from DFSMSrmm. Do you want to test DFSMSrmm functions? If you are using another tape management system and are thinking about converting to DFSMSrmm, you may start DFSMSrmm and run it in parallel to your current system for testing purposes. This book is intended to be a starting point for new professionals and a handbook for using the basic DFSMSrmm functions. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Workload Scheduler is a strategic, multiplatform distributed scheduling product that provides high-volume, complex scheduling capability. Although Tivoli Workload Scheduler provides native support for many platforms and applications, its robust scheduling capabilities can be extended to cover additional platforms and applications by writing an extended agent. This IBM Redbooks publication shows how to write a Tivoli Workload Scheduler Version 8.2 extended agent to schedule jobs on IBM Tivoli Storage Manager. With the extended agent, you can schedule on platforms and applications for which Tivoli Workload Scheduler has no native agent, as well as integrate IBM Tivoli Storage Manager with Tivoli Workload Scheduler. The Tivoli Workload Scheduler scheduling facility enables you to assign dependencies among tasks scheduled through Tivoli Storage Manager or to assign limits or priorities. By extending Tivoli Storage Manager to schedule these Tivoli Storage Manager tasks, you can take advantage of its advanced scheduling capabilities. This book will be essential for those who write a Tivoli Workload Scheduler extended agent for any platform in general, or use the extended agent provided in this book (TSM Extended Agent) to schedule Tivoli Storage Manager tasks. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication prepares you with the necessary knowledge to help you complete Certification Test 593: IBM Tivoli Monitoring V5.1.1 Implementation . This test leads to certification for Tivoli Certified Deployment Professional for IBM Tivoli Monitoring. The scope of the certification tests your ability to demonstrate the following areas of expertise required for IBM Tivoli Monitoring V5.1.1: Prerequisite knowledge for IBM Tivoli Monitoring Planning the implementation Installation prerequisites The installation process Configuration of the IBM Tivoli Monitoring server Problem determination General operations IBM Tivoli Monitoring Workbench You can find the information that you need about these topics all in this book. Plus, you have a chance to test your knowledge using the sample questions at the back of the book.