This IBM Redbooks publication is one in a series of IBM publications written specifically for the IBM System Blue Gene supercomputer, Blue Gene/L, which was developed by IBM in collaboration with Lawrence Livermore National Laboratory (LLNL). This book provides an overview of the application development performance analysis environment for Blue Gene/L. This book explains some of the tools that are available to do application-level performance analysis. It devotes the majority of its content to Chapter 3, "External Performance Instrumentation Facility" and Chapter 4, "Performance Application Programming Interface."

Altiris Deployment Solution is an industry leading management product which helps reduce the cost of deploying servers from bare metal and managing them all from a centralized location. Its user interface makes it easy to deploy operating systems and applications, apply custom configurations, and distribute software updates. Deployment Solution runs in either a virtual or physical server environment and supports deploying Linux, Windows, and ESX Server, as well as virtual machines to an ESX Server system. Deployment Solution also integrates with the IBM ServerGuide Scripting Toolkit to offer custom scripts for IBM hardware to further optimize the automation and standardization of complex server deployments on IBM hardware. Deployment Solution is a ServerProven application and is available directly from IBM. This IBM Redbooks publication describes the features of Altiris Deployment Solution and explains in detail how to implement features such as managing and deploying firmware updates and hardware configuration changes, image-based and script-based deployments, and integration with the IBM management tools. This book addresses the common issues and recommends best practices to overcome many of the challenges that arise during initial deployment setup. Update September 2006: Added 4.1.4, "Additional updates" on page 109 describing how to deploy updates such as server diagnostics using Altiris Deployment Solution and the ServerGuide Scripting Toolkit.

This IBM Redbooks publication shows in detail IBM Branch Transformation Toolkit for WebSphere Studio Version 5.1 and explains how to migrate from Branch Transformation Toolkit Version 4.3 to Branch Transformation Toolkit 5.1. We provide guidelines for the architecture of the target solution, the correct use of migration tools, and migration-sizing. This book also describes how to build new applications in Branch Transformation Toolkit V5.1. We explain both top-down and bottom-up development, and discuss how to use WebSphere Studio and Branch Transformation Toolkit development plug-ins. We also describe rich Java client development using the Branch Transformation Toolkit. This book is intended for the following audiences: - Solution architects who require a description of IBM Branch Transformation Toolkit for WebSphere Studio and how to build a solution - IT professionals and executives who require a broad understanding of the architecture of the Branch Transformation Toolkit and its implementation - Readers who are familiar with object-oriented software and related development techniques, and have a general knowledge of Java 2 Platform, Enterprise Edition (J2EE) and related technologies Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Monitoring Express Version 6.1 is a powerful, affordable, and easy-to-use availability management solution designed to help small to mid-sized companies manage IT infrastructures. It offers the ability to manage bottlenecks, performance impacts, and outages across heterogeneous environments from a single, centralized portal. IBM Tivoli Monitoring Express V6.1 is easy to install, easy to deploy, and easy to use, providing rapid time to value. It provides real-time and historical data that enables you to quickly diagnose and solve issues with the new GUI through the IBM Tivoli Enterprise Portal component. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Monitoring Express V6.1. We describe planning, installing, and troubleshooting IBM Tivoli Monitoring Express V6.1. In addition, we provide some case studies that you can use as part of a proof of concept or a customer demonstration. The target audience for this book is IT specialists working on new IBM Tivoli Monitoring Express V6.1 installations. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Provisioning Manager Express Version 4.1 for Software Distribution is an easy-to-use, comprehensive solution for software distribution, patch, inventory, and asset management. This Web-based solution is designed for ease of use and implementation so that you can quickly begin to manage the PCs in your enterprise. IBM Tivoli Provisioning Manager Express V4.1 for Software Distribution is implemented with both a client agent on the managed PCs and a centralized data repository. The product is specifically targeted for the small-to-medium business (SMB) market. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Provisioning Manager Express V4.1 for Software Distribution. We discuss the planning, installation, configuration, usage and troubleshooting of the operation. In addition, we provide a case study using a fictitious company, called XYZ Corporation. The target audience for this book is IT specialists working on IBM Tivoli Provisioning Manager Express V4.1 Software Distribution installations and proof of concepts.

Don’t be fooled by the name; IBM Tivoli Directory Integrator integrates anything, and it is not in any way limited to directories. It is a truly generic data integration tool that is suitable for a wide range of problems that usually require custom coding and significantly more resources to address with traditional integration tools. This IBM Redbooks publication shows you how Directory Integrator can be used for a wide range of applications utilizing its unique architecture and unparalleled flexibility. We discuss the business context for this evolutionary data integration and tell you how to architect and design an enterprise data synchronization approach. By telling you everything about Directory Integrator’s component structure and then applying all the techniques in two comprehensive business scenarios, we build a formidable base for your own data integration and synchronization projects. This book is a valuable resource for security administrators and architects who want to understand and implement a directory synchronization project. Please note that the additional material referenced in the text is not available from IBM.

