This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage. This book is written for SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.

This IBM Redbooks publication is the second book in a series of IBM publications written specifically for the IBM System Blue Gene Solution, Blue Gene/L, which was developed by IBM in collaboration with Lawrence Livermore National Laboratory (LLNL). This book focuses on the physical installation and hardware maintenance of the system. More specifically, in the first part of the book, we take you through the steps to place the Blue Gene/L racks and bolt them together. Then we explain the process of cabling the various networks on the system. The second half of the book focuses on powering off the system and then powering it back on, preparing the system for service, and replacing some of the parts.

There is a strong shift in the industry toward reuse of the existing software and hardware resources within the companies to minimize the IT cost. Instead of creating or buying a new solutions, companies are trying to build a set of reusable software components based on the existing applications. These components can be quickly assembled in many different ways to satisfy the business needs of the companies. This environment is based on service-oriented architecture (SOA) and solutions that support business process automation. This book provides the detailed information about multiple ways for building SOA-based solutions around the System i platform. The discussion in the book covers the server and client side implementations that include: - ProgramCall in IBM Toolbox for Java Parts of the book are appropriate for CIOs, system architects, and application developers.

Over the course of many years, the developers in both the Endicott and Rochester labs have been working very hard adding We start low with the details of IP interface and route implementation on i5/OS. Through the study of these building blocks, we show how to create IP networks that are easier to configure, tolerant of faults, and can perform both inbound and i5/OS has always had many built-in Network Security features. These features have been enhanced to include an Intrusion Detection System (IDS). This allows you to be notified of attempts to hack into, disrupt, or deny service to the system. Moving up to the application layer, we demonstrate the dynamic power of IP by having the DHCP server assigning IP addresses and automatically updating the i5/OS Dynamic DNS. Now clients and servers can be added dynamically to the IP network and assigned a name automatically.

This IBM Redbooks publication is one in a series of IBM publications written specifically for the IBM System Blue Gene Solution, Blue Gene/L, which was developed by IBM in collaboration with Lawrence Livermore National Laboratory (LLNL). It provides an overview of the application development environment for Blue Gene/L. This book explains the instances where Blue Gene/L is unique in its programming environment. It does not delve into great depth about the technologies that are commonly used in the supercomputing industry, such as Message Passing Interface (MPI) and Aggregate Remote Memory Copy Interface (ARMCI). References are provided in those instances so you can find more information if desired. Prior to reading this book, you must have a strong background in MPI programming.

Logical Partitioning for OS/400 opened the door to significant operational advantages and cost savings for iSeries and System i clients. You can now manage production workloads from many iSeries servers on a single newer server using LPAR technology. And, in an System i world, you can now consolidate additional operating system environments onto a single System i footprint. This IBM Redbooks publication is about setting up a partitioned iSeries or System i system. The primary focus is about making it possible to share system resources between and among partitions easily, flexibly, and safely. The contents of this book include information and a practical example of how to use an iSeries and System i server tool, Automatic Partition Resource Manager (APRM®) from Barsa Consulting Group, LLC, to help transform a company's infrastructure into an on demand, self-healing environment.

IBM TotalStorage Productivity Center for Replication Version 3, Release 1 brings support for the advanced copy services capabilities on the DS8000 and DS6000, in addition to the support for ESS model 800 and SVC. This support focuses on automating administration and configuration of these services, operational control (starting, suspending, resuming) copy services tasks and monitoring and managing the copy services sessions. In addition to the support for FlashCopy and Metro Mirror, TotalStorage Productivity Center for Replication V3R1 supports Global Mirror on the ESS800, DS8000, and DS6000 hardware platforms. Advanced disaster recovery functions are also supported with failover/failback (planned and unplanned) from a primary site to a disaster recovery site. TotalStorage Productivity Center for Replication also can monitor the performance of the copy services that provide a measurement of the amount of replication and the amount of time that is required to complete the replication operations. This IBM Redbooks publication provides the information you need to install TotalStorage Productivity Center for Replication, and create and manage replication sessions on AIX. Scenarios are provided that document the work performed in our laboratory setting, using the GUI and CLI.

