This book is part of the Deployment Guide series. It provides a step-by-step guide for deploying Tivoli Usage and Accounting Manager V7.1. It is intended to help an IBM or business partner service person to plan and perform the deployment of the product. Please note that the additional material referenced in the text is not available from IBM.

This IBM® Redbooks® publication follows The IBM System Storage Tape Libraries Guide for Open Systems, SG24-5946, and can help you plan, install, and configure IBM Ultrium LTO tape drives, as well as the TS1120 Tape Drive and libraries in i5/OS® environments. The book focuses on the setup and customization of these drives and libraries. The first part of the book gives an overview of the System i™ family of servers and describes how to attach and configure the drives and libraries. It also covers basic installation and administration. We describe the sharing and partitioning of libraries and explain the concept and usage of the Advanced Library Management System (ALMS). In the second part of the book, we document how to use these products with Backup Recovery and Media Services (BRMS), how to implement Tape Encryption, and how to use the IBM TS7520 Virtualization Engine™ with i5/OS. This book can help IBM personnel, Business Partners, and customers to better understand and implement the IBM Ultrium LTO product line, and also the TS1120 Tape Drive attached to System i servers. We assume that the reader is familiar with tape drives and libraries and has a basic understanding of System i servers and i5/OS.

Your Hands-On Guide to SAP Business Information Warehouse Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance. Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks Work with the BEx Analyzer, Web Analyzer, and Query Designer Build queries and reports using the Business Administration Workbench Add attachments and drill-through using Document Integration and RRI Format and distribute results using Report Designer and Information Broadcaster Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer Deploy charts, maps, diagrams, and unit of measure conversions Predict trends and possible outcomes using SBC and Integrated Planning Generate HTML pages using Enterprise Reporting and Web Application Designer Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

IBM Tivoli Monitoring Version 6.2 is a powerful monitoring product from IBM, that is easily customizable and provides real-time and historical data that enables you to quickly diagnose and solve issues through the IBM Tivoli Enterprise Portal component. This common, flexible, and easy-to-use browser interface helps users to quickly isolate and resolve potential performance problems. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Monitoring V6.2. We cover planning, installing, and configuration of IBM Tivoli Monitoring V6.2 for small, medium, and large environments. In addition, we provide some case studies, such as IBM Tivoli Monitoring V5.x migration, event management integration, and Agent Builder. Agent Builder is a very powerful tool that you can use to develop your own monitoring agents. In order to show you how this tool can be used in a real life scenario, we have created a 30 minute video that you can launch from the ITSO Web site. We have also added an appendix that discusses IBM Tivoli Monitoring sales engagement planning for Business Partners and Solution Developers. The target audience for this documentation is IT Specialists and Business Partners who will be working on IBM Tivoli Monitoring V6.2 implementations and proof of concepts. Please note that the additional material referenced in the text is not available from IBM.

In this IBM® Redbooks® publication, we describe the capabilities and ways to use the IBM Tivoli® Application Dependency Discovery Manager (TADDM). It is becoming critical for enterprises to track the IT resources in their environment and, more importantly, the dependencies of their business applications on various components. TADDM provides rich capabilities that discover the components of a complex infrastructure and their interdependencies. In this book, we provide insight into the TADDM capabilities and architecture. We include recommended procedures for installing and configuring TADDM, tips and techniques for populating the TADDM database and customizing its use, performance considerations, and information about how TADDM integrates with operational management programs.

The IBM Tivoli Monitoring solution is the next generation of the IBM Tivoli family of products that help monitor and manage critical hardware and software in distributed environments. This IBM Redbooks publication provides a practical guide to implementing, using and optimizing IBM Tivoli Monitoring, including best practices for performance tuning, sizing, high availability, scalability, reporting, IBM Change and Configuration Management Database integration and firewall considerations.

