Getting Started with IBM InfoSphere Optim Workload Replay for DB2

Getting Started with IBM InfoSphere Optim Workload Replay for DB2

by Whei-Jen Chen, Nisanti Mohanraj, Hassi Norlen, Leif Pedersen, Patrick Titzler, Tom Toomire, John Vonau
Released January 2015
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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.

Table of contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. IBM Redbooks promotions
  4. Preface
    1. Authors
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  5. Chapter 1. Overview
    1. 1.1 Introduction
    2. 1.2 Solution and architecture
      1. 1.2.1 Solution overview
      2. 1.2.2 Product architecture
      3. 1.2.3 Roles and responsibilities
    3. 1.3 About this book
      1. 1.3.1 Recommended reading
  6. Chapter 2. Deployment planning
    1. 2.1 Deployment overview
    2. 2.2 Analyzing deployment requirements
      1. 2.2.1 Analyzing S-TAP deployment requirements
      2. 2.2.2 Analyzing Workload Replay server requirements
    3. 2.3 Planning appliance deployments
      1. 2.3.1 Environment information to collect
      2. 2.3.2 Considerations
    4. 2.4 Planning S-TAP deployments
      1. 2.4.1 Planning DB2 for z/OS deployments
      2. 2.4.2 Planning DB2 for Linux, UNIX, and Windows deployments
    5. 2.5 Planning product validation
    6. 2.6 Planning product adoption
      1. 2.6.1 Assigning Workload Replay server roles
      2. 2.6.2 Restricting access to workloads
  7. Chapter 3. Installing and configuring IBM InfoSphere Optim Workload Replay appliances
    1. 3.1 Overview
    2. 3.2 Accessing the appliance installation media
      1. 3.2.1 Accessing the appliance installation media for InfoSphere Workload Replay for DB2 for z/OS
      2. 3.2.2 Accessing the appliance installation media for InfoSphere Workload Replay for Linux, UNIX, and Windows
    3. 3.3 Installing and configuring the InfoSphere Guardium software
      1. 3.3.1 Installing InfoSphere Guardium
      2. 3.3.2 Configuring InfoSphere Guardium
    4. 3.4 Preparing for the InfoSphere Workload Replay software installation
      1. 3.4.1 Installing the InfoSphere Workload Replay license
      2. 3.4.2 Installing the DB2-to-DB2 policy
      3. 3.4.3 Installing the prerequisite patches
    5. 3.5 Installing a main Workload Replay appliance
      1. 3.5.1 Verifying the installation
      2. 3.5.2 Implementing a main appliance security policy
    6. 3.6 Installing an auxiliary Workload Replay appliance
      1. 3.6.1 Verifying the installation
      2. 3.6.2 Implementing an auxiliary appliance security policy
  8. Chapter 4. IBM InfoSphere Optim Workload Replay for DB2 for z/OS installation and configuration
    1. 4.1 Overview
    2. 4.2 General z/OS setup
      1. 4.2.1 Protected user for S-TAP
      2. 4.2.2 Protected user ID to run the started task for Workload Replay Controller for z/OS (CQZSERV)
      3. 4.2.3 Creating directories in the UNIX System Services file system
      4. 4.2.4 Authority to dynamic LPA
      5. 4.2.5 Authorized program facility (APF) authorization of data sets
    3. 4.3 InfoSphere Workload Replay S-TAP for DB2 for z/OS
      1. 4.3.1 Customize InfoSphere Workload Replay S-TAP for DB2 for z/OS
      2. 4.3.2 Running the installation jobs
    4. 4.4 Workload Replay Controller for DB2 for z/OS (CQZSERV)
      1. 4.4.1 Customizing the CQZSERV started task JCL
      2. 4.4.2 Starting and stopping CQZSERV
    5. 4.5 Enablement of workload capture and replay in the Workload Replay web console
      1. 4.5.1 Managing access to capture and replay actions
  9. Chapter 5. DB2 for Linux, UNIX, and Windows S-TAP installation and configuration
    1. 5.1 Overview
    2. 5.2 Installing S-TAP
      1. 5.2.1 Installing S-TAP using stand-alone installers
      2. 5.2.2 Installing S-TAP by using Guardium Installation Manager
    3. 5.3 Configuring S-TAP to monitor database traffic
      1. 5.3.1 Configuring S-TAP to monitor DB2 instance traffic
      2. 5.3.2 Configuring S-TAP to monitor local DB2 instance traffic on Linux
      3. 5.3.3 Configuring multi-server support
    4. 5.4 Enablement of workload capture and replay in the Workload Replay web console
      1. 5.4.1 Managing access to capture and replay actions
  10. Chapter 6. Capturing and replaying workloads
    1. 6.1 The workload capture and replay workflow
      1. 6.1.1 The basic workload replay steps
      2. 6.1.2 Iterative workload replay steps
    2. 6.2 Planning
      1. 6.2.1 General considerations
      2. 6.2.2 Capturing and replaying in a DB2 for z/OS environment
      3. 6.2.3 Capturing and replaying in a DB2 for Linux, UNIX, and Windows environment
    3. 6.3 Capturing and replaying workloads
      1. 6.3.1 What is captured
      2. 6.3.2 Capturing an SQL workload
      3. 6.3.3 Transforming a captured workload for replaying
      4. 6.3.4 Replaying workloads
      5. 6.3.5 Comparing workloads by creating comparison reports
      6. 6.3.6 How a comparison report is generated
    4. 6.4 Analyzing comparison reports
      1. 6.4.1 The report details
      2. 6.4.2 The replay results report
      3. 6.4.3 The response time report
      4. 6.4.4 Creating a new replay-ready workload from a comparison report
      5. 6.4.5 Exporting workloads for analysis in InfoSphere Optim Query Workload Tuner
    5. 6.5 Moving workloads between servers
      1. 6.5.1 Associated database for an imported workload
      2. 6.5.2 Export and import process
      3. 6.5.3 Using the export feature to archive captured workloads
      4. 6.5.4 Removing exported and imported workload files from the server
  11. Chapter 7. Ongoing operations
    1. 7.1 Access management
      1. 7.1.1 Roles and interfaces
      2. 7.1.2 Configuring account settings
      3. 7.1.3 Creating an account
      4. 7.1.4 Creating a security administrator
      5. 7.1.5 Creating an administrator
      6. 7.1.6 Creating a privileged user
      7. 7.1.7 Creating a user
      8. 7.1.8 Unlocking accounts
      9. 7.1.9 Deleting accounts
      10. 7.1.10 Changing passwords
    2. 7.2 Appliance health monitoring
      1. 7.2.1 Monitoring disk utilization
      2. 7.2.2 Monitoring the connection status of Workload Replay services
      3. 7.2.3 Monitoring CPU utilization
    3. 7.3 S-TAP health monitoring
      1. 7.3.1 Monitoring connection status on DB2 for Linux, UNIX, and Windows database servers
      2. 7.3.2 Monitoring S-TAP health and performance on DB2 for Linux, UNIX, and Windows database servers
      3. 7.3.3 Monitoring the connection status on DB2 for z/OS LPARs
    4. 7.4 Managing alerts
      1. 7.4.1 Enabling the alerting service
    5. 7.5 Backup and recovery
      1. 7.5.1 System backup and restore
      2. 7.5.2 Workload backup and restore
    6. 7.6 Maintenance and upgrades
      1. 7.6.1 Determining the appliance patch level
      2. 7.6.2 Accessing product updates
      3. 7.6.3 Installing maintenance on an appliance
    7. 7.7 Deciding when to start and stop services
      1. 7.7.1 Restarting a Workload Replay appliance
      2. 7.7.2 Associating an auxiliary Workload Replay appliance with a different main Workload Replay appliance
      3. 7.7.3 Enabling and disabling the controller for auxiliary server traces
      4. 7.7.4 When you might need to restart capture manager
  12. Chapter 8. Integration with other tools
    1. 8.1 Integration with Query Workload Tuner
      1. 8.1.1 Exporting SQL from the Workload Replay web console
      2. 8.1.2 Importing SQL workloads into Query Workload Tuner
      3. 8.1.3 Processing imported workloads
    2. 8.2 Integration with other tools
      1. 8.2.1 Exporting SQL for analysis with third-party tools
      2. 8.2.2 Invoking external tools before workload capture or replay
  13. Chapter 9. Troubleshooting
    1. 9.1 Troubleshooting SQL capture and replay issues
      1. 9.1.1 SQL capture or replay fails to start with an error
      2. 9.1.2 No SQL is collected during SQL capture or replay
      3. 9.1.3 Not all expected SQL is collected during SQL capture or replay
      4. 9.1.4 Replay is slow to progress or appears to be stuck
    2. 9.2 Resolving Workload Replay connectivity issues
      1. 9.2.1 Resolving Workload Replay web console connectivity issues
      2. 9.2.2 Resolving Guardium web console connectivity issues
      3. 9.2.3 Resolving CLI connectivity issues
    3. 9.3 Resolving S-TAP issues for a DB2 for Linux, UNIX, and Windows environment
      1. 9.3.1 Connectivity issues
      2. 9.3.2 S-TAP buffer overflow errors
    4. 9.4 Collecting diagnostic information for IBM support
      1. 9.4.1 Collecting must_gather diagnostic information
      2. 9.4.2 Collecting problem-specific trace files
      3. 9.4.3 Collecting SLON traces by using the diag utility
      4. 9.4.4 Collecting z/OS specific trace files
      5. 9.4.5 Downloading diagnostic information from an appliance
  14. Appendix A. Worksheets and references
    1. A.1 Electronic installation media access
    2. A.2 Worksheets
    3. A.3 Open port requirements
    4. A.4 Workload Replay artifacts that reside in capture or replay databases or subsystems
  15. Related publications
    1. IBM Redbooks
    2. Online resources
    3. Help from IBM
  16. Back cover
  17. IBM System x Reference Architecture for Hadoop: IBM InfoSphere BigInsights Reference Architecture
    1. Introduction
    2. Business problem and business value
    3. Reference architecture use
    4. Requirements
    5. InfoSphere BigInsights predefined configuration
    6. InfoSphere BigInsights HBase predefined configuration
    7. Deployment considerations
    8. Customizing the predefined configurations
    9. Predefined configuration bill of materials
    10. References
    11. The team who wrote this paper
    12. Now you can become a published author, too!
    13. Stay connected to IBM Redbooks
  18. Notices
    1. Trademarks

Product information

  • Title: Getting Started with IBM InfoSphere Optim Workload Replay for DB2
  • Author(s): Whei-Jen Chen, Nisanti Mohanraj, Hassi Norlen, Leif Pedersen, Patrick Titzler, Tom Toomire, John Vonau
  • Release date: January 2015
  • Publisher(s): IBM Redbooks
  • ISBN: None