Database cloning is the process by which you create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore. Database cloning is performed frequently by database administrators to provide near-production data for various business needs such as application development, QA testing, and report generation. Traditional methods of cloning a database pose various challenges, including system downtime and degraded system performance during the cloning process. Additionally, a large amount of storage space is required to store each clone. Furthermore, the maintenance overhead can be enormous if each cloned database requires a frequent data refresh. This IBM Redbooks publication describes the process used to create a clone of an IBM DB2 UDB database using FlexClone technology. This book also covers creating a database clone on a disaster recovery site that has replicated data using Data ONTAP SnapMirror technology.

IBM Tivoli Intelligent ThinkDynamic Orchestrator and IBM Tivoli Provisioning Manager help automate the provisioning and orchestration tasks by invoking pre-prepared workflows that perform most of the provisioning and orchestration tasks automatically. This frees up resources to focus on more productive issues, and helps allocate CPU capacity to where it is needed and when it is needed. Workflow and Automation Package management are the single most important success factor in any IBM Tivoli Intelligent ThinkDynamic Orchestrator and IBM Tivoli Provisioning Manager implementation. Understanding and mastering this issue is critical for Independent Software Vendors (ISV) who wish to allow their products to be an integrated part of any IBM Tivoli Intelligent ThinkDynamic Orchestrator and IBM Tivoli Provisioning Manager environment. The primary goal of this IBM Redbooks publication is to support ISVs, Business Partners, Customers, and IBMers in developing and implementing Workflows and Automation Packages to be used for automation purposes by IBM Tivoli Intelligent ThinkDynamic Orchestrator and IBM Tivoli Provisioning Manager. This book is focused on effectively planning, developing, testing, and implementing product, device, or customer specific best practices into the IBM Tivoli Intelligent ThinkDynamic Orchestrator and IBM Tivoli Provisioning Manager engines, in order to automate management processes related to specific system and device implementations. Please note that the additional material referenced in the text is not available from IBM.

IBM System i platform offers many points of integration that support Linux applications leveraging IBM i5/OS applications and data, such as IBM eServer iSeries Access for Linux, IBM i5/OS NetServer with Samba support, and IBM Java Virtual Machine and JTOpen support. Please note that the additional material referenced in the text is not available from IBM.

In this IBM Redbooks publication we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine Analytics and reporting. It extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, InLine Analytics, and intra-warehouse data movement and transformation, on a common platform based on DB2 and WebSphere. The platform pillars are based on the technology of DB2, Rational Data Architect (for physical data modeling only), the SQL Warehousing Tool, Intelligent Miner, DB2 Cube Views, and Alphablox. DWE includes an Eclipse-based design environment, DWE Design Studio, that integrates the DWE products (with the exception of Alphablox and Query Patroller) with a common framework and user interface. The new SQL Warehousing Tool enables visual design of intra-warehouse, table-to-table data flows and control flows using generated SQL. DB2 Alphablox is the tool for developing custom applications with embedded analytics-based visual components. DWE enables faster time-to-value for enterprise analytics, while limiting the number of vendors, tools, skill sets and licenses required.

This IBM Redbooks publication describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use, automated recovery solution that enables database recovery operations with minimal disruption. Its graphical user interface (GUI) provides powerful reporting and automated recovery capabilities for productive database maintenance and high availability. This book is written for an audience of DB2 for z/OS database administrators (DBA). This book gives you an overview of DB2 Recovery Expert for z/OS, its main features, architecture, recovery semantics, and processing flow. It also describes some of the key considerations in choosing a particular topology to address a business requirement. We provide user scenarios with step-by-step approaches to recover single DB2 for z/OS objects, multiple DB2 for z/OS objects, dropped DB2 for z/OS tables, and DB2 for z/OS subsystems using the IBM Recovery Expert for z/OS tool. We discuss backup and recovery in a DB2 for z/OS environment, the types of failures that might occur, the types of recovery that are supported, the types of objects that can be recovered, the elements and tools of recovery, and the recovery flow. We also provide a brief tutorial of the DB2 Recovery Expert for z/OS GUI client and an overview of the schema level repository (SLR) with recommendations for its maintenance. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication helps you install, tailor, and configure Copy Services in open systems environments on the IBM System Storage DS6000 storage server series. It should be read in conjunction with the IBM System Storage DS6000 Series: Architecture and Implementation, SG24-6781. This book gives you the details necessary to configure each of the Copy Services functions in an open systems environment. There is a companion book that supports the configuration of the Copy Services functions in a z/OS environment, IBM System Storage DS6000 Series: Copy Services with System z servers, SG24-6782. This book helps you design and create the storage map and install Copy Services in an open systems environment. This book helps you design and create a new Copy Services installation or to migrate from an existing installation, as well as addresses design functions and changes in terminology from other IBM Copy Services products. We include hints and tips to maximize the effective installation. It also includes a section on System i and an overview of the TotalStorage Productivity Center for Replication.

The IBM Tivoli Change and Configuration Management Database Configuration Discovery and Tracking v1.1 (CDT) is an agentless deep discovery tool that can discover the configuration information of application systems as well as their components and relationships automatically. It also discovers installed hardware and software components in a complex computer server environment and tracks changes to all these components over time. IBM Tivoli CCMDB CDT v1.1 is the core component of the IT Service Management strategy from IBM and fills the role of the Change Management Database for your implementation of ITIL aligned IT processes. This IBM Redbooks publication provides help and recommendations on how to get started deploying Configuration Discovery and Tracking v1.1 and provides step-by-step instructions for setting up and customizing the discovery in your own environment. In addition, it describes the various interfaces that you can use to integrate CDT with your existing IT Service Management processes. The information in this book is intended for IT specialists who design and implement IT Service Management solutions based on IBM Tivoli CCMDB Configuration Discovery and Tracking v1.1.

Typical Microsoft Exchange environments are growing larger and increasingly are managing data and applications critical to a business. This makes backup and restore a greater challenge. Microsoft Volume Shadow Copy Service (VSS) is a way to use the instant copy capabilities of disk storage hardware for faster backup, thereby reducing the time taken for backup as well as reducing the impact which the backup operation has on the Exchange server.

IBM Tivoli Workload Scheduler is an IBM strategic scheduling product that runs on different platforms including the mainframe. The new version of the product, IBM Tivoli Workload Scheduler V8.3, comes with some important enhancements, such as relational database management system (RDBMS) support, new advanced planning system, which allows the definition of plans that span more that 24 hours, removal of framework requirements, new application programming interface (API), Job Scheduling Console enhancements, and so on. This IBM Redbooks publication documents the architecture, deployment, best practices, and migration scenarios for IBM Tivoli Workload Scheduler V8.3 on distributed environment. In addition, we cover IBM Tivoli Workload Scheduler V8.3 security, IBM DB2 and IBM WebSphere considerations, troubleshooting, tuning for performance, application programming interface, and JnextPlan, which has replaced the JnextDay process in this release. Clients and Tivoli professionals who are responsible for installing, administering, maintaining, or using IBM Tivoli Workload Scheduler V8.3 will find this book a major reference.

XML represents a fundamental change in computing. It allows applications to move away from proprietary file and data formats to a world of open data interchange. XML has become ubiquitous not only because of its range of applications, but also because of its ease of use. Although XML solves many problems by providing a standard format for data interchange, some challenges remain. In the real world, applications need reliable services to store, retrieve, and manipulate data. These services have traditionally been offered by DB2 for i5/OS. In this IBM Redbooks publication, we discuss the challenges of representing XML hierarchies in the relational database model. We provide an in-depth explanation of the three most popular approaches to bridge the hierarchy, the relational model dichotomy: Programmatically process the XML documents and map their hierarchy into a relational database. Use database middleware to handle the XML parsing and XML-to-relational database mapping. Use Extensible Stylesheet Language (XSL) Transformation to transform inbound XML documents directly to SQL scripts. We also share best practices and techniques aimed at streamlining the XML and DB2 for i5/OS integration. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication is a study guide for Tivoli Provisioning Manager Express for Software Distribution V4.1 and is aimed at the people who want to get an IBM Professional Certification for this product.

The IBM System i family, which encompasses the IBM AS/400, eServer iSeries, eServer i5, and System i5, has a successful 24-year history of satisfying hundreds of customers' requirements, thanks to its developers. DB2 for i5/OS, also known as DB2 Universal Database for iSeries, is deeply rooted in the architecture and heritage of the AS/400 and its predecessor System/38. The database has undergone significant changes over the years to maintain its competitive advantage including fundamental changes to the structure of the database to compete successfully in the industry. In doing so, IBM Rochester launched a project to re-engineer and redesign important components of the database. The redesigned components were architected using object-oriented design concepts and then implemented using object-oriented implementation techniques. The query optimizer was one of the key components that was redesigned. This IBM Redbooks publication gives a broad understanding of the architectural changes of the database concerning the query optimizer. It explains the following concepts: The architecture of the query optimizer The data access methods used by the query optimizer The Statistics Manager included in V5R2 The feedback message changes of the query optimizer Some performance measurements Changes and enhancements made in V5R4 The objective of this book is to help you minimize any SQL or database performance issues when upgrading to OS/400 V5R2 or V5R3 or to IBM i5/OS V5R4. Prior to reading this book, you should have some knowledge of database performance and query optimization.

This IBM Redbooks publication provides an introduction to the Enterprise Workload Manager (EWLM) Version 2 Release 1. In addition to describing the overall product concept and functionality, it presents a detailed discussion of the elements that comprise an EWLM solution. Step-by-step instructions take you through the installation of EWLM code on multiple platforms, for both the domain manager and managed servers, and also show how to enable the instrumentation of the middleware for a 3-tier Web application. The features for administering EWLM are described, along with the monitoring, managing, and reporting capabilities. Sample scenarios implemented in the ITSO environment are used to guide you through the process of classifying workload and defining and deploying your own EWLM policy. These scenarios are then used to demonstrate the business goal based partition management capabilities of EWLM. Techniques for securing your EWLM domain as well as the load balancing capabilities of EWLM are described. Troubleshooting hints and tips are provided, along with some basic performance considerations to help you design the optimum EWLM solution. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication introduces the IBM Problem Determination and Deployment Tools for z/OS and OS/390. The tools covered are: -> IBM Application Performance Analyzer for z/OS Version 1 Release 1 This comprehensive suite of powerful yet easy-to-use tools helps developers to efficiently build, test, and service applications while minimizing errors and increasing cost-effectiveness. The tools allow users to quickly identify and resolve problems that occur in batch, IMS, DB2, CICS, and UNIX System Services applications. For each tool, this book provides step-by-step instructions for installation and customization, a detailed discussion of the features and capabilities, and guidance for using the tool in your environment.

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. TotalStorage Productivity Center V3.1 is a rewrite of previous versions. This IBM Redbooks publication shows you how to access the functions as compared to the previous releases. This book 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. It describes the hardware and software environment required and provides a step- by-step installation procedure. Customization and usage hints and tips are also provided.

Identity and user lifecycle management projects are being deployed more and more frequently - and demand is growing. By demonstrating how IBM Tivoli Identity Manager can be made resilient and adapted to special functional requirements, this IBM Redbooks publication creates or enhances confidence in the IBM Tivoli Identity Manager-based solution for senior management, architects, and security administrators. Advanced design topics can start with infrastructure availability for all involved components, Web application, and database server clustering as well as LDAP multi-master setups, continuing with compliance challenges addressing enhanced auditing and reporting, and designing and creating your own self-care/self-registration application environment that embraces external users and business partners offering fine-tuned workflow options and lifecycle management capabilities. The powerful features and extensions of IBM Tivoli Identity Manager are opening doors into a world of advanced design and customization for every identity management challenge you might encounter. Please note that the additional material referenced in the text is not available from IBM.

In this IBM Redbooks publication, we describe and demonstrate how to implement enterprise performance insight. This is an initiative that has a primary focus on the integration of Business Process Management and Business Intelligence. With this capability, management has an enterprise-wide view of their business that can enable proactive business management. We discuss the techniques, architectures, and processes used to define and implement such an environment. Among the specific techniques and technologies used are key performance indicators, process alerts, management dashboards, analytic applications, application integration, process modeling and monitoring, and real-time business intelligence. The products featured are DB2 UDB, DB2 Alphablox, WebSphere Information Integrator, WebSphere Portal, WebSphere Business Monitor, and WebSphere Business Modeler. Performance insight is an element of a more global initiative called business innovation and optimization (BIO). With this, we can enable business performance management, an initiative for the effective use of people, processes, assets, and technology to proactively achieve business goals and measurements. It enables strategic alignment of business and technology, resulting in real-time access to data and continuous process and data flow, for proactive business management, and business goal attainment.

IBM, the leader in collaboration, has created IBM Workplace Collaboration Services, a completely integrated collaborative environment based on open standards. 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 such capabilities as e-mail, calendaring and scheduling, presence awareness, instant messaging, e-learning, team spaces, Web conferencing, and document and Web content management. The integrated design of the IBM System i5 platform provides a low-cost, low-maintenance computing system for Workplace solutions. The System i5 platform, which employs the latest implementation of Power Architecture, advances IBM eServer iSeries integration, simplicity, and low total cost of ownership to record-setting levels. You magnify the benefits of IBM Workplace Collaboration Services by hosting it on the System i5 platform. This IBM Redbooks publication is written for administrators who want to install, configure, and administer IBM Workplace Collaboration Services on the System i5 platform. It introduces you to Workplace Collaboration Services. It shows you how to deploy and customize it on the System i5 platform as well as how to configure the IBM Workplace Managed Client. In addition, this book provides many performance tips to help you optimize your Workplace Collaboration Services environment. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbook focuses on the technology, serviceability, and features that are used by the IBM eServer p5 and IBM System p5 servers, which allow you to make your server one of the most reliable and available parts of your IT infrastructure.

This IBM Redbooks publication introduces the features and capabilities of SnapMirror, and describes how SnapMirror technology can be used in an IBM System Storage N Series environment to achieve enterprise data protection.