This IBM Redbooks publication will help you to migrate the Siebel 2000 V6.2.1 database from: DB2 for NT V6 to DB2 for OS/390 V6 Oracle for NT V8.1.6 to DB2 for NT V6 Oracle for NT V8.1.6 to DB2 for OS/390 V6 The book describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the UK. It provides an overview of Siebel architecture, and introduces the migration methodology needed to move the Siebel database from a DB2/Oracle for NT platform to a DB2 for OS/390 platform. It offers a step-by-step description of the database migration process, and discusses in detail the different methods of moving data from one platform to the other. This book will be especially useful for those migrating the Siebel database for the first time.

This IBM Redbooks publication shows the different techniques customers can use to clone their DB2 system. Although the scenarios in the book use an SAP workload, the DB2 cloning techniques we describe are not specific to SAP. Those techniques can apply to any DB2 system and the applications running on that DB2. The book describes hands-on details of selected DB2 database cloning scenarios, typically the most popular techniques currently used by customers, as well as the most efficient scenarios we would like to recommend to DB2 database administrators. The scenarios described in this book are based on SAP examples. Our source system resides on a DB2 data sharing group. We have one target system residing on another DB2 data sharing group and one residing on a non-data sharing DB2. All source and target systems are in the same OS/390 Sysplex environment. We discuss and show DB2 system cloning techniques using the following methods: - ESS Flashcopy - DFSMS copy and rename The book addresses an audience with in depth knowledge of DB2 for z/OS and OS/390 database administration and savy in SAP system requirements.

A Netfinity Enabled for S/390, generally known as a Netfinity/EFS system, is the smallest S/390 fully supportedby IBM. It is based on a PC Server, running UNIX, and the S/390 emulation product FLEX-ES. FLEX-ES is a product of Fundamental Software, Incorporated (FSI) of Fremont, California. This package (the Server, UNIX, and FLEX-ES) is intended to run all current S/390 operating systems. This IBM Redbooks publication introduces the Netfinity/EFS system, describes the setup process of the system in some detail, and then describes the installation and use of a particular z/OS package known as the z/OS AD CD-ROM system. While this document is primarily directed at members of IBM's S/390 Partners in Development program (also known as PartnerWorld), most of the content applies to any Netfinity/EFS system.

This IBM Redbooks publication gives you information to use the IBM Enterprise Storage Subsystem with IBM DB2 Universal Database. Most of the information presented here applies to UNIX and Windows environments. Our examples are only for AIX. First, we supply an overview of the products that we use in our environment and introduce the terminology. Next, we discuss the configuration options available for these products and the methodology that we recommend for sizing an Enterprise Storage Subsystem for use with the DB2 Universal Database. We also discuss the challenges of mapping the system resources to the database activity in an ESS environment, and we discuss the diagnostic tools which are available and how to use them when working with performance issues. Then we discuss backup and recovery and explain some of the new features available with DB2 UDB V7.2, which enable some of the ESS capabilities. Last, we include our test examples. This book is intended to be read by systems administrators, storage specialists, database administrators and database specialists. We assume a base knowledge of either: ESS, AIX and/or DB2 and intend that this book will help you understand your area of expertise in a wider context.

This IBM Redbooks publication is designed to assist Oracle Database administrators and system/storage administrators with Oracle backup solutions using Tivoli Storage Manager V4.1. The primary tool we used for backup and recovery is Tivoli Data Protection (TDP) for Oracle V1.1, and the book covers setup and configuration of TDP as well as day-to-day management examples. Operating environments covered by the project are AIX, Sun Solaris, and Microsoft Windows 2000. We provide an overview of relational database management systems and how to plan for protecting them. This book will help you install, tailor, and configure Tivoli Storage Manager and Tivoli Data Protection for Oracle on UNIX and Microsoft Windows 2000 platforms in order to accomplish backup and restore of Oracle8i databases. RMAN commands and setup are covered in detail, and emphasis is placed on practical recovery scenarios. Also featured are new solutions utilizing Tivoli's hardware integration features for IBM's ESS intelligent storage subsystem, as well as an update on using TDP for Oracle V2.2 new features. Note: This book replaces relevant sections of the earlier book, Using ADSM to Back Up Databases, SG24-4335-03, by updating and re-branding the content of that book.

A ThinkPad Enabled for S/390, generally known as a ThinkPad/EFS system, is the smallest S/390 currently available, and is intended for development and demonstration purposes. It is based on an IBM ThinkPad running Linux, and the S/390 emulation product FLEX-ES. FLEX-ES is a product of Fundamental Software, Incorporated (FSI) of Fremont, California. This package (the ThinkPad, Linux, and FLEX-ES) can run all current S/390 operating systems. This IBM Redbooks publication introduces the ThinkPad/EFS system, describes the setup process of the system in some detail, and then describes the installation and use of an OS/390 package known as the OS/390 AD CD-ROM system. While this publication is primarily directed at members of the IBM S/390 Partners in Development program (also known as PartnerWorld), most of the content applies to any ThinkPad/EFS system.

