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:

This IBM Redbooks publication is a study guide for IBM TotalStorage Productivity Center for Data Version 3.1, and it is targeted for professionals who want to get an IBM Certification in this specific product. This 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 TotalStorage Productivity Center for Data Version 3.1 product. This book provides a combination of theory and practical experiences necessary for a general understanding of the subject matter. 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 book does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a useful preparation guide for the exam.

This IBM Redbooks publication provides an overview of IBM Tivoli System Automation for z/OS concepts and new features. We also discuss some considerations on migrating non-IBM products to IBM Tivoli System Automation for z/OS. The discussion is primarily aimed at technical professionals that are looking to understand the IBM Tivoli System Automation for z/OS new features and find migration options. This book explains some important features of IBM Tivoli System Automation for z/OS, including using the Processor Operations feature, integration with IBM Tivoli OMEGAMON Classic, and integration with End-to-end automation feature of the IBM System Automation for Multiplatform. We will also discuss the available services from the Software Migration Project Office that provide migration services for mainframe based products, including IBM Tivoli System Automation for z/OS, in this new implementation of IBM Tivoli System Automation for z/OS. We also provide some overview of the migration procedures from non-IBM products.

This IBM Redbooks publication describes the steps carried out to configure and install an IBM DB2 database in a N series storage system UNIX environment. It particularly elaborates the configuration steps for the UNIX host as well as the IBM N series storage system. The UNIX host types covered in this book are Linux, IBM AIX, Sun Solaris, and HP-UX.

Backing up SAP software environments is increasingly challenging in today’s 24x7 enterprises. Even more challenging is restoring these environments. Applications and databases grow ever larger, putting increasing strain on the management infrastructure. Using hardware-assisted copy mechanisms to perform fast backups and restores is one way to address these issues. Tivoli Storage Manager, along with associated products, allows you to leverage FlashCopy to perform fast backups, almost “instant” restores, as well as database cloning for testing and other purposes. These applications are fully integrated with SAP software in DB2 UDB and Oracle environments, providing reliable, intelligent techniques for data protection. This IBM Redbooks publication will help you plan, configure, and run IBM Tivoli Storage Manager for Advanced Copy Services and associated applications in your SAP software environments.

This IBM Redbooks publication will help you plan, install, and configure the IBM System Storage DS6000 Copy Services functions in System z environments, and provides the details you need to implement and manage these functions. The book includes hints and tips.

This IBM Redbooks publication provides IMS performance monitoring and tuning information. This book differs from previous IMS performance and tuning IBM Redbooks in that there is less emphasis on the internal workings of IMS and more information about why and how certain options can affect the performance of IMS. You should be able to find valuable new information and perhaps validate things you might have questioned. Hardware and software characteristics are constantly changing, but hopefully the information that you find here provides a basis to help you react to change and to keep your IMS running efficiently. In this book, we introduce methods and tools for monitoring and tuning IMS systems, and in addition to IMS TM and DB system-wide performance considerations, we dedicate separate chapters for application considerations, IMS and DB2 interoperability, the Parallel Sysplex environment, and On Demand considerations.

This IBM Redbooks publication provides an overview of the Informix Dynamic Server (IDS), Version 10. IDS provides the reliability, flexibility, and ease of maintenance that can enable you to adapt to new customer requirements. It is well known for its blazing online transaction processing (OLTP) performance, legendary reliability, and nearly hands-free administration for businesses of all sizes--all while simplifying and automating enterprise database deployment. Version 10 offers significant improvements in performance, availability, security, and manageability, including patent-pending technology that virtually eliminates downtime and automates many of the tasks that are associated with deploying mission-critical enterprise systems. New features speed application development, enable more robust enterprise data replication, and enable improved programmer productivity through support of IBM Rational development tools, JDBC 3.0, and Microsoft .NET as examples. Version 10 provides a robust foundation for e-business infrastructures with optimized Java support, IBM WebSphere certification, and XML and Web services support. Ready for service-oriented architecture (SOA)? This book also includes descriptions and demonstrations of support that are specific to IDS for an SOA.