The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server's resources by minimizing network traffic, disk I/O, and CPU time. This IBM Redbooks publication helps you to understand the basics of identifying and tuning the performance of Structured Query Language (SQL) statements using IBM DB2 Universal Database for iSeries. DB2 Universal Database for iSeries provides a comprehensive set of tools that help technical analysts tune SQL queries. The SQL Performance Monitors are part of the set of tools that IBM i5/OS provides for assisting in SQL performance analysis since Version 3 Release 6. These monitors help to analyze database performance problems after SQL requests are run. This book also presents tips and techniques based on the SQL Performance Monitors and other tools, such as Visual Explain. You'll find this guidance helpful in gaining the most out of both DB2 Universal Database for iSeries and query optimizer when using SQL.

“Terry’s style is always direct, approachable, and pragmatic. Abstraction is hard, and visualizing abstractions is as well, but here she’ll guide you in doing both using Rational Software Architect.” —From the Foreword by Grady Booch, IBM Fellow Master UML 2.0 Visual Modeling with IBM Rational Software Architect Using IBM Rational Software Architect, you can unify all aspects of software design and development. It allows you to exploit new modeling language technology to architect systems more effectively and develop them more productively. Now, two of IBM’s leading experts have written the definitive, start-to-finish guide to UML 2-based visual modeling with Rational Software Architect. You’ll learn hands-on, using a simplified case study that’s already helped thousands of professionals master analysis, design, and implementation with IBM Rational technologies. Renowned UML expert Terry Quatrani and J2EE/SOA evangelist Jim Palistrant walk you through visualizing all facets of system architecture at every stage of the project lifecycle. Whether you’re an architect, developer, or project manager, you’ll discover how to leverage IBM Rational’s latest innovations to optimize any project. Coverage includes Making the most of model-driven development with Rational Software Architect’s integrated design and development tools Understanding visual modeling: goals, techniques, language, and processes Beginning any visual modeling project: sound principles and best practices Capturing and documenting functional requirements with use case models Creating analysis models that begin to reveal your optimal system implementation Building design models that abstract your implementation model and source code Using implementation models to represent your system’s physical composition, from subsystems to executables and data Transforming these models to actual running code The IBM Press developerWorks® Series is a unique undertaking in which print books and the Web are mutually supportive. The publications in this series are complemented by resources on the developerWorks Web site on ibm.com. Icons throughout the book alert the reader to these valuable resources.

IBM Workplace Services Express is software that makes it simple 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 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 is written for administrators who want to install, configure, and administer Workplace Services Express on an IBM eServer iSeries server. It introduces you to Workplace Services Express. It shows you how to deploy and customize it on the iSeries server, as well as how to integrate with an existing IBM Lotus Domino infrastructure. In addition, this book shows you how to integrate Domino mail and applications with a Workplace Services Express environment. It explains how to enable the iSeries Web Access portlets so you can work with your iSeries server from a Workplace Services Express environment. And this book provides information about performance tuning for Workplace Services Express on the iSeries server. Please note that the additional material referenced in the text is not available from IBM.

Tivoli Continuous Data Protection for Files is specifically targeted at end user computers, such as mobile computers and workstations, as well as file servers. It provides continuous data protection of files, providing the highest level of protection possible, yet is simple to use and administer. When files change, Tivoli Continuous Data Protection for Files will make up to three copies of the file (or queue copies to be made later). This IBM Redbooks publication presents a deployment guide for Tivoli Continuous Data Protection for Files. We cover planning, installing, and troubleshooting of Tivoli Continuous Data Protection for Files for several use case scenarios. In addition, we provide some case studies, including integration with IBM Tivoli Storage Manager, that can be used as a proof of concept or demonstration of the product at a client environment. The target audience for this book is IT Specialists who will be working on Tivoli Continuous Data Protection for Files installations and proof of concepts.

The primary objective of this IBM Redbooks publication is to provide best practices for the implementation of a License Management solution based on IBM Tivoli License Manager V2.2. This book is divided into two main parts: In Part 1, "Business aspects and project engagement considerations" on page 1, we discuss the reasons why you should deploy a License Management solution. We also position License Management in the overall picture of the IT Service Management and describe the IBM solution in this area. We also provide best practices on how to approach and engage such a project. The high level tasks of such a project are also introduced. We emphasize the fact that you must not only realize what the key elements are that need to be managed to make your project a success, but also how you should organize your IT operations to get the highest benefit from your solution. In Part 2, "Solution design considerations" on page 57, we provide detailed information for the architecture and design of a IBM Tivoli License Manager V2.2 solution implementation. Both IT Architects and IT Specialist benefit from the information provided in this part, as it covers a great deal, from an introduction to IBM Tivoli License Manager V2.2, its components, and architecture, and solution design fundamental tasks, to detailed physical and logical design and configuration of all components of an IBM Tivoli License Manager V2.2 solution.