IBM TotalStorage Productivity Center for Replication Version 3,Release 1 brings support for the advanced copy services capabilities on the DS8000 and DS6000, in addition to the support for ESS model 800 and SVC. This support focuses on automating administration and configuration of these services, operational control (starting, suspending, resuming) copy services tasks and monitoring and managing the copy services sessions. In addition to the support for FlashCopy and Metro Mirror, TotalStorage Productivity Center for Replication V3R1 supports Global Mirror on the ESS800, DS8000, and DS6000 hardware platforms. Advanced disaster recovery functions are also supported with failover/failback (planned and unplanned) from a primary site to a disaster recovery site. TotalStorage Productivity Center for Replication also can monitor the performance of the copy services that provide a measurement of the amount of replication and the amount of time that is required to complete the replication operations. This IBM Redbooks publication provides the information you need to install TotalStorage Productivity Center for Replication and create and manage replication sessions on Linux. Scenarios are provided that document our work in the laboratory setting, using the GUI and CLI.

IBM TotalStorage Productivity Center for Replication Version 3, Release 1 brings support for the advanced copy services capabilities on the DS8000 and DS6000, in addition to the support for ESS model 800 and SVC. This support focuses on automating administration and configuration of these services, operational control (starting, suspending, resuming) copy services tasks and monitoring and managing the copy services sessions. In addition to the support for FlashCopy and Metro Mirror, TotalStorage Productivity Center for Replication V3R1 supports Global Mirror on the ESS800, DS8000, and DS6000 hardware platforms. Advanced disaster recovery functions are also supported with failover/failback (planned and unplanned) from a primary site to a disaster recovery site. TotalStorage Productivity Center for Replication also can monitor the performance of the copy services that provide a measurement of the amount of replication and the amount of time that is required to complete the replication operations. This IBM Redbooks publication provides the information you need to install TotalStorage Productivity Center for Replication, and create and manage replication sessions on a Windows 2003 platform. Scenarios are provided that document the work performed in our laboratory setting, using the GUI and CLI.

This book will help you get the best from your Linux NFS clients when used in an environment that includes IBM System Storage N series products. It begins with a general discussion of Linux distributions and kernels, and includes a comparison of some of the features of the 2.4 and 2.6 kernels. A detailed discussion of mount options and network protocols is presented to guide you through configuration tasks. Procedures for tuning your Linux clients and steps to diagnose performance and reliability problems are presented, along with information about additional resources you can consult if necessary. Finally, steps for configuring and using utilities that support advanced NSF features are provided.

IBM Commerce Module for OmniFind Discovery Edition integrates IBM OmniFind Discovery Edition with IBM WebSphere Commerce. The integration helps online retail and catalog companies convert shoppers into buyers by making it easier for people to find the right products and services that match their specific requirements from the Web. This IBM Redbooks publication provides an introduction to customizing the Commerce Module for OmniFind Discovery Edition using OmniFind Discovery Edition APIs. We introduce some of the basic APIs and show examples of using them to run simple searches, refine search results, and navigate within the search results. Using a sample start store as the case study, we explain how to use the APIs to add or modify existing menus and navigation options and change the appearance and behavior of the existing sample store Web site. We show you how to work with OmniFind Discovery Edition search engine and pass multiple constraints to narrow searches for the online store. This book is intended to be used by system integrators and solution developers who will be working with the Commerce Module for OmniFind Discovery Edition and performing customization for the online stores powered by OmniFind Discovery Edition. Information center for OmniFind Discovery Edition Version 8.4: Primary product support resource for OmniFind Discovery Edition:

