This IBM® Redbooks® publication is a study guide for IBM Maximo® Asset Management V7.1 and is aimed at individuals who want to get an IBM Professional Certification for this product. The IBM Maximo Asset Management V7.1 certification exam, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation and configuration of the IBM Maximo Asset Management V7.1 product. This publication does not replace practical experience, and is not designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with educational activities and experience, can be an extremely useful preparation guide for the exam. For your convenience, we structure the chapters based on the sections of the Test 000-015: IBM Maximo Asset Management V7.1 Implementation, such as Assets, Inventory, and so on, so studying each chapter will help you prepare for one section of the exam. Note that Test 000-017: Foundations of Tivoli Process Automation Engine is a prerequisite for the IBM Certified Deployment Professional - Maximo Asset Management V7.1 certification. To prepare for that test, refer to the IBM Redbooks publication Certification Study Guide Series: Foundations of Tivoli Process Automation Engine, SG24-7763.

This IBM® Redbooks® publication is a study guide for Test 000-017: Foundations of Tivoli Process Automation Engine and is aimed at individuals who want to get an IBM Professional Certification on Tivoli Process Automation Engine.

The Practical, Complete Guide to Leveraging the Power of Social Networks with Lotus Connections 2.0 IBM ® Lotus ® Connections 2.0 gives businesses all the tools they need to make the most of social networking—easily, securely, and cost-effectively. Now, a team of IBM Lotus Connections experts thoroughly introduce this breakthrough product and covers every facet of planning, deploying, and using it successfully. IBM Lotus Connections 2.0 covers both business and technical issues and presents proven best practices for every step of the implementation process. The authors first help you identify your best opportunities to use social networking for competitive advantage and demonstrate how Lotus Connections 2.0 places state-of-the-art social networking tools at your fingertips. Next, they carefully describe each component of the product, including profiles, activities, blogs, communities, “dog-ear” bookmarking, personal home pages, and more. They present practical coverage of administering Lotus Connections as well as detailed guidance on extending and integrating it. Whether you’re an executive, IT manager, or technical professional, this eBook has all the information you need to put social networking to work—and deliver powerful, quantifiable results. Coverage includes Assessing the potential value of social networking to your business Building dynamic networks of coworkers, partners, and customers that promote innovation and business agility Understanding the core services Lotus Connections 2.0 provides and the unique way in which they integrate Leveraging Lotus Connections’ consistent multitiered architecture Successfully planning for technical infrastructure and organizational change Walking through a best-practice installation and configuration process Building effective communities for employees with shared interests Using blogs to improve communications and overcome organizational silos or time zone differences Helping individuals and groups organize their work through Activities Performing administrative tasks such as customizing look-and-feel, collecting statistics, and troubleshooting Using plug-ins to integrate with Lotus Notes ®, Microsoft ® Office ®, Outlook ®, Windows ® Explorer, Lotus Sametime ®, and WebSphere ® Portal Displaying useful, up-to-the-minute information with prebuilt widgets Utilizing Lotus Connections’ REST-based API to create new integration points and build custom applications

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and cursors Work with new objects introduced with the latest SQL standards Get practical, expert tips on implementing SQL in your business environment Learn on your own time, at your own pace No previous SQL or database experience required Learn techniques that work with any current version of SQL Discover how to write faster, more efficient queries Secure your data using best practices from experienced database administrators Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL Write queries for the free, open source MySQL database Embed your SQL code in other applications Ryan Stephens and Ron Plew are President and VP of Perpetual Technologies, Inc. (PTI) in Indianapolis, IN, providing managed services and consulting for top database implementations running Oracle, SQL Server, and other leading technologies. They taught for 5+ years as adjunct professors at Indiana University-Purdue University. Their books include Sams Teach Yourself SQL in 24 Hours, First through Fourth Editions, Sams Teach Yourself SQL in 21 Days, Second through Fourth Editions, and Database Design. Table of Contents Introduction 1 PART I: Introducing SQL LESSON 1: Getting Started with SQL 5 A Brief History of SQL 5 A Brief History of Databases 6 Today’s Database Landscape 11 A Cross-Product Language 12 Early Implementations 12 SQL and Client/Server Application Development 13 An Overview of SQL 13 Popular SQL Implementations 14 MySQL 14 Oracle 14 Microsoft SQL Server and Sybase 15 IBM DB2 16 Open Database Connectivity 16 Embedding SQL in Application Programming 17 LESSON 2: Introducing the Query 21 Exploring SQL’s Background 21 Learning Basic Query Syntax 22 The Building Blocks of Data Retrieval: SELECT and FROM 23 Applying Query Concepts 25 Writing Your First Query 26 Terminating a SQL Statement 28 Selecting Individual Columns 28 Changing the Order of the Columns 29 Selecting Different Tables 31 Selecting Distinct Values 31 Exercises 37 LESSON 3: Expressions, Conditions, and Operators 39 Working with Query Expressions 40 Placing Conditions on Queries 40 Learning How to Use Operators 42 Arithmetic Operators 42 Comparison Operators 55 Character Operators 63 Logical Operators 70 Set Operators 75 Miscellaneous Operators: IN and BETWEEN 78 LESSON 4: Clauses in SQL Queries 85 Specifying Criteria with the WHERE Clause 87 Order from Chaos: The ORDER BY Clause 89 The GROUP BY Clause 98 The HAVING Clause 105 Combining Clauses 112 Example 4.1 112 Example 4.2 113 Example 4.3 113 Example 4.4 115 LESSON 5: Joining Tables 121 Joining Multiple Tables in a Single SELECT Statement 121 Cross Joining Tables &

