On Feb 19, 7:53*pm, Lew <seth...@yahoo.comwrote:
Hi,
I'm looking for a tool that can capture all the sql transactions for a
period of time (24 hours or so ) from our production server and replay
it exactly as entered on our performance tuning server. *Does anyone
know of such a tool from IBM or another vendor?
Thanks.
Lew
In DB2 LUW Version 9.5 the audit capability can help for this (a
"tool" can be build with).
See the Information Center
https://publib.boulder.ibm.com/infoc...v9r5/index.jsp
Execute audit:
"The EXECUTE category for auditing SQL statements
The EXECUTE category allows you to accurately track the SQL statements
a user issues (prior to Version 9.5, you had to use the CONTEXT
category to find this information).
This EXECUTE category captures the SQL statement text as well as the
compilation environment and other values that are needed to replay the
statement at a later date.
" ...
Bernard Dhooghe