This IBM Redbooks publication documents the procedures for implementing IBM OmniFind Enterprise Edition Version 8.4 technology in a single-server Windows environment, two-server Linux environment, and a four-server AIX environment. Supported data sources include DB2, Windows file system, DB2 Content Manager, Lotus Domino, Lotus Quickplace, WebSphere Portal Server, Web Content Management (WCM), and Portal Document Manager (PDM). Tivoli Directory Server (TDS) is the LDAP repository used in the scenarios. It is aimed at IT architects and search administrators who are responsible for managing IBM OmniFind Enterprise Edition on Windows 2003, Red Hat Enterprise Linux, and AIX platforms. The book offers a step-by-step approach to implementing a single-server, two-server, and four-server IBM OmniFind Enterprise Edition environment using typical customer scenarios. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides an introduction to custom reporting, a feature in Operations Manager. The book describes in detail the commands used to implement and manage custom reports, examples of reports, and reference information for the creation of custom reports within the Operations Manager environment. In any IT environment today there is a frequent and heavy need for reporting capability. These reports may be for managers or for administrative documentation. As the number of reports increases, so does the complexity of the reporting process. For some time Operations Manager has provided an extensive library of standard reports giving administrators the information they need. However, since no two IT organizations are alike, there are always different reporting needs. An organization may require a report that must have data that in the Operations Manager environment is on multiple reports. Rather than submit multiple reports, it would be more efficient to create a report that has just the data objects desired. the custom reporting feature of Operations Manager 3.4.1 provides such functionality. This functionality is discussed further in this book.

This IBM Redbooks publication describes best practice guidelines for running Oracle databases on IBM System Storage N series products with system platforms such as Solaris, HP/UX, AIX, Linux, and Microsoft Windows. It provides tips and recommendations on how to best configure Oracle and the N series products for optimum operation. The book presents an introductory view of the current N series models and features. It also explains basic network setup. For those who are unfamiliar with the N series portfolio of products, this book also provides an introduction to aggregates, volumes, and setup. This document reflects work done by NetApp and Oracle, as well as by NetApp engineers at various joint customer sites. It is intended for storage administrators, database administrators, business partners, IBM personnel, or anyone who intends to use Oracle with the N series portfolio of products. It contains the bare minimum requirements for deployment of Oracle on the N series products. Therefore, you should use this document as a starting point for reference.

In today’s highly competitive business environment, companies want to extract business advantage from every technology in the enterprise. Many are looking to IP Telephony as a way to lower costs, simplify network management, and use existing systems and resources, while more tightly integrating business applications and customer communication with their voice and data networks. With IBM System i IP Telephony, you can get the business benefits and simplicity you seek from both your telephony and IT environments with one integrated, secure, and reliable solution delivered by two industry leaders, 3Com and IBM. System i IP Telephony delivers the proven solutions of 3Com, a leading supplier of secure, converged voice and data networking, on the IBM System i platform. This IBM Redbooks publication is intended for system administrators and field technicians. It will help them to understand and prepare their system for deploying a System i IP Telephony solution. It introduces the System i IP Telephony environment and the specific benefits of 3Com IP Telephony on the System i platform. It shows how to prepare your system using either direct or virtual resources, as well as how to maintain the IP Telephony environment on the System i platform. It includes information on how to set up the network environment to support IP Telephony, and guides you through all the steps required to set up and install the IP Telephony solution, leaving you ready for your IBM IP Telephony-approved business partner or 3Com installation team to configure your IP Telephony system for use in your enterprise.

This IBM Redbooks publication provides best practices for deploying IBM System Storage N series storage systems, in support of mySAP Business Suite solutions that run in UNIX and NFS environments that use a DB2 database. We address common storage infrastructure design, operation, and management challenges that are faced by businesses and IT personnel, deploying the latest generation of SAP solutions.

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 IBM Redbooks publication helps you to understand the basics of identifying and tuning the performance of Structured Query Language (SQL) statements using IBM DB2 for i5/OS . DB2 for i5/OS 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. In V5R4 of i5/OS iSeries Navigator provides a series of new tools to do SQL Performance analysis that we cover in this book. Among the new tools that we will covering are:

This IBM Redbooks publication provides a getting started level of information about supporting the IBM Virtualization Engine TS7510 under i5/OS, primarily using the Backup Recovery and Media Services (BRMS), 5722-BR1, management product. BRMS is the primary backup and recovery management product for i5/OS. This book cannot make you an expert in i5/OS backup and recovery or in the use of BRMS. It also cannot make you an expert in full usage and management of the IBM Virtualization Engine TS7510 capabilities. More complete coverage of the TS7510 is included in the book IBM Virtualization Engine TS7510: Tape Virtualization for Open Systems Servers, SG24-7189. However, this book does provide sufficient information and examples to get you up and running with the IBM Virtualization Engine TS7510 attached to an i5/OS partition or system using BRMS. This book also helps you to understand where the IBM Virtualization Engine TS7510 can fit into your complete set of backup and recovery processes where multiple systems or servers, or logical partitions have to save data to a common repository. The TS7510 helps you to minimize your backup window, facilitates data sharing among the multiple systems, and helps you to minimize your total cost of ownership (TCO) in the backup and recovery area.