Live Partition Mobility is the next step in the IBMs Power Systems™ virtualization continuum. It can be combined with other virtualization technologies, such as logical partitions, Live Workload Partitions, and the SAN Volume Controller, to provide a fully virtualized computing platform that offers the degree of system and infrastructure flexibility required by today's production data centers. This IBM® Redbooks® publication discusses how Live Partition Mobility can help technical professionals, enterprise architects, and system administrators: * Migrate entire running AIX® and Linux® partitions and hosted applications from one physical server to another without disrupting services and loads. * Meet stringent service-level agreements. * Rebalance loads across systems quickly, with support for multiple concurrent migrations. * Use a migration wizard for single partition migrations. This book can help you understand, plan, prepare, and perform partition migration on IBM Power Systems POWER6™ technology-based servers that are running AIX.

This IBM® Redbooks® publication discusses IBM Tivoli® Netcool® Service Quality Manager V4.1.1 data mediation development. It is aimed at implementers and system integrators connecting new data sources that will be managed by Service Quality Manager. Data mediation in Service Quality Manager is performed by Perl gateways. Gateways extract data from vendor specific hardware monitors and prepare the data to be loaded into the Service Quality Manager application. The development aspect of data mediation for gateways uses Perl extensively. The control files or rules are written as Perl subroutines. We discuss the detailed specifications and processing of these mediation rules.

Workload partition functionality, originally introduced in 2007 with the release of IBM AIX Version 6, is a strategic component of the IBM AIX Operating System. With the release of AIX V6.1 TL2 in November 2008, both the core functionality and features related to managing workload partitions have been improved and expanded. This IBM Redbooks publication provides an updated introduction and “how to” guide for system administrators and architects using workload partitions in AIX V6.1 TL2. It builds on the original concepts and practices described in the first Redbooks publication about this topic, Introduction to Workload Partition Management in IBM AIX Version 6.1, SG24-7431 , published in 2007. In AIX 6.2 TL2, significant enhancements to core workload partition functions and new features have been added. Some of the important feature updates provide more flexibility and support for enhanced mobility, improved isolation, and NIM integration. A new and significantly updated version of IBM Workload Partitions Manager for AIX (WPAR Manager), the Web browser-based graphical user interface for managing and monitoring WPARs, is also available. WPAR Manager is a platform management solution that provides a centralized point of control for managing WPARs across a collection of managed systems running AIX.

Deploying an identity management solution for a medium size business begins with a thorough analysis of the existing business and IT environment. After we fully understand the organization, their deployed infrastructure, and the application framework, we can define an applicable representation of these assets within an identity management implementation. This IBM® Redbooks® publication, intended for IBM Business Partners, takes a step-by-step approach to implementing an identity management solution based on IBM Tivoli® Identity Manager. Part 1 discusses the general business context and the planning approach for an identity management solution. Part 2 takes you through an example company profile with existing business policies and guidelines and builds an identity management solution design for this particular environment. We describe how the components can be integrated into the existing environment. Then, we focus on the detailed configuration of identity management integration tasks that must be implemented in order to create a fully functional end-to-end solution. This IBM Redbooks publication does not introduce any general identity management concepts, nor does it systematically explain all of Tivoli Identity Manager's components and capabilities; instead, those details are thoroughly discussed in the IBM Redbooks publications: Identity Management Design Guide with IBM Tivoli Identity Manager, SG24-6996, and Enterprise Security Architecture Using IBM Tivoli Security Solutions, SG24-6014.

