This IBM Redbooks publication is a study guide for the IBM TotalStorage Productivity Center for Data V2.1, and it is meant for those who want to achieve an IBM Certification for this specific product. The IBM TotalStorage Productivity Center for Data V2.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 TotalStorage Productivity Center for Data V2.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 publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a useful preparation guide for the exam.

All Access takes a “before they were stars” look at twenty-five giants in the graphic design industry by juxtaposing an edited selection of the stars’ greatest hits with their “pre-fame” work.

Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables—from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for. There's no fuss to this book, only clear and precise information to help you assess your situationwhether common or uniqueand solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.

This IBM Redbooks publication introduces Infrastructure Simplification. Infrastructure Simplification

Baseball Hacks isn't your typical baseball book--it's a book about how to watch, research, and understand baseball. It's an instruction manual for the free baseball databases. It's a cookbook for baseball research. Every part of this book is designed to teach baseball fans how to do something. In short, it's a how-to book--one that will increase your enjoyment and knowledge of the game. So much of the way baseball is played today hinges upon interpreting statistical data. Players are acquired based on their performance in statistical categories that ownership deems most important. Managers make in-game decisions based not on instincts, but on probability - how a particular batter might fare against left-handedpitching, for instance. The goal of this unique book is to show fans all the baseball-related stuff that they can do for free (or close to free). Just as open source projects have made great software freely available, collaborative projects such as Retrosheet and Baseball DataBank have made great data freely available. You can use these data sources to research your favorite players, win your fantasy league, or appreciate the game of baseball even more than you do now. Baseball Hacks shows how easy it is to get data, process it, and use it to truly understand baseball. The book lists a number of sources for current and historical baseball data, and explains how to load it into a database for analysis. It then introduces several powerful statistical tools for understanding data and forecasting results. For the uninitiated baseball fan, author Joseph Adler walks readers through the core statistical categories for hitters (batting average, on-base percentage, etc.), pitchers (earned run average, strikeout-to-walk ratio, etc.), and fielders (putouts, errors, etc.). He then extrapolates upon these numbers to examine more advanced data groups like career averages, team stats, season-by-season comparisons, and more. Whether you're a mathematician, scientist, or season-ticket holder to your favorite team, Baseball Hacks is sure to have something for you. Advance praise for Baseball Hacks: " Baseball Hacks is the best book ever written for understanding and practicing baseball analytics. A must-read for baseball professionals and enthusiasts alike." -- Ari Kaplan, database consultant to the Montreal Expos, San Diego Padres, and Baltimore Orioles "The game was born in the 19th century, but the passion for its analysis continues to grow into the 21st. In Baseball Hacks, Joe Adler not only demonstrates thatthe latest data-mining technologies have useful application to the study of baseball statistics, he also teaches the reader how to do the analysis himself, arming the dedicated baseball fan with tools to take his understanding of the game to a higher level." -- Mark E. Johnson, Ph.D., Founder, SportMetrika, Inc. and Baseball Analyst for the 2004 St. Louis Cardinals

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. What you will learn from this book Ways to quickly move and transform data How to configure every aspect of SSIS How to interface SSIS with web services and XML Techniques to scale the SSIS and make it more reliable How to migrate DTS packages to SSIS How to create your own custom tasks and user interfaces How to create an application that interfaces with SSIS to manage the environment A detailed usable case study for a complete ETL solution Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

The ability of a structural assembly to carry loads and forces determines how stable it will be over time. Viewing structural assemblages as comprising columns, beams, arches, rings, and plates, this book will introduce the student to both a classical and advanced understanding of the mechanical behavior of such structural systems under load and how modeling the resulting strains can predict the overall future performance—the stability—of that structure. While covering traditional beam theory, the book is more focused on elastica theory in keeping with modern approaches. This text will be an expanded and updated version a similar, previously published book, but with pedagogical improvements and updated analytical methods. This engineering textbook will provide a focused treatment on the study of how structures behave and perform when under stress loading, including plastic deformation and buckling. All advanced engineering students studying engineering mechanics, structural analysis and design, fatigue and failure, and other related subjects need to have this knowledge, and this book will provide it in a thorough and coherent fashion. Written by two of the world’s leading engineering professors in this subject area, the pedagogy has been classroom-tested over many years and should find a receptive readership among both students and instructors. * An understandable introduction to the theory of structural stability, useful for a wide variety of engineering disciplines, including mechanical, civil and aerospace engineering * Covers both static and dynamic loads, for both conservative and nonconservative systems * Emphasizes elastic behavior under loads, including vertical buckling, torsional buckling and nonlinear affects of structural system buckling and stability * Case examples to illustrate real-world applications of Stability Theory

