IBM InfoSphere Optim Query Capture and Replay 1.1 for Linux, UNIX, and Windows, Part 1, Introduction to OQCR

From the developerWorks archives

Amitava Kundu, Rajesh Sambandhan, Anantanag Bhat, Mangesh Shanbhag, and Sangeeta Ravindran

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=835512
ArticleTitle=IBM InfoSphere Optim Query Capture and Replay 1.1 for Linux, UNIX, and Windows, Part 1: Introduction to OQCR
publish-date=09202012