How to Use Mentoring to Drive Maximum Competitive Advantage Techniques and lessons from IBM’s world-class mentoring programs—for every business and HR leader, strategist, Chief Learning Officer, consultant, trainer, and scholar “A crucial part of my job is to help develop and retain the more than 200,000 members of IBM’s global technical community. Over the years, I have found that the true spirit of any organization is its people, and unique, world-class mentoring programs play a crucial role in their success. What I really like about Intelligent Mentoring is that it is not an academic treatise on the theory of mentoring, but a series of practical solutions that can be used by virtually any organization to gain productivity, increase retention, and improve bottom-line results.” — Nick Donofrio, Executive Vice President, Innovation and Technology, IBM Corporation “We have known about the importance of mentoring in developing people for decades. Yet few organizations have successfully leveraged it as part of their HR strategy. IBM is one of those companies. Intelligent Mentoring is about more than the mentoring initiative successfully implemented at IBM. It is a guide for how companies can leverage mentoring in a way that aligns with company strategy and supports organizational and individual development. It is a must-read for any executive considering a mentoring initiative as part of the firm’s HR strategy. IBM’s mentoring effort combined the best of what we know from mentoring research, career development theory, and change management to create a highly successful effort. There is much here for practitioners and scholars to learn.” — David A. Thomas, Ph.D., Naylor Fitzhugh Professor of Business Administration, Harvard Business School “Performance is the ultimate driver of this company. Even back in our earliest days, one of the keys to IBM’s greatness was performance, along with top-notch technology. Since arriving at IBM in 2000, my goal has been to identify, develop, train, reward, and retain high-performing people, and one of the best ways to support these high performers is through mentoring. I believe that Intelligent Mentoring has done a phenomenal job of capturing the innovative and varied mentoring initiatives that IBM has used over the years. The authors really take you inside the company and show how mentoring has helped IBM preserve its corporate culture by passing on knowledge, not only between generations, but in all directions throughout our global community. This book is a must-read for anyone who wants to use the powerful tool of mentoring to its best and most productive advantage, and I recommend it highly.” — Randy MacDonald, Senior Vice President, Human Resources, IBM Corporation For today’s enterprises, few challenges are as daunting as preparing tomorrow’s leaders. Mentoring is one of the most powerful tools at their disposal. But not all mentoring programs are equally effective, and not all companies have learned how to sustain mentoring. One company has: IBM. Intelligent Mentoring reveals how IBM has done it–and offers specific guidance and best practices you can use to achieve equally powerful results. Intelligent Mentoring shows how IBM has fully integrated a diverse portfolio of formal mentoring initiatives into both talent development and innovation promotion. Whether you’re a business leader, strategist, Chief Learning Officer, training specialist, coach, or consultant, this book presents a state-of-the-art framework for making mentoring work. Drawing on IBM’s experience, the authors demonstrate how to build a diverse portfolio of effective mentoring programs...use mentoring to strengthen organizational intelligence...build sustainable communities of mentors and mentees...promote collaboration across differences... and above all, link mentoring to strategy and use it to sustain competitive advantage. • Use mentoring to develop tomorrow’s world-class business leaders Actionable solutions and best practices from IBM’s breakthrough mentoring program • Embrace mentoring as a high-performance work practice Maximizing, capturing, and communicating the value-added impact of mentoring • Set the right goals for mentoring: then achieve them Utilize mentoring to strengthen organizational learning, improve retention, promote innovation, and more • Use mentoring to solve your organization’s most “wicked” problems How mentoring can help you respond to complex, tangled challenges you’ve never faced before

