IBM InfoSphere Optim Query Capture and Replay 1.1 for Linux, UNIX, and Windows, Part 1, Introduction to OQCR
From the developerWorks archives
Date archived: January 11, 2017 | First published: September 20, 2012
IBM® InfoSphere® Optim™ Query Capture and Replay (IOQCR) 1.1 for Linux®, UNIX® and Windows® enable an organization to create a production-like data application test environment where changes can be tested and tuned before being deployed into production. InfoSphere Optim Query Capture and Replay captures all of the application workload running against a production database and replays it against a test database without the need to replicate the entire application infrastructure. It not only replays both dynamic and static SQL, but also reproduces the number of client connections and their properties, the timing and order of execution, transaction boundaries and isolation levels, and many other critical features of workload execution. The result is a much closer approximation of production workloads and greater confidence that when changes are deployed, they will not disrupt production.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.