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.

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.

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.

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.

This IBM Redbooks publication delivers details about DB2 UDB V8.2 on Siebel 7.8. It outlines the partnership between Siebel Systems and IBM and the benefits of using DB2 UDB to support the Siebel Enterprise. The most commonly used components of the Siebel Enterprise and the DB2 UDB architecture are described. We provide the planning considerations for running DB2 UDB in Siebel environment. The step-by-step installation and configuration details are followed. We then describe information on methods to populate and maintain data in Siebel tables including data archival techniques and information on ensuring data integrity and data quality. The database administration, monitoring, and tuning tools provided by DB2 UDB and operating systems are discussed and the tool usage provided. The book also provides in-depth discussion on high availability and disaster recovery options and setup procedure for a Siebel/DB2 UDB environment. Finally, the book provides information about the components of Siebel Analytics and where these components fit in the overall scheme with Siebel Enterprise.

As companies depend more and more on their enterprise software for daily operations, they require highly available systems. JD Edwards EnterpriseOne has long enabled their software with the IBM High Availability Cluster Multi-Processing (HACMP) product for high availability. This IBM Redbooks publication describes the IBM HACMP/Enhanced Scalability (HACMP/ES) Version 4.5 solution to certify JD Edwards EnterpriseOne 8.9 in an IBM AIX high availability environment. This book also describes HACMP/ES Version 5.1. It explains how to install and tune HACMP/ES, as well as reviews the setup steps to enable JD Edwards EnterpriseOne for HACMP/ES. While writing this book, we conducted tests to simulate that the failures and observations made to ensure that the high availability environment performed properly. The results of these tests are also documented. This book highlights and explains those characteristics that are specific to JD Edwards EnterpriseOne. It contains significant window examples and worksheets to help facilitate an easy step-by-step installation process. It does not replace the extensive installation and administration documentation that is already available for HACMP/ES.

IBM and SAP share a vision for responding to customers' specific requirements for tighter integration, platform flexibility, lower total cost of ownership, and improved performance. DB2 UDB V8.2.2 is an SAP-optimized version that uses autonomic computing technologies specifically tuned to help SAP users streamline installation, improve performance, and increase availability. This IBM Redbooks publication provides information for SAP consultants and SAP system administrators. It includes the latest DB2 UDB architecture details, SAP-related features and functions, practical advice on SAP NetWeaver 2004 installations, and DB2 configuration in SAP environments. We describe DB2 UDB’s logical and physical database objects, storage management, SAPs data classes, and space reclamation strategies, and provide the best practices for intelligent storage subsystems. We also discuss how to use DBA Cockpit to monitor your system, DB2 UDB log file management, database backup and recovery, and high availability and clustered solutions. We introduce the Problem Description / Problem Source Identification (PD/PSI) methodology, and the troubleshooting approaches for common problems. Finally, we include a discussion of the new features of SAP NetWeaver 2004s Business Intelligence (SAP BI) with DB2 UDB V8.2.2.

This IBM Redbooks publication discusses miscellaneous implementation topics and integration information for IBM Tivoli Business Systems Manager Version 3.1. The discussion is geared for an experienced IBM Tivoli Business Systems Manager specialist that requires an in-depth discussion for advanced implementation and integration options. This book does not provide basic implementation information for IBM Tivoli Business Systems Manager. That information can be found in IBM Tivoli Business Systems Manager V2.1 End-to-end Implementation, SG24-6610. Although that book discusses Version 2.1, most of the discussion still applies in Version 3.1. Additional information can be read from the formal IBM Tivoli Business Systems Manager Version 3.1 manuals. This book provides: Please note that the additional material referenced in the text is not available from IBM.

IBM, a leader in collaboration, has created IBM Workplace Collaboration Services--a new completely, integrated collaborative environment based on open standards. IBM Workplace Collaboration Services provides a wide range of integrated, ready-to-use communication and collaboration capabilities as services for the IBM Workplace environment. This includes capabilities such e-mail, calendaring and scheduling, presence and awareness, instant messaging, learning, team spaces, Web conferencing, and document and Web content management. This IBM Redbooks publication is an installation and deployment guide for IBM Workplace Collaboration Services Release 2.5. We provide detailed installation procedures for Microsoft Windows and Novell SUSE Linux and highlight clustered deployment.

Deploying a storage management solution for a small or medium-size business begins with a thorough analysis of the existing business and IT environment. The next step after fully understanding the organization is planning and sizing. This is the key stage, because deployment success depends on how well you plan and size. This IBM Redbooks publication takes a step-by-step approach to deploying a storage management solution based on IBM Tivoli Storage Manager. The first two chapters introduce overall planning and sizing issues. Then we focus on the detailed installation and configuration of Tivoli Storage Manager, and offer some deployment scenarios and troubleshooting of storage management implementation. Readers should be familiar with the following topics: This book does not cover whole IBM Tivoli Storage Manager components or other discussions for the planning and sizing experience.