IBM DB2 Document Manager Version 8.3 is one of the newest members of the IBM Enterprise Content Management portfolio. Document Manager provides a secure and robust platform to manage the complete life cycle of business documents. It helps ensure accurate and up-to-date documents are available on demand. When configured with IBM DB2 Records Manager Version 4.1.2, the Document Manager solution also provide records management capability. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you a single, comprehensive tool to help assess the efficiency of and optimize performance from your DB2 Universal Database in the z/OS environment. It automates the analysis of your database performance in real time and also adds expert database analysis functions to help you maximize performance and enhance productivity.

With IBM Workplace Managed Client Release 2.6 on Linux, IBM offers a strategic end-to-end Linux solution that provides both the benefits of Linux and IBM Workplace Collaboration Services. This IBM Redbooks publication provides a technical overview of IBM Workplace Managed Client and examines why it is a smart, strategic choice. In addition, we provide a detailed description and best practices for deploying, installing and configuring the product. We focus on the following topics: Please note that the additional material referenced in the text is not available from IBM.

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database

This IBM Redbooks publication describes the IBM Tivoli OMEGAMON XE product family, Version 3.1.0, that runs on z/OS. We start by providing the product history over time and the terminology convention that we will use in the book, which should be noted carefully because the products are in transition from Candle terminology to the new terminology related to IBM Tivoli Monitoring Version 6.1. We conform to IBM Tivoli Monitoring V6.1 terminology as much as possible, although for some direct references to screen shots, we use the terminology that is shown in the figure. The product is installed using the IBM Configuration Tool. This is explained for new users who want to install IBM Tivoli OMEGAMON XE, because the process is somewhat different from standard IBM products that are installed on z/OS. The concept of runtime environment is explained here as well. On the operation side of IBM Tivoli OMEGAMON XE, we discuss problem determination and tracing concepts and facilities that are available for IBM Tivoli OMEGAMON XE, as well as performance considerations. As IBM Tivoli OMEGAMON XE is meant to monitor performance of the system, its overhead should not affect overall system performance. Last but not least, we offer sample usage scenarios of performance management using IBM Tivoli OMEGAMON XE products.

DB2 Performance Expert (PE) for Multiplatforms V2.2 is a workstation-based performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 PE simplifies DB2 performance management by providing you with the ability to monitor applications, system statistics, and system parameters using a single tool. This IBM Redbooks publication provides an overview of the architecture of DB2 Performance Expert. We highlight key considerations in planning DB2 PE V2.2 for your environment and provide a step-by-step installation and configuration guide We discuss, in detail, the DB2 PE V2.2 functions and features. Recommendations and tips for DB2 performance tuning are also introduced. Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe how the tool can be used to diagnose and resolve these performance problems.

The Patterns for e-business are a group of proven, reusable assets that can be used to accelerate the design and development of e-business applications. This IBM Redbooks publication focuses on how to reuse the SOA Client - Access Integration patterns to extend enterprise applications to a wide range of client devices such as laptops, PDAs, and mobile phones. Part 1 presents the client access solution domain and benefits of using patterns. We introduce key technologies to serve as a foundation for understanding the Access Integration patterns. Part 2 guides the reader through the process of reusing the patterns assets within the context of the RUP to accelerate the solution design. We include selection criteria to navigate from the Business and IT drivers to the appropriate Application pattern or patterns, and supporting Runtime pattern, component model, and Product mapping instantiated by IBM software products. Part 3 demonstrates how to reuse the patterns for a fictitious ITSO Insurance scenario. The scenario highlights the Distributed Rich Client application pattern, which is used to extend the existing SOA enterprise application. The solution provides mobile adjusters with the capability to work on-site with the customer in a disconnectable mode and sync data with the enterprise when connected to the network. The Runtime pattern is instantiated by IBM WebSphere Everyplace Deployment V6.0. Please note that the additional material referenced in the text is not available from IBM.

Every organization has large amounts of data to store, use, and manage. For most, this quantity is increasing. However, over time, the value of this data changes. How can we map data to an appropriate storage media, so that it can be accessed in a timely manner when needed, retained for as long as required, and disposed of when no longer needed? Information Lifecycle Management (ILM) provides solutions. ILM is the process of managing information—from creation, through its useful life, to its eventual destruction—in a manner that aligns storage costs with the changing business value of information. We can think of ILM as an integrated solution of five IT management and infrastructure components working together: Service management (service levels), content management, workflow management (or process management), storage management, and storage infrastructure. This IBM Redbooks publication will help you understand what ILM is and why it is of value to you in your organization, and provide you with suggested ways to implement it using IBM products.

This IBM Redbooks publication is a study guide for IBM Tivoli Access Manager for e-business Version 6 and is meant for those who want to achieve IBM Certifications for this specific product. The IBM Tivoli Access Manager for e-business Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM Tivoli Access Manager for e-business Version 6 product. This book provides a combination of theory and practical experience needed for a general understanding of the subject matter by discussing the planning, installation, configuration and customization, programming, auditing and troubleshooting of Access Manager for e-business solutions. 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 publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool which, when combined with education activities and experience, can be a very useful preparation guide for the exam.