Publish and Subscribe is an effective way of disseminating information to multiple users. Publish/Subscribe applications can help to enormously simplify the task of getting business messages and transactions to a wide, dynamic and potentially large audience in a timely manner. This IBM Redbooks publication positions the MQSeries Publish/Subscribe to MQSeries Integrator Publish/ Subscribe. It will help you create, tailor and configure an application from publishing data through to subscribing via web pages. The books provides a broad understanding of a building and running an entire publish/subscribe solution. It will help give you a quick start to design and create a solution and then migrate it from MQSeries Publish/Subscribe to MQSeries Integrator Publish/Subscribe.

Fast Connect for AIX, announced with AIX 4.3.2, was IBM's first step to let PCs take advantage of the performance, scalability, and reliability of AIX. The new version 3.1 adds powerful new features, such as user name mapping and remote password change. This IBM Redbooks publication walks you through the installation and the setup of Fast Connect on your server. It shows how to customize this product by declaring file shares, and print shares. Because security and ease of administration of the password databases on the network are two important tasks for the system administrator, this book describes which security models are available and how to set up your PC clients to communicate with the Fast Connect for AIX server. For its in depth coverage of the Fast Connect for AIX product, this book is a must-read for I/T specialists who have to recommend a solution for AIX and PC interoperability, as well as system administrators who have to implement such a solution.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in health care by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical health care issues are addressed in this book, such as: How to calculate weight for diagnoses related groups? Are there characteristic groups of patients in my population? Can we optimize medical tests for a specific disease? Can we detect precauses for a special medical condition? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner for Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in telecommunications by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical telecoms issues are addressed in this book, such as: What are the characteristics of your customers? Can you predict the customers who are likely to leave? How do you discover the true value of your customers? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner for Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in banking by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture as an integrated solution. Typical banking issues are addressed in this book, such as: How can you discover the characteristics of your customers? Which products can you sell to which customers and how? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner For Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in retail by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture. Typical retail issues are addressed in this book, such as: How can I characterize my customers from the mix of products that they purchase? How can I decide which products to recommend to my customers? How can I categorize my customers and identify new potential customers? This book also describes a data mining method to ensure that the optimum results are obtained. It details for each business issue: - What common data model to use - How to source the data - How to evaluate the model - What data mining technique to use - How to interpret the results - How to deploy the model Business users who want to know the payback on their organization when using the DB2 Intelligent Miner For Data solution should read the sections about the business issues, how to interpret the results, and how to deploy the model in the enterprise. Implementers who want to start using mining techniques should read the sections about how to define the common data model to use, how to source the data, and how to choose the data mining techniques.

IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide! The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide Covers administration, security, SQL, application development, tuning, and much more Contains dozens of expert DB2 tips, techniques and guidelines CD-ROM contains complete DB2 for OS/390 sample exam Written by IBM Gold Consultants for DB2 and S/390 The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments Database administration, security, monitoring, tuning, SQL, and application development Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 exams The CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam. IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam! Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 and z/OS environments is also the only book with the in-depth knowledge professionals need in order to pass IBM's latest DB2 for OS/390DBA certification exam. Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity, development, and much more. IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms. Coverage includes: An overview of the DB2 UDB product family DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities Comprehensive security coverage, including access controls and auditing techniques SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding DB2 UDB administration: maintaining data, backup/recovery, and more Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning Data sharing: architecture and implementation in a Parallel Sysplex environment Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrency Whether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource.

IBM offers a Dense Wavelength Division Multiplexing (DWDM) solution with the IBM Fiber Saver (2029). The IBM 2029 provides data transport capabilities for data center applications such as: -Data center backup and recovery -DASD mirroring -Tape vaulting and remote printing -Geographically Dispersed Parallel Sysplex (GDPS) -LAN interconnectivity -Channel extension -Peer-to-Peer Remote Copy (PPRC) -Storage Area Network (SAN) This IBM Redbooks publication is for technical professionals who are interested in a metropolitan area network (MAN) solution for their data center, using DWDM technology. This document gives a broad understanding of the IBM 2029 architecture and application, and provides information to help plan, implement, configure, and manage an IBM 2029 network. It also contains a discussion on how to design/create a solution to migrate from an IBM 9729 to an IBM 2029. A walkthrough of the commissioning and provisioning process, as well as practical examples for problem determination, are also included.

