This IBM Redbooks publication discusses Portable Data Containers. Portable Data Containers are a tool that allows customers to migrate their applications from UNIX to Linux more seamlessly. They are a part of VERITAS Storage Foundations 4.0. With Portable Data Containers, a customer can migrate an application without moving that application's data. This book describes the concepts of storage management and the key features of VERITAS Storage Foundations 4.0 and . In addition, it discusses a number of considerations that you should review prior to a UNIX to Linux migration, and then takes you through a step-by-step migration from Solaris to Linux. It discusses the performance and scalability of Portable Data Containers and compares the throughput of Portable Data Containers with theoretical network throughput and disk transfer speeds. Finally, this book includes best practices for migrating applications to Linux using Portable Data Containers. In particular, it identifies the steps that are required to migrate an Oracle or DB2 database from a UNIX server to a Linux server. With this knowledge, customers can accelerate their migration plans to Linux to take advantage of the cost benefits provided by the open-source operating system. The audience for this book are IBM Clients and Business Partners as well as IT specialists and database administrators.

This IBM Redbooks publication is a practical cookbook that provides up-to-date information about Cluster Systems Management (CSM) for AIX 5L for a pSeries environment. The book provides information about the latest CSM for AIX 5L enhancements, including implementation techniques, installation changes, installation tools, system management tools, monitoring tools, hardware control, file distribution, problem determination, and management server high availability. This book summarizes the latest news in CSM 1.4.0. It contains a Q&A chapter, a CSM installation scenario, a CSM advanced chapter, CSM migration scenarios, and a CSM cluster administration chapter. We include information about how to manage Linux nodes on pSeries hardware including operating system installation and node management in a mixed cluster environment. This book is targeted to technical professionals (consultants, IT architects, and IT specialists) who are responsible for providing pSeries clustering solutions.

IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL Fully updated to reflect the entire DB2 UDB product family, and new SQL PL improvements for Windows, UNIX, Linux, iSeries, and zSeries Presents expert tips and best practices drawn from extensive experience in real customer environments Covers everything from basic program structure through advanced techniques Includes up-to-the-minute coverage of optimization and troubleshooting Using the IBM DB2 SQL Procedural Language (SQL PL), programmers can drive major improvements in database performance, manageability, and time-to-market. Now, IBM's own experts present the definitive guide to DB2 SQL PL development on any platform: Windows, UNIX, Linux, iSeries, or zSeries. DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions. The only book to combine practical SQL PL tutorials and a detailed syntax reference, DB2 SQL PL, Second Edition draws on the authors' unparalleled expertise with SQL PL in real business environments. Coverage includes Using SQL PL to improve manageability and performance, while clearly separating DBA and development roles Writing more efficient stored procedures, triggers, user-defined functions (UDFs), and dynamic compound SQL Identifying SQL PL performance bottlenecks--and resolving them Leveraging new language enhancements for Windows, UNIX, and Linux: improved table function support, session based locking, nested save points, new prepare options, and more Using new features for iSeries V5R3: built-in string and date/time manipulation functions, SEQUENCE objects, and more Utilizing zSeries Version 8's integrated stored procedures debugging and improved SQL Conditions support Mastering DB2 Development Center, the unified development environment for creating DB2 stored procedures Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this book indispensable.

Scheduling is generally considered as the nucleus of the data center, because the orderly, reliable sequencing and management of process execution is an essential part of IT management. IBM Tivoli Workload Scheduler for z/OS is the IBM strategic product used in many large-to-midsized customer environments, responsible for scheduling critical batch applications. Therefore, the performance of Tivoli Workload Scheduler for z/OS is one of the important factors that affect the overall satisfaction from the IT services for these companies. This IBM Redbooks publication covers the techniques that can be used to improve performance of Tivoli Workload Scheduler for z/OS (including end-to-end scheduling). There are many factors that might affect the performance of any subsystem. In this book, we confine ourselves to those things that are internal to Tivoli Workload Scheduler, or can be easily verified and modified, and are likely to apply to the majority of Tivoli Workload Scheduler customer sites. Although this book is aimed at those very large installations with a batch load of 100,000 or more jobs per day, it will also be relevant to installations with a smaller batch workload who are suffering from a shrinking batch window, or those who are trying to maximize the throughput on their existing hardware, or both. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution. This publication documents procedures for monitoring existing DB2 II implementations for the purposes of capacity planning. It also documents a methodology for routine and exception monitoring of a DB2 II environment for performance problem determination; and describes some commonly encountered performance problem scenarios and the step-by-step approach used in problem determination and resolution.