Choice is usually a good thing for consumers but it can be difficult to navigate the landscape of Open Source ESBs. I believe this book is extremely valuable for readers looking to choose an ESB and looking to get a stronger grasp on how to implement an ESB using open source projects. I found the case studies in section III particularly useful since they pull together many of the concepts learned throughout the book. This book guides the reader through a logical journey of discovery and demonstration to deliver a solid understanding of the core ESB concepts and how they can be used in the real world. Armed with this book and the wealth of open source projects available I think the reader will be ready to take on any ESB project. Open Source made ESBs a lot more fun, go and enjoy yourself! —From the Foreword by Ross Mason, Creator of the Mule Project Open-Source ESBs in Action describes how to use ESBs in real-world situations. You will learn how the various features of an ESB such as transformation, routing, security, connectivity, and more can be implemented on the example of two open-source ESB implementations: Mule and ServiceMix. The authors first introduce ServiceMix and Mule, and then present general principles and patterns of ESB use, as well as a structured approach to solving common integration problems, through examples using them. About the Technology The need for enterprise integration is widespread for the simple reason that businesses require independent applications to exchange information with each other. A CRM application must know about the order history of a customer, but that history is stored in the sales application. A technology that companies increasingly use to integrate enterprise applications is the Enterprise Service Bus (ESB). About the Book Working in integration projects is exciting, with new technologies and paradigms arriving every day. In this area, open source is playing a more and more dominant role with projects such as Mule and ServiceMix. Open-Source ESBs in Action will help you to learn open-source integration technologies quickly and will provide you with knowledge that you can use to effectively work with Mule and ServiceMix. What's Inside Numerous code examples Detailed explanation on how to use Mule and ServiceMix Practical, real-world examples and case studies Integration with a full open source tool stack About the Reader About the Authors Tijs Rademakers is a software architect with more than six years of experience in designing and developing Java and EE applications. He works for Atos Origin, a large European system integrator, where he is responsible for SOA and BPM services and knowledge development. Tijs has designed and implemented large process- and application-integration solutions, primarily focused on open standards. He has extensive product knowledge of open source as well as closed source SOA and enterprise integration tools, including Mule, ServiceMix, jBPM, and WebSphere Process Server. Tijs is a regular speaker at Java conferences, where he talks about open source integration topics like Mule and ServiceMix. Tijs lives in the Netherlands near Eindhoven with his girlfriend and his new daughter, Liv. Jos Dirksen has been working with Java and J2EE applications for more than six years as a software architect. The last couple of years, his focus topics have been open source, security, and quality. He has worked with various open source and commercial integration solutions, mostly in the government and the healthcare areas. Jos has a lot of project experience working with Mule, Apache Synapse, and Apache Axis2 and has also completed projects based on the integration tooling from IBM. Jos regularly gives presentation on open source, Mule, and other related topics. He lives in Eindhoven, the Netherlands, with his wife. Quotes A great book for any ESB practitioner. - Rick Wagner, Acxiom Corporation A must-have ESB resource! - Craig Borysowich, Imagination Edge, Inc. The most comprehensive content that I've seen on open source ESBs. - Rodney Biresch, Chariot Solutions The Bible for integration architects. - Davide Piazza, Omnys s.r.l. ...ample code samples and excellent descriptions. - Jeff Davis, HireRight, Inc. This book will take you to a new level. - Christian Siegers, Stater International Mortgage Services

IBM's DB2 Express Edition is one of the most capable of the free database platforms available in today's marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you'll find: A friendly introduction to DB2 Express Edition, an industrial-strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.

IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes. IBM InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components. This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.

The Only Authorized Guide to IBM Cognos 8 Business Intelligence Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users. Measure and monitor performance using dashboards and scorecards Assign user roles and privileges Provide complete and consistent access to a broad range of data sources via Cognos Connection Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines Enable business users to create reports with Query Studio Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio Build Dimensional Reports with Report Studio Use Event Studio to identify and deliver mission-critical information Create, modify, organize, and publish a model from Cognos Framework Manager Implement sound security measures Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

This IBM® Redbooks® publication provides details of changes, updates, and new functions in IBM Tivoli® Storage Manager Version 5.4, and Version 5.5. We cover all the new functions of Tivoli Storage Manager that have become available since the publication of IBM Tivoli Storage Manager Version 5.3 Technical Guide, SG24-6638. This book is for customers, consultants, IBM Business Partners, 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.4 and Version 5.5. Hence, since we target an experienced audience, we use certain shortcuts to commands and concepts of Tivoli Storage Manager. If you want to learn more about Tivoli Storage Manager functionality, see IBM Tivoli Storage Management Concepts, SG24-4877, and IBM Tivoli Storage Manager Implementation Guide, SG24-5416. This publication should be used in conjunction with the manuals and readme files provided with the products and is not intended to replace any information contained therein.

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

This IBM® Redbook captures some of the best practices based on field experience and details the performance gains that can be achieved by implementing the IBM System Storage™ SAN Volume Controller. This book is intended for very experienced storage, SAN, and SVC administrators and technicians. Readers are expected to have an advanced knowledge of the SVC and SAN environment, and we recommend these books as background reading: IBM System Storage SAN Volume Controller, SG24-6423 Introduction to Storage Area Networks, SG24-5470 Using the SVC for Business Continuity, SG24-7371

In order to comply with government and industry regulations, such as Sarbanes-Oxley, Gramm-Leach-Bliley, and COBIT, enterprises have to constantly detect, validate, and report unauthorized change and out-of-compliance actions on their IT infrastructure. The Tivoli Compliance Insight Manager solution allows organizations to improve the security of their information systems by capturing comprehensive log data, correlating this data through sophisticated log interpretation and normalization, and communicating results through a dashboard and a full set of audit and compliance reporting. We discuss the business context of security audit and compliance software for organizations, and we show a typical deployment within a business scenario. This IBM Redbooks publication is a valuable resource for security officers, administrators, and architects who wish to understand and deploy a centralized security audit and compliance solution.

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.

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.