This IBM Redbooks publication is an update to the successful first edition of Understanding IBM RS/6000 Performance and Sizing, SG24-4810 that was published in 1997. It gives a broad overview of IBM RS/6000 and IBM eServer pSeries performance and sizing. Contained in this book is a close-up, performance related view of the different hardware architectures IBM offers in its RS/6000 and eServer pSeries systems, including system, processor, memory, storage, and network architectures. One chapter is dedicated to general sizing rules for a number of environments such as database sizing, IBM HTTP server sizing, Net.Commerce sizing, and Lotus Domino sizing. The reader will also find a description of the industry benchmarks that are performed on IBM systems as well as an overview of AIX performance tools. This book is intended to be a handbook for anyone who wants to gain a deeper understanding of IBM RS/6000 and IBM eServer pSeries architectures from a performance perspective.

High-value solutions for integrating enterprise and legacy systems XML, Enterprise JavaAPIs, and much more Techniques for building flexible, extensible EIA solutions Easy-to-read, fully-documented code throughout CD-ROM includes leading-edge software and code library for XML/Java integration! "XML is the amazing new web standard for universal data interchange. With this book and XML you can integrate your applications without converting the code!" —Charles F. Goldfarb Integrate your enterprise with XML and Java! Enterprise Application Integration (EAI) links diverse applications, platforms, and operating systems so they work as one-and deliver powerful business results seamlessly. Platform-independent Java is one powerful tool for building EAI applications, and XML adds the missing link: robust mechanisms to exchange data with non-Java applications. Now there's a complete, step-by-step guide to using Java and XML together to deliver enterprise integration solutions that work! Enterprise Application Integration With XML and Java covers all this, and more: Demonstrating why XML is such a powerful EAI infrastructure solution Identifying your key requirements for sharing and exchanging data Building robust, high-performance Java applications for parsing and processing XML documents Moving data between Java and non-Java applications Integrating XML with relational databases Serializing Java objects into XML, and asynchronous messaging with XML Providing convenient references to XML 1.0 grammar and the W3C Document Object Model Whether you're a technical manager planning for enterprise application integration, or a Java developer tasked with delivering it, Enterprise Application Integration With XML and Java delivers the in-depth solutions and real-world expertise you need. CD-ROM INCLUDED The CD-ROM contains extensive source code from the book, plus a remarkable library of leading-edge software and trialware, including: Bluestone Visual-XML desktop XML development environment; IBM XML4J Java-based parser; and Push-technologies SpiritWAVE2 implementation of the Java Messaging Service!

This new release of Communications Server for AIX includes many new features and functions that make CS/AIX a more important player in bridging the e-business gap between the Internet and critical legacy data applications. Support for secure TN3270 communications with SSL and load balancing with SLP are critical in insuring secure and consistent communications with the host. Support for high performance routing, branch network configurations, and channel attachment are significant in that they allow placement of Communications Server anywhere it benefits performance most in the customer's IP or SNA network.

Component Broker is a unique product in the marketplace. It is composed of an industry-leading set of technologies that facilitate the development and deployment of distributed object applications. More specifically, the product is designed to meet the needs of object-oriented programmers responsible for building mission-critical, enterprise-level, transactional application solutions. At its core, Component Broker implements an architecture that defines an object-oriented programming model, an extensible framework supporting the rich composition of business objects from new or existing sources of data, and an integrated set of enterprise-ready object services. These three aspects of the architecture are complemented by an integrated set of application development and assembly tools. Component Broker is packaged with a runtime and systems management component and the Component Broker Toolkit (CBToolkit) that supports application development. This IBM Redbooks publication introduces you to IBM’s Component Broker on System/390. It describes many of the functional aspects and key benefits of the common Component Broker architecture that span multiple platforms. It also examines the specific implementation and business value of Component Broker on the 390 system. System/390, the OS/390 operating system, and the various transactional application execution environments native to the platform have enjoyed a reputation of being one of the most scalable, secure and efficient commercial processing systems in the industry. Component Broker now extends this heritage by bringing the world of object-oriented computing to large-scale business applications. Component Broker is a part of IBM’s WebSphere application server strategy. WebSphere provides customers with a comprehensive solution for developing and deploying networked applications. All WebSphere servers are unified by a common programming architecture that is based on the Enterprise JavaBeans specification. Additionally, Component Broker provides support for the CORBA specification. The ITSO has created a growing library of publications about Component Broker. You can see this library in Appendix , “ ” on page . If after reading this publication you wish to further enhance your knowledge of the general Component Broker architecture, we recommend that you study the IBM Component Broker Overview book (SG24-2022).

This IBM Redbooks publication gives a broad understanding of the new architecture of the Versatile Storage Server (VSS). This book provides an introduction, and describes in detail the architecture, technology, data flow, configuration, migration and recovery aspects for the VSS.

This document is unique in its detailed coverage of the new RPG IV language and aspects of the Integrated Language Environment. The purpose of this document is to provide an introduction to the RPG IV language and guidelines for implementing applications using the Integrated Language Environment. The publication SC41-3606, should be considered a prerequisite to this publication. This document is intended for experienced programmers, analysts, and implementers who are responsible for the creation and maintenance of application programs on the AS/400. It assumes the reader has a fairly good background in the AS/400 programming environment.