This IBM Redbooks publication describes how to install and configure the very latest IBM storage solution and concept, the IBM TotalStorage Network Attached Storage (NAS) Gateway 500, in heterogeneous environments. The IBM TotalStorage NAS Gateway 500 series is an innovative Network Attached Storage device that connects clients and servers on an IP network to Fibre Channel storage, efficiently bridging the gap between LAN storage needs and SAN storage capacities. The IBM TotalStorage NAS Gateway 500 is a storage solution for UNIX/AIX/Linux, Apple, and Microsoft Windows environments. In this book, we show how to integrate the IBM TotalStorage NAS Gateway 500 and explain how it can benefit your company’s business needs. This book is an easy-to-follow guide which describes the market segment that the IBM TotalStorage NAS Gateway 500 is aimed at, and explains NAS installation, ease-of-use, remote management, expansion capabilities, high availability (two node clustering and up to four node remote mirroring), and backup and recovery techniques. It also explains open systems storage concepts and methodologies for common data sharing for UNIX/AIX/Linux, Apple, and Microsoft Windows environments. Please note that the additional material referenced in the text is not available from IBM.

The IBM DB2 Integrated Cluster Environment for Linux is a completely integrated, high-performance, and pre-tested solution that incorporates best-of-breed software, hardware, and services. This IBM Redbooks publication provides you with the technical details of the DB2 Integrated Cluster Environment. We begin with a general overview of DB2 Integrated Cluster Environment and the fundamentals of DB2 in a Linux cluster environment, followed by a discussion of hardware options for cluster ingredients that constitute DB2 Integrated Cluster Environment and considerations for their selection. We cover the planning and database design considerations for building a DB2 partitioned database that is both flexible and scalable and provide the implementation details of DB2 Linux clusters. This publication also cover the new autonomic features of DB2 UDB V8.2 and system tools monitoring. It describes components and possible configurations of a high-availability solution and provides implementation details of a failover protection in an DB2 Integrated Cluster Environment. At the end, we discuss scalability in the DB2 Integrated Cluster Environment, including some guidance in planning for the growth of a business and database. We also examine a number of scaling strategies in more detail and provide the steps involved in scaling a database.

IBM DB2 Universal Database Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This IBM Redbooks publication is an update of DB2 UDB Exploitation of the Windows Environment (SG24-6893), with a focus on DB2 UDB Version 8.2 functions and features. We illustrate, step-by-step, the installation and migration processes. The new autonomic computing technology that makes the DBA’s job easier is described in detail. The new security features and their integration with the Windows environment are discussed intensively. This book covers the new performance and monitoring enhancements of Version 8.2. New, exciting high availability functions are described in detail. Further, we discuss aspects of DB2 application development with .NET 2003 and Java and provide programming details using ADO.NET, CLR, and Java.

The IBM WebFacing Tool, part of IBM WebSphere Development Studio Client for iSeries, is one of the most important tools for IBM eServer iSeries developers. It facilitates quick conversion of existing host applications into Web applications. WebSphere Development Studio Client for iSeries comes in two editions, Standard and Advanced, each of which support a different level of features. WebSphere Development Studio Client for iSeries Advanced Edition V 5.1.2 introduces support for system screens for the WebFacing applications. This new feature removes one of the biggest limitations of previous versions of the IBM WebFacing Tool. This IBM Redbooks publication provides helpful guidance to developers who are new to refacing applications using the IBM WebFacing Tool. It also offers advanced techniques to developers who have some experience in using the IBM WebFacing Tool and want to refine their Web applications. First, this book introduces you to the IBM WebFacing Tool. Then it walks you through a scenario, which involves converting a 5250 application to a Web application. Next it explains how to refine your browser interface and customize a WebFacing application. Finally, it discusses how to integrate and extend your WebFacing application to provide the required and added functions. Please note that the additional material referenced in the text is not available from IBM.