As more companies need to manage their e-mail to support regulatory compliance, litigation, and corporate policy and to improve system performance and productivity, the e-mail archiving and records management solution presented in this IBM Redbooks publication is here to rescue. In this book, we provide a general solution guide to address e-mail archiving and records management issues using the following IBM products: We describe the products’ roles in the solution and introduce the basic concepts behind e-mail archiving and e-mail records enabling. We cover features and functions of CommonStore, Records Manager, and Records Enabler, and address key areas to understand and consider when planning and designing each piece of the solution and the overall integrated solution. In addition, we discuss different system configurations, implementation paths, security, the end-to-end solution installation and configuration, and some advanced topics such as records disposition and discovery. This book is intended for IT architects and specialists who will be responsible in planning, designing, and implementing an e-mail archiving and records management solution. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication discusses configuring and administering Linux systems running on IBM System z9 and zSeries. It is intended for system administrators and IT architects responsible for deploying Linux servers on System z9 and zSeries servers. We examine new features and enhancements of the Linux 2.6 kernel. We demonstrate Linux device configuration using sysfs and udev and discuss running Linux servers under z/VM. Networking options available for Linux on IBM System z9 and zSeries are examined in detail. Configuration of FCP-attached SCSI disks and traditional ECKD storage is demonstrated.

Want to find every pizza place within a 15-mile radius? Where the dog parks are in a new town? The most central meeting place for your class, club or group of friends? The cheapest gas stations on a day-to-day basis? The location of convicted sex offenders in an area to which you may be considering moving? The applications, serendipitous and serious, seem to be infinite, as developers find ever more creative ways to add to and customize the satellite images and underlying API of Google Maps. Written by Schuyler Erle and Rich Gibson, authors of the popular Mapping Hacks, Google Maps Hacks shares dozens of tricks for combining the capabilities of Google Maps with your own datasets. Such diverse information as apartment listings, crime reporting or flight routes can be integrated with Google's satellite imagery in creative ways, to yield new and useful applications. The authors begin with a complete introduction to the "standard" features of Google Maps. The adventure continues with 60 useful and interesting mapping projects that demonstrate ways developers have added their own features to the maps. After that's given you ideas of your own, you learn to apply the techniques and tools to add your own data to customize and manipulate Google Maps. Even Google seems to be tacitly blessing what might be seen as unauthorized use, but maybe they just know a good thing when they see one. With the tricks and techniques you'll learn from Google Maps Hacks, you'll be able to adapt Google's satellite map feature to create interactive maps for personal and commercial applications for businesses ranging from real estate to package delivery to home services, transportation and more. Includes a foreword by Google Maps tech leads, Jens and Lars Rasmussen.

IBM communication controllers have reliably carried the bulk of the world's business traffic for more than 30 years. Over the years, IBM controllers have been enhanced to the point that the functional capabilities of the current products, the 3745 Communication Controller and the 3746 Nways Multiprotocol Controller , surpass the capabilities of any other data networking equipment ever developed. Beyond the SNA architecture PU Type 4, beyond APPN, even beyond IP routing, these controllers support an extraordinary set of functions and protocols. Because of their long history and their functional richness, IBM controllers continue to play a critical role in the networks of most of the largest companies in the world. Over the past decade, however, focus has shifted from SNA networks and applications to TCP/IP and Internet technologies. In some cases, SNA application traffic now runs over IP-based networks using technologies such as TN3270 and Data Link Switching (DLSw). In other cases, applications have been changed, or business processes reengineered, using TCP/IP rather than SNA. Consequently, for some organizations, the network traffic that traverses IBM communication controllers has declined to the point where it is in the organization’s best interest to find functional alternatives for the remaining uses of their controllers so they can consolidate and possibly eliminate controllers from their environments. This IBM Redbooks publication provides you with a starting point to help in your efforts to optimize your communication controller environment, whether simply consolidating them or migrating from them altogether. We discuss alternative means to provide the communication controller functions that you use or ways to eliminate the need for those functions outright. Where multiple options exist, we discuss the relative advantages and disadvantages of each.

Conducting business via the Web and remaining open for business 24 hours a day, seven days a week is now commonplace. Customers come in with unexpected workloads through the Web and operate in a self-service fashion with mostly context-sensitive metadata to guide them. The strong requirement is availability. However, even with new Web applications, most of the core business systems considerations still apply, and performance is critical. Technology has been accelerating for mainframe systems. They had become adept at providing business resiliency accommodating strategic software that has been around for the last several decades such as IMS™ , DB2® , and CICS® , and they have also become a host for developing and running Web applications built in Java™ accommodating the latest business requirements. Businesses need to leverage, extend and integrate the strategic assets which represent multi-year investments to support leading edge technology. DB2 for z/OS® has come a long way and provides facilities to exploit the latest hardware and software technologies, accommodating a majority of user requirements. However, special considerations are required to build high performance applications. If you want to achieve high performance or high availability, you must use the design, programming, and operational techniques applicable to DB2. Please note that the additional material referenced in the text is not available from IBM.