In order to improve the performance and operational efficiency of businesses worldwide, a customer using SAP® wanted to establish a global business program to define and implement a standardized, group-wide business process architecture and associated master data for the parameterization of the group of software tools. The expected growth of the number of users and the size of the database would be at a level never reached by other customers, however, so IBM® was asked to undertake the following tasks: * Test the application to be sure that it can sustain such growth. This project illustrates the new near real time business intelligence (BI) context approached by customers who want the ability to rapidly analyze their business data to gain market shares. Data today comes from many diverse global sources and needs to be merged into an intelligent data warehouse. This IBM Redbooks® publication describes the testing that was done in terms of performance and manageability in an SAP NetWeaver® BI and DB2® environment on IBM System p™ when scaling a client's solution to a data warehouse of 60 terabytes (TB). This book resulted from a joint cooperative effort that included the PSSC, the IBM/SAP International Competency Center, the DB2-SAP Center of Excellence, SAP AG, and a customer. The customer involved in this project is a worldwide company employing more than 250,000 employees with factories and logistics operations in almost every country in the world. This project involved multiple technical skills and multiple products, as described here: * Chapter 1, "Project overview: business objectives, architecture, infrastructure, and results" on page 1, summarizes the entire project, starting from the business needs through the description of the environment and options used, to the results achieved. This chapter can be viewed as an executive summary from an IT specialist perspective. * Chapter 2, "The SAP NetWeaver BI perspective" on page 47; Chapter 3, "The DB2 perspective" on page 127; and Chapter 4, "The IBM System p perspective" on page 287, provide detailed views of the project from the perspectives of SAP specialists, DB2 specialists, and System p and AIX® specialists, respectively. * Chapter 5, "The system storage perspective" on page 319, and Chapter 6, "The Tivoli Storage Manager perspective" on page 349, describe the storage environment and the manageability issues in such a large environment. * Finally Appendix A, "The scripts used" on page 395, provides the scripts that we needed to develop for this project.

If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination! PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business. It’s easy to find what you need in this handy guide. You’ll discover how to: Find and acquire all the tools you need and set up your development environment Build PHP scripts to make your Web site work Create a MySQL database that visitors can access Summarize and sort data results Design and implement user access control Build a shopping cart application Create extensions that make your site more useful With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it!

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you'll then learn how to identify and remove the problems that are causing poor performance. You'll discover preventive measures you can take to try to avoid a performance problem entirely and you'll learn how to achieve better performance.

This IBM® Redbooks® publication describes the IBM Tivoli® Composite Application Manager (ITCAM) family of products. The Composite Application Manager family currently consists of: - IBM Tivoli Composite Application Manager for WebSphere® The aim of IBM Tivoli Composite Application Manager is to simplify and enhance distributed application management. Application components can reside on multiple servers, across different platforms and J2EE environments, even through mainframes. The complexity of understanding and solving application-related problems, typically around performance issues, requires a cohesive set of tools to provide an end-to-end view of the application. The discussion that we provide in this book mainly consists of the basic installation and configuration of the products. The discussion is aimed at augmenting the information provided in the product manuals. Consult the appropriate product manual before starting to implement these products. We provide usage scenarios in this book as a demonstration of using these products in our sample environment. We use a single application environment that can be managed by all of the products.

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you’ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you’ll be coding more quickly, writing more efficient code, and applying the full power of SQL Filled with the insights of one of the world’s leading SQL authorities - noted for his knowledge and his ability to teach what he knows Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance) Presents clear guidance for selecting and correctly applying the right table technique

This book is written as part of the deployment guide series. It provides a step-by-step guide for deploying IBM® Tivoli® Composite Application Manager (ITCAM) for Web Resources V6.2. This deployment guide will help an IBM Business Partner or service person plan and perform the deployment of the product. The discussion on ITCAM for Web Resources describes product architecture and components, planning and sizing considerations, and guidelines on setting up service engagements. Although the information is highly relevant for larger deployment engagements, it is also suitable for a small deployment system. The extensive deployment and usage scenarios can also help you demonstrate the product.

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11 g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

Tagging is fast becoming one of the primary ways people organize and manage digital information. Tagging complements traditional organizational tools like folders and search on users desktops as well as on the web. These developments mean that tagging has broad implications for information management, information architecture and interface design. And its reach extends beyond these technical domains to our culture at large. We can imagine, for example, the scrapbookers of the future curating their digital photos, emails, ticket stubs and other mementos with tags. This book explains the value of tagging, explores why people tag, how tagging works and when it can be used to improve the user experience. It exposes tagging's superficial simplicity to reveal interesting issues related to usability, information architecture, online community and collective intelligence.