ThinkVantage Technologies bring your IBM PCs one step closer to being self-configured, self-optimizing, self-protecting, or self-healing, to help save you time and money throughout the life of your systems. In short, ThinkVantage Technologies let you focus your attention on your business, rather than on your computer. ThinkVantage Technologies are software tools designed to help customers drive down IT support costs (in particular, the cost of a PC in managing and supporting systems after its initial purchase), increase security and decrease the complexity of today’s IT infrastructure. This series of Redbooks will help you install, tailor and configure the IBM ThinkVantage Technologies on IBM and OEM desktops. Using ThinkVantage Technologies, Volume 1: Creating and Deploying Client Systems describes how to create and deploy client systems. The tools covered include: - ImageUltra Builder

This IBM Redbooks publication explains the new IBM Tivoli Monitoring for Network Performance Version 2.1. This version of IBM Tivoli Monitoring for Network Performance provides a complete redesign of the z/OS TCP/IP management tools that is started by the NetView Performance Monitor for TCP/IP. IBM Tivoli Monitoring for Network Performance provides a comprehensive TCP/IP stack monitoring for z/OS. It collects performance metrics from the z/OS Communication Servers system management interface, measuring response time and Simple Network Management Protocol (SNMP) Management Information Base (MIB) variable collection. IBM Tivoli Monitoring for Network Performance uses strategic IBM software platforms such as WebSphere Application Server as the Web application platform and DB2 Universal Database as the central repository. This book starts with exploring on the architecture of IBM Tivoli Monitoring for Network Performance and its components. We also discuss various implementation scenario and evaluate the benefits and drawbacks of each scenario. Implementation planning and consideration is presented and lastly operational consideration is explained.

The beginning of the new century sees the data center with a mix of work, hardware, and operating systems previously undreamed of. Today’s challenge is to manage disparate systems with minimal effort and maximum reliability. People experienced in scheduling traditional host-based batch work must now manage distributed systems, and those working in the distributed environment must take responsibility for work running on the corporate OS/390 system. This IBM Redbooks publication considers how best to provide end-to-end scheduling using IBM Tivoli Workload Scheduler Version 8.2, both distributed (previously known as Maestro) and mainframe (previously known as OPC) components. In this book, we provide the information for installing the necessary Tivoli Workload Scheduler 8.2 software components and configuring them to communicate with each other. In addition to technical information, we consider various scenarios that may be encountered in the enterprise and suggest practical solutions. We describe how to manage work and dependencies across both environments using a single point of control. We believe that this book will be a valuable reference for IT specialists who implement end-to-end scheduling with Tivoli Workload Scheduler 8.2.

This IBM Redbooks publication documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM's Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals responsible for developing e-business solutions that integrate processes and data from multiple distributed heterogeneous systems. This publication provides an overview of IBM’s Patterns for e-business, and the DB2 Information Integration architecture. It also describes the various application and runtime patterns identified to date for Information Aggregation and Data Integration, as defined in "Patterns for e-business". Using a typical customer insight e-business scenario, this publication documents the step-by-step patterns approach to implementing the e-business solution. At each level in the hierarchy, each available pattern is evaluated and chosen before drilling down to the next lower layer where the pattern evaluation and selection process is repeated. The final drill down leads to product selection and implementation information.

This IBM Redbooks publication provides an overview of the solution offerings — IBM TotalStorage Productivity Center and IBM TotalStorage Productivity Center with Advanced Provisioning. It presents an overview of the product components and functions, explaining the architecture and showing the use of storage provisioning workflows. This book is intended for those who want to learn more about IBM TotalStorage Productivity Center, IBM TotalStorage Productivity Center with Advanced Provisioning, and IBM TotalStorage Provisioning Manager. This easy-to-follow guide describes on demand provisioning for managing resources and information, as well as enhancing automation by explaining how these innovative offerings may improve client business. The book explains how to take storage management concepts to the next level, describing the architecture, components, and component interaction, explaining storage automation, and showing how to create high and low level workflows by using examples along with common storage management tasks. Narrated screen recordings in QuickTime format: IBM TotalStorage Productivity Center LaunchPad demonstration (26MB) IBM Tivoli TotalStorage Provisioning Manager Overview (62MB) IBM TotalStorage Productivity Center with Advanced Provisioning Workflow Case Study (66MB) Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides an introduction to the Enterprise Workload Manager (EWLM). In addition to describing the overall product concept and functionality, it presents a detailed discussion of the elements that are part of the solution.