Key Features Architecture, syntax, development and composition of Business Processes and Services using BPEL Advanced BPEL features such as compensation, concurrency, links, scopes, events, dynamic partner links, and correlations Oracle BPEL Process Manager and BPEL Designer Microsoft BizTalk Server as a BPEL server Book Description Web services provide the basic technical platform required for application interoperability. They do not, however, provide higher level control, such as which web services need to be invoked, which operations should be called and in what sequence. Nor do they provide ways to describe the semantics of interfaces, the workflows, or e-business processes. BPEL is the missing link to assemble and integrate web services into a real business process BPEL4WS standardizes process automation between web services. This applies both within the enterprise, where BPEL4WS is used to integrate previously isolated systems, and between enterprises, where BPEL4WS enables easier and more effective integration with business partners. In providing a standard descriptive structure BPEL4WS enables enterprises to define their business processes during the design phase. Wider business benefits can flow from this through business process optimization, reengineering, and the selection of most appropriate processes . Supported by major vendors - including BEA, Hewlett-Packard, IBM, Microsoft, Novell, Oracle, SAP, Sun, and others - BPEL4WS is becoming the accepted standard for business process management. This book provides detailed coverage of BPEL4WS, its syntax, and where, and how, it is used. It begins with an overview of web services, showing both the foundation of, and need for, BPEL. The web services orchestration stack is explained, including standards such as WS-Security, WS-Coordination, WS-Transaction, WS-Addressing, and others. The BPEL language itself is explained in detail, with Code snippets and complete examples illustrating both its syntax and typical construction. Having covered BPEL itself, the book then goes on to show BPEL is used in context. by providing an overview of major BPEL4WS servers. It covers the Oracle BPEL Process Manager and Microsoft BizTalk Server 2004 in detail, and shows how to write BPEL4WS solutions using these servers. What you will learn Chapter 1 provides a detailed introduction to BPEL and Service Oriented Architecture (SOA). It discusses business processes and their automation, explains the role of BPEL, web services, and Enterprise Service Buses (ESB) in SOA, provides insight into business process composition with BPEL, explains the most important features, compares BPEL to other specifications, provides an overview of BPEL servers, and discusses the future of BPEL. Chapter 2 provides a detailed introduction to the Web Services Technology Stack. It discusses the important standards and specifications for using BPEL and implementing SOA with web services, such as WS-Security, WS-Addressing, WS-Coordination, WS-AtomicTransaction, WS-BusinessActivity, WS-Reliable Messaging, etc. Chapter 3 discusses the composition of web services with BPEL. The chapter introduces the core concepts of BPEL and explains how to define synchronous and asynchronous business processes with BPEL. The reader gets familiar with BPEL process structure, partner links, sequential and parallel service invocation, variables, conditions, etc. Chapter 4 goes deeper into the BPEL specification and covers advanced features for modeling complex business processes. Advanced activities, scopes, serialization, fault handing, compensations, event handling, correlation sets, concurrent activities and links, process lifecycle, and dynamic partner links are covered in detail. Chapter 5 explains how to use the Oracle BPEL Process Manager for deploying and executing business processes defined in BPEL. It describes the server architecture, tools, features, and common approaches for managing and debugging BPEL processes. The chapter also looks at graphical development of BPEL processes using Oracle BPEL Designer for JDeveloper and for Eclipse. Chapter 6 takes a detailed look at the advanced features of the Oracle BPEL Process Manager including extension functions, dynamic parallel flows, Web Services Invocation Framework, Java embedding, Notification service, Workflow service, Identity service, and Oracle BPEL Server APIs. Chapter 7 discusses MS BizTalk Server 2004 and its support for BPEL. It explains how to develop business processes in BizTalk and export them to BPEL. It also explains how to import BPEL processes into BizTalk and how to use the Orchestration Designer tool to define processes graphically, and compares BizTalk and BPEL constructs. Appendix A provides a syntax reference for BPEL version 1.1. The appendix covers standard BPEL activities and elements, functions, attributes, and faults. Who this book is for This book is aimed at architects and developers in the design, implementation, and integration phases of advanced information systems and e-business solutions, developing business processes and dealing with the issues of composition, orchestration, transactions, coordination, and security. The book presumes knowledge of XML and web services, web services development (either on J2EE or .NET), and multi-tier architecture

The IBM eServer X3 Architecture servers are the new third-generation Enterprise X-Architecture servers from IBM. The xSeries 366 was announced in February 2005, the xSeries 460 was announced in May, and the xSeries 260 was announced in August. These X3 Architecture servers are ideal for random commercial workloads with high processor and memory bandwidth requirements. Although aimed at different client sets, they share common components and options. The x460 is targeted at clients who need to implement a large single image “scale-up” configuration of up to 32 processors and 512 GB of RAM. The x366 is targeted at the high-performance environment where rack space is a premium. The x260 is for clients who need high performance but also require large amounts of internal disk storage. This IBM Redbooks publication provides a detailed technical description of the three servers and explains how to plan, install, configure, and manage these high-performance servers running 32-bit and 64-bit versions of Windows Server 2003, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and VMware ESX Server.

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

IBM TotalStorage Productivity Center is a suite of infrastructure management software that can centralize, automate, and simplify the management of complex and heterogeneous storage environments. It can help reduce the effort of managing complex storage infrastructures, improve storage capacity utilization, and improve administration efficiency. IBM TotalStorage Productivity Center allows you to respond to on demand storage needs and brings together, in a single point, the management of storage devices, fabric, and data. This IBM Redbooks publication is intended for administrators and users who are installing and using IBM TotalStorage Productivity Center. It provides an overview of the product components and functions. We describe the hardware and software environment required, provide a step-by-step installation procedure, and offer customization and usage hints and tips. This book is not a replacement for the existing IBM Redbooks, or product manuals, that detail the implementation and configuration of the individual products that make up the IBM TotalStorage Productivity Center , or the products as they may have been called in previous versions. We refer to those books as appropriate throughout this book.

Implement a comprehensive, integrated application platform Take full advantage of the power, flexibility, and adaptability of SAP -- the premier solution for service-based, enterprise-scale business processes. SAP R/3 Handbook, Third Edition offers complete coverage of installation, implementation, operation, and support. You'll get full details on all the components, including SAP Web Application Server, SAP NetWeaver, the ABAP workbench, and more. Administration, security, and integration with other systems is also covered. ESSENTIAL SKILLS FOR SAP TECHNICAL CONSULTANTS Get an overview of SAP business, integration, and collaboration solutions Understand SAP Web Application Server architecture Get details on the SAP NetWeaver platform Access SAP systems through the SAP presentation interface Use the ABAP workbench development environment Handle system administration and implement security Manage system-wide changes with the Transport Management System (TMS) Analyze performance and troubleshoot SAP solutions

The most recent maintenance release of IBM AIX 5L Version 5.3 includes a significant set of new features added to the NFSv4 implementation. In 2004, the first IBM Redbooks publication devoted to the topic of NFSv4 implementation in AIX 5L was published: "Securing NFS in AIX: An Introduction to NFS V4 in AIX 5L," SG24-7204. This book provides additional up-to-date information to help IBM clients understand and take advantage of the new NFSv4 functions provided by AIX 5L Version 5.3 with the 5300-03 Recommended Maintenance Package. The NFSv4 implementation in AIX 5L has now expanded to provide core features that make it capable of providing a much broader range of distributed file system services than any prior version of NFS. The scope of this book includes methods for implementing NFSv4 in the enterprise and extensive coverage of methods for how it can potentially be used as a migration target for existing AFS-based and DCE/DFS-based enterprise file systems. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli System Automation for Multiplatforms monitors and automates applications distributed across Linux® , AIX® , and z/OS operating systems by introducing a new product structure with two major components: IBM Tivoli System Automation for Multiplatforms utilizes an adapter infrastructure to integrate with IBM Tivoli System Automation for z/OS, allowing for a more effective high-availability, automation, and management of multi-tier applications. This IBM Redbooks publication introduces the new versions of the IBM Tivoli Systems Automation product family and gives a broad understanding of the new architecture and components of both IBM Tivoli System Automation for Multiplatforms V2.1 and IBM Tivoli System Automation for z/OS V3.1 using a scenario based approach. This book is a valuable addition to the existing products documentation and should be read in conjunction with the official products documentation, which complements some of the concepts explained in this book. The instructions given in this book are very detailed and explicit. These instructions are not the only way to install the products and related prerequisites. They are meant to be followed by anyone to successfully install, configure, and set up end-to-end automation management using IBM Tivoli System Automation for Multiplatforms V2.1 and IBM Tivoli System Automation for z/OS V3.1 in environments of any size. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides guidance about how to configure, monitor, and manage your IBM TotalStorage DS6000 to achieve optimum performance. We describe the DS6000 performance features and characteristics and how they can be exploited with the different server platforms that can attach to it. Then in consecutive chapters we detail the specific performance recommendations and discussions that apply for each server environment, as well as for database and Copy Services environments.