Install and Configure Grid Control to Manage Your Oracle Landscape Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. You'll also get full coverage of backup and recovery strategies and high-availability techniques. Prepare infrastructure hosts for Grid Control rollout Install the Oracle management repository, service, and agents Select the Grid Control installation options that fit your needs Discover and manage host, database, and application server targets Set target metrics and policies according to best practices Optimize performance and availability of your Grid Control framework Secure the Grid Control framework to protect data transmitted between components

This IBM Redbooks publication provides an overview of the new functions and enhancements in IBM Information Management System (IMS) Version 10. IBM continues to enhance IMS integration, manageability, and scalability. IMS helps you with On Demand Business enablement, growth, availability, and systems management that current and newer environments and cost measures require. IMS Version 10 helps in addressing your On Demand Business needs through integration/openness, manageability, and scalability, providing: - Integration with other products and platforms across the Internet, supporting open standards that benefit you, and taking best advantage of the latest industry tooling for application development and connectivity - Scalability with virtualization in assuring flexibility for growth and expansion in a heterogeneous environment while utilizing the latest hardware and software facilities to optimize performance, capacity, availability, and recovery

Optimize Your Entire Requirements Process–and Use Requirements to Build More Successful Software Using IBM® Rational® RequisitePro®, you can systematically improve the way you create and maintain requirements–and use those requirements to build more effective, higher-quality software. Now, for the first time, there’s a comprehensive, hands-on guide to optimally using RequisitePro in real-world development environments. Utilizing a start-to-finish sample project, requirements expert Peter Zielczynski introduces an organized, best-practice approach to managing requirements and shows how to implement every step with RequisitePro. You’ll walk through planning, eliciting, and clarifying stakeholder requirements; building use cases and other key project documents; managing changing requirements; transforming requirements into designs; and much more. Every stage of the process is illuminated with examples, realistic artifacts, and practical solutions. This book is an invaluable resource for everyone who creates requirements, and everyone who relies on them: business analysts, systems analysts, project managers, architects, designers, developers, and testers alike. Coverage includes Overcoming the three leading causes of project failure: lack of user input, incomplete requirements and specifications, and poorly managed change Understanding each type of software requirement–how they interrelate, and what makes a good requirement Establishing a Requirements Management Plan that describes how requirements are created and handled throughout the project lifecycle Developing a Vision document that can drive your project from beginning to end Creating high-quality use cases Using requirements as the basis for system design Leveraging RequisitePro features for improved project management Integrating requirements management with the IBM Rational Unified Process® Foreword xvii Preface xix Acknowledgments xxiii About the Author xxv Part I: Overview 1 Chapter 1: Requirements Management 3 Chapter 2: Overview of RequisitePro 23 Part II: Requirements Management Activities 33 Chapter 3: Establishing a Requirements Management Plan 35 Chapter 4: Setting up the Project 45 Chapter 5: Requirements Elicitation 63 Chapter 6: Developing a Vision Document 99 Chapter 7: Creating Use Cases 129 Chapter 8: Supplementary Specification 157 Chapter 9: Creating Test Cases from Use Cases 191 Chapter 10: Creating Test Cases from Supplementary Requirements 221 Chapter 11: Object-Oriented Design 243 Chapter 12: Documentation 273 Part III: Other Topics 285 Chapter 13: Managing Projects 287 Chapter 14: Requirements Management in the Rational Unified Process 295 Part IV: Review 311 Chapter 15: Summary 313 Appendix: Sample Requirements Management Plan 319 Index 327

This IBM® Redbooks® publication builds upon the existing Linux for zSeriesLinux on zSeries: Fibre Channel Protocol Implementation Guide, SG24-6344, to produce a System z™ book that includes (among other things):

The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a new Visual Explain. DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert-based query and workload analysis, server enhancements, and an Index Advisory function. These functions are delivered with two tools: DB2 Optimization Service Center and DB2 Optimization Expert. This book helps you understand the installation, customization, and usage aspects of the tools. You are guided through scenarios of gradually increasing complexity where the functions of the tools are exploited for query optimization.