InfoSphere Optim Query Capture and Replay for DB2 on z/OS

Realistic testing scenarios

• Provides a common collector to capture inbound and outbound database traffic for individual subsystems or for data-sharing groups in a sysplex.
• Integrates with DB2 Cloning Tool for z/OS to allow you to quickly create a clone from production for the target test environment.
• Integrates with InfoSphere Optim Test Data Management Solution for z/OS and InfoSphere Optim Data Masking for System z' to help you generate test databases for targeted test scenarios and use masking routines to de-identify data for data privacy. Allows you to vary the speed of replay to study workload scalability, potential I/O issues or locking problems.

Change impact reports

• Provides reports to help you investigate how changes to the data server environment impact workload replay accuracy and performance.
• Offers SQL and transaction reports to help highlight performance differences between two workload executions.Supports “what if” analyses to help you test different deployment options such as comparing capture workloads to replay workloads or comparing replay workloads to alternative replay workloads.

Deployment testing beyond DB2 for z/OS

• Lets you test hardware change scenarios such as system upgrades, Netezza installations or processor capacity increases.
• Allows you to analyze software upgrades or changes such as maintenance applications to z/OS,workload reassignments between z/OS and Linux on System z, or application changes.
• Lets you conduct trial runs of workload capacity changes such as an increased transaction stream in IBM Information Management System or CICS.
• Helps you support for new application rollouts such as CRM or SCM systems or WebSphere.