IBM TotalStorage Productivity Center is designed to provide a single point of control for managing networked storage devices that implement the Storage Management Initiative Specification (SMI-S), including the IBM TotalStorage SAN Volume Controller, Enterprise Storage Server, and FAStT. TotalStorage Productivity Center includes the IBM Tivoli Bonus Pack for SAN Management, bringing together device management with fabric management, to help enable the storage administrator to manage the Storage Area Network from a central point. The storage administrator has the ability to configure storage devices, manage the devices, and view the Storage Area Network from a single point. This software offering is intended to complement other members of the IBM TotalStorage Virtualization family by simplifying and consolidating storage management activities. This IBM Redbooks publication includes an introduction to the TotalStorage Productivity Center and its components. It provides detailed information about the installation and configuration of TotalStorage Productivity Center for Disk and TotalStorage Productivity Center for Replication and how to use them. It is intended for anyone wanting to learn about TotalStorage Productivity Center and how it complements an on demand environment and for those planning to install and use the product.

IBM Tivoli Configuration Manager controls software distribution and asset management inventory in a multiplatform environment. It is designed for configuration, distribution, change, version, and asset management in a distributed computing environment. Working on top of IBM Tivoli Management Framework, IBM Tivoli Configuration Manager provides an integrated solution for managing complex, distributed enterprise environments. This IBM Redbooks publication introduces the IBM Tivoli Configuration Manager logical and physical components and covers detailed planning and implementation steps to deploy IBM Tivoli Configuration Manager in small-to-medium and large-sized environments, including IBM AIX 5L, Microsoft Windows, Linux, and IBM OS/400 systems. In addition, we talk about best practices, advanced customization, and tuning topics for IBM Tivoli Configuration Manager. This book will be useful for IT specialists responsible for implementing IBM Tivoli Configuration Manager V4.2.x in customer environments. Please note that the additional material referenced in the text is not available from IBM.

Linux on zSeries offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on zSeries takes advantage of the qualities of service in the zSeries hardware—making it a robust industrial strength Linux. This provides an excellent platform for consolidating Oracle databases that exist in your enterprise. This IBM Redbooks publication describes experiences gained while installing and testing Oracle10g for Linux on zSeries, such as: -Installing a single instance database of Oracle10g instances for Linux on zSeries Interested readers include database consultants, installers, administrators, and system programmers.

This IBM Redbook is a study guide for IBM Tivoli Storage Manager Version 5.3 and is meant for those who want to achieve IBM Certifications for this specific product.

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized database SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints How data sets can interact with queries The importance of subqueries Data conversion and manipulation via SQL's built-in functions How conditional logic can be used in Data StatementsBest of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL. Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

This IBM Redbooks publication is part of a series of documents related to grid computing that IBM is presenting to the IT community to enrich it and all its players: clients, industry leaders, emerging enterprises, universities, and producers of technology. It is mainly oriented to IT architects or those who have the responsibility of analyzing the capabilities of the product used to build a grid solution. We describe the functions of grid computing and the categorizations of the components within it. IBM, ISVs, and open source products will be explained. Some of these products are not specific for grid, but they can be used in a grid computing environment. We hope that this book helps you select functions and products and shows you how grid can fit into your IT picture as new products and services for grid are introduced. Part 1 introduces the concept of grid computing and provides the terminology the readers will use in this book. Part 2 explores the functionality associated with certain products and product families. It also presents some examples of the utilization of these products in the grid computing environment. Part 3 presents grid computing product families that can be used to build a complete grid solution. These bundles, or suites, often implement most of the core grid disciplines. Part 4 gives an overview of the grid computing offerings and services that IBM provides.

This IBM Redbooks publication presents an overview of IBM Tivoli Storage Manager Version 5.3. It is designed as a workshop presentation guide, and therefore uses presentation slides to provide descriptions about the changes made in the new release. This format enables you to easily gain a comprehensive overview and to quickly understand the new features of Tivoli Storage Manager. This book is intended for IBM Clients, Business Partners, consultants, 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.3.0, 5.3.1, and 5.3.2. We recommend that you use this book in conjunction with the ITSO workshop, the book "IBM Tivoli Storage Manager Version 5.3 Technical Guide", SG24-6638, manuals and readme files that are provided with the products. This book is not intended to replace any information contained therein.

IBM Workplace Services Express is software that makes it easy for you, your colleagues, your teams, and your entire organization to quickly collaborate and effectively work together. Designed specifically for small and medium-sized organizations with less than a thousand employees, or departmental needs in larger organizations, Workplace Services Express enables you to easily create, edit, and share documents from your own customized Workplace environment. This IBM Redbooks publication will introduce you to Workplace Services Express and its features and tell you how to deploy and customize it. Whether you are a line-of-business manager who wants to understand the business value of Workplace Services Express, an administrator who wants to install it, or an application developer who wants to customize it, this book is for you. Please note that the additional material referenced in the text is not available from IBM.

The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change. This IBM Redbooks publication focuses on strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB). It provides detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities. XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB. The features and functionality of each DBMS are briefly described for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL. It also discusses products and tools to complement these database management systems. With this information, you can better decide which products satisfy your particular requirements, and better plan on how to achieve your objectives as you develop your database management system strategy. You will be better positioned to make informed decisions that can give you the best return on your DBMS investment.