Systems Solution for Branch Banking is targeted to the financial institutions that have chosen to keep a decentralized infrastructure. This is approximately 50% of the customer base. This solution is a technology sell, and will therefore be most attractive to banks that are due for a technology refresh (that is, those that have not done a major upgrade of their branch infrastructure for the past 5 to 10 years). This IBM Redbooks publication discusses how to install and configure the components of the Systems Solution for Branch Banking, a hardware and software solution that enables banks to provide a common, easy-to-support IT infrastructure in their branch locations. The solution takes into consideration that the skills required to upgrade or maintain the infrastructure in the branch do not exist, so we provide a remote management function. Although a common solution has been defined, each implementation may have its own unique variations, depending on the network, software, and hardware environments.

This IBM Redbooks publication presents an overview and descriptions of IBM System Storage Business Continuity Solutions for Backup / Restore, Rapid Data Recovery, and Continuous Availability. IT Business Continuity concepts are discussed; advice, tips, and a roadmap for selecting the optimum IT Business Continuity solution for your organization is provided. IBM System Storage products are described that can fulfill your IT Business Continuity solution design. This book is a summary of the detailed information contained in IBM TotalStorage Business Continuity Solutions Guide, SG24-6547 and IBM System Storage Business Continuity: Part 2 Solutions Guide, SG24-6548.

The IBM acquisition of Micromuse Inc. in 2006 marked a major milestone for IBM Tivoli software because it significantly strengthened the end-to-end IBM Service Management software portfolio. As new technologies emerge, the ability to manage networks and provide very high network availability has become increasingly important for most organizations. Please note that the additional material referenced in the text is not available from IBM.

The convergence of Internet Protocol (IP) networks is enabling seamless communications that combine data, voice, video and other information streams. The true value of converged IP network however is realized through the converged applications that leverage the network. The key enabler to developing converged applications is the platform for designing, developing, testing, and deploying applications that integrate and compose services. This IBM Redbooks publication introduces IBM tools for creating converged Session Initiation Protocol (SIP) and IP Multimedia Subsystem (IMS) applications. It provides programming guidelines and working examples that demonstrate how to use the different development tools. It also provides hints and tips that enable you to quickly get up to speed developing converged applications. The portfolio of products include the IBM WebSphere Application Server Network Deployment, IBM WebSphere IP Multimedia Subsystem Connector, IBM WebSphere Presence Server, IBM WebSphere Telecom Web Services Server, and IBM WebSphere Integration Developer. This book is aimed at the diverse set of professionals that design and develop SIP and IMS applications. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Provisioning Manager, built on a Service Oriented Architecture, enhances usability for executing changes while keeping server and desktop software compliant. It helps organizations with provisioning, configuration and maintenance of servers and virtual servers, operating systems, middleware, applications, storage and network devices acting as routers, switches, firewalls, and load balancers. This IBM Redbooks publication is a study guide for IBM Tivoli Provisioning Manager V5.1 for people who want to get an IBM Professional Certification for this product. The IBM Tivoli Provisioning Manager V5.1 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 Provisioning Manager V5.1 product.This book provides a combination of theory and practical experience needed for a general understanding of the subject matter and sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions in the exam. The chapters are based on the sections of the Tivoli Provisioning Manager V5.1 Implementation Certification test. Studying each chapter will help you prepare for one section of the exam.

Since the enormous number of features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks. Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. You'll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You'll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

Arm yourself with the knowledge and tools to help you sell IBM® solutions and enable IBM clients to become innovative businesses enabled by on demand. This IBM Redbooks publication serves as a practical reference for those who desire to understand the IBM innovation enabled by on demand and how to sell the IBM innovative technology. It provides the perfect starting point for those who want to integrate on demand business concepts into their selling practice. It also serves as a guide for anyone preparing to take the IBM Certified for On Demand Business Solutions Advisor V2 Exam via Test 818. After reading this publication, your knowledge will expand in the following capacities: