This IBM® Redbooks® publication will help you install, configure, and use IBM InfoSphere® Optim™ Workload Replay (InfoSphere Workload Replay), a web-based tool that lets you capture real production SQL workload data and then replay the workload data in a pre-production environment. With InfoSphere Workload Replay, you can set up and run realistic tests for enterprise database changes without the need to create a complex client and application infrastructure to mimic your production environment. The publication goes through the steps to install and configure the InfoSphere Workload Replay appliance and related database components for IBM DB2® for Linux, UNIX, and Windows and for DB2 for IBM z/OS®. The capture, replay, and reporting process, including user ID and roles management, is described in detail to quickly get you up and running. Ongoing operations, such as appliance health monitoring, starting and stopping the product, and backup and restore in your day-to-day management of the product, extensive troubleshooting information, and information about how to integrate InfoSphere Workload Replay with other InfoSphere products are covered in separate chapters.

IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of OLTP and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution for the needs of today's organizations; quick access to business answers can be used to gain a competitive edge, lower costs, and more. This IBM Redbooks® publication introduces the concepts of DB2 with BLU Acceleration. It discusses the steps to move from a relational database to using BLU Acceleration, optimizing BLU usage, and deploying BLU into existing analytic solutions today, with an example of IBM Cognos®. This book also describes integration of DB2 with BLU Acceleration into SAP Business Warehouse (SAP BW) and SAP's near-line storage solution on DB2. This publication is intended to be helpful to a wide-ranging audience, including those readers who want to understand the technologies and those who have planning, deployment, and support responsibilities.

IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of online transaction processing (OLTP) and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution for the needs of today's organizations; quick access to business answers can be used to gain a competitive edge, lower costs, and more. This IBM Redbooks® publication introduces the concepts of DB2 with BLU Acceleration. It discusses the steps to move from a relational database to using BLU Acceleration, optimizing BLU usage, and deploying BLU into existing analytic solutions today, with an example of IBM Cognos®. This book also describes integration of DB2 with BLU Acceleration into SAP Business Warehouse (SAP BW) and SAP's near-line storage solution on DB2. This publication is intended to be helpful to a wide-ranging audience, including those readers who want to understand the technologies and readers who have planning, deployment, and support responsibilities.

IBM® DB2® for Linux®, UNIX®, and Windows® has long been known for its technology leadership. The IBM DB2 SQL Skin feature for applications that are compatible with Sybase ASE (IBM DB2 SSacSA), offered in DB2 9.7, provides a revolutionary approach to switch to DB2. The IBM DB2 SSacSA feature is an enablement technology that immediately equips most Sybase ASE applications to run against DB2, usually with little to no up front conversion work required. This approach minimizes the costs and risks of a traditional migration. In this IBM Redbooks® publication, we discuss the considerations and methodology for transitioning from Sybase to DB2 for Linux, UNIX, and Windows, addressing the basic topic areas of data, applications, and administration. We also describe the IBM DB2 SSacSA architecture and give information about the no charge IBM Data Movement Tool that helps you move database objects and data from Sybase to DB2. This book is for anyone who is interested or will be involved in Sybase to DB2 conversion. It contains application enablement and database performance tuning considerations and tips. With this information, you can plan your transition and its requirements in an orderly and cost effective manner.

DB2 Performance Expert (PE) for Multiplatforms V2.2 is a workstation-based performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 PE simplifies DB2 performance management by providing you with the ability to monitor applications, system statistics, and system parameters using a single tool. This IBM Redbooks publication provides an overview of the architecture of DB2 Performance Expert. We highlight key considerations in planning DB2 PE V2.2 for your environment and provide a step-by-step installation and configuration guide We discuss, in detail, the DB2 PE V2.2 functions and features. Recommendations and tips for DB2 performance tuning are also introduced. Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe how the tool can be used to diagnose and resolve these performance problems.

IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creates and maintains additional recovery assets that you can use for intelligent analysis of both DB2 and DB2 Recovery Expert assets to find the most efficient recovery path. DB2 Recovery Expert facilitates the process of rebuilding your database assets, such as tables, indexes, and data, to a specified point-in-time, often without taking the database or the business operations offline. This IBM Redbooks publication shows you how to install and implement DB Recovery Expert and the Fast Backup and Grouper components. It also describes the DB2 Recovery Expert assets and how to manage these assets. In addition, this book explains the summary and detail reports of Log Analysis, including the DPF environment. It shows, in detailed examples, point-in-time recovery and cloning of tables, table spaces, and databases. Please note that the additional material referenced in the text is not available from IBM.

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.

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.

As organizations strive to do more with less, DB2 Universal Database v8.1 on Windows Server 2003 brings unprecedented enterprise-class scalability to 32-bit and 64-bit Intel platforms. Supporting both vertical (scale up) and horizontal (scale out) scaling, DB2 UDB v8.1 represents over a decade of industry proven scalability with both non-clustered and clustered database architectures. This IBM Redbooks publication is designed as an informative guide to scaling DB2 UDB V8.1 with Windows Server 2003. It is intended for database and system administrators who need both an introduction and detailed information on scaling DB2 UDB on Windows Server 2003. We begin with an overview to scalability including the goals, measurements, and common approaches. We introduce the scalability features of DB2 UDB, Windows Server 2003, and the IBM xSeries Servers followed by some design considerations for scaling. We dedicate an entire chapter to running DB2 UDB on 64-bit Windows including installation, configuration, and 64-bit migration techniques. We discuss scaling up and how to leverage large memory support in a 32-bit environments. Finally, we include a chapter on scaling out including adding logical and physical database partitions.