This IBM Redbooks publication covers the process of converting a PSSP cluster to a CSM cluster. It examines the different tools, utilities, documentation and other resources available to help the system administrator move a system from PSSP to CSM. This book also makes recommendations about which procedures are most suitable for different types of customer environments (high performance technical computing, server consolidation, business intelligence, etc.) and points out the relative advantages and disadvantages of the different procedures, tools, and methods. Customers will use the working knowledge presented in this book to plan and accomplish the transition of their own clustered systems from PSSP to CSM. Are you using GPFS? This transition book covers a number of GPFS transition methods, each with its own recommendations, GPFS cluster types, advantages versus disadvantages, and step-by-step scenarios. It also shows a method of moving GPFS storage between two clusters, which could be used during hardware transition or upgrades.

The IBM z990 includes both standard cryptographic hardware and optional cryptographic features, to give flexibility and growth capability. IBM has a long history of providing hardware cryptographic solutions, from the development of Data Encryption Standard (DES) in the 1970s to delivering the only integrated cryptographic hardware in a server to achieve the US Government's highest FIPS 140-2 Level 4 rating for secure cryptographic hardware.

This IBM Redbooks publication discusses Performance Toolkit for VM, a performance monitoring and analysis tool for z/VM. Derived from the earlier FCON/ESA product, Performance Toolkit for VM enables system administrators to collect and analyze VM performance data. Both real-time and history data can be processed by Performance Toolkit for VM, and it provides most of the functions that are available in Real Time Monitor (RTM) and Performance Reporting Facility (PRF). In this book, we present an overview of the functions and features of Performance Toolkit for VM. We show how to navigate through its major monitoring screens and configure it. We also describe configuration for monitoring remote z/VM systems. Using examples, we illustrate how to monitor your z/VM system to identify potential performance problems. Major performance factors for running Linux guests under z/VM are discussed.

In many organizations, relational databases are the backbone for data storage and retrieval. Over the last couple of years, XML has become the de facto standard to exchange information between organizations, as well as between departments or applications within the same organization. Since data tends to live in databases, it needs to be converted from a relational format into an XML format when involved in those data exchanges, as well as converted (back) from XML into a relational format for storage, or for handling by other applications. How can we achieve this? This IBM Redbooks publication describes how to design the mapping between XML and relational data, and vice versa, to enable a flexible exchange of information. IBM provides a number of products to help you bridge the gap between XML and its relational database, DB2. The DB2 engine itself provides support to generate XML fragments from relational data through the use of SQL/XML built-in functions. DB2 also provides the DB2 XML Extender. It allows you to perform XML composition, like SQL/XML, but also provides functionality to decompose XML documents and store XML documents intact inside the database. XML Extender also provides a set of transformation and validation functions. Another option to work with XML is to use the XML wrapper, a part of the set of non-relational wrappers of DB2 Information Integrator. This book also looks at the IBM tools available to assist you when dealing with XML, specifically WebSphere Application Developer and DB2 Control Center. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication describes the copy functions available with the IBM TotalStorage Enterprise Storage Server (ESS). The powerful ESS Copy Services functions are explained in detail, and their characteristics are thoroughly covered. This book also provides information on how to manage the various ESS Copy Services functions, and discusses their implementation. This book applies to the ESS Models when used in the IBM eServer zSeries environments. Because this book provides a broad understanding of the ESS Copy Services functions, as well as presenting details about the management interfaces and the implementation considerations, it is a recommended manual for IT professionals who are planning the implementation of any of the ESS Copy Services functions in a zSeries environment, as well as for those who will manage these environments. This fifth edition of the book has been updated with the latest ESS Copy Services announcements: Asynchronous PPRC can be used for a two site Disaster Recovery solution, a FlashCopy target can now be a PPRC primary, and there are several other updates associated with ESS LIC 2.4.0. These include the ESS Model 750 overview, minor additions for ESS API support, Multiple Device Manager Replication Manager, Asynchronous PPRC Utilities for Open System Environment, and Asynchronous PPRC Utilities for ICKDSF User.