SQL Capture/Replay tool for db2 luw

[Lew]

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

[Madison Pruet]

Re: SQL Capture/Replay tool for db2 luw

Lew wrote:

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?
>

Data Propagator?

Thanks.
>
Lew

[Lew]

Re: SQL Capture/Replay tool for db2 luw

Madison,

I want to be able to capture all the sql statements in some kind of
file that can be replayed over and over again in a performance
environment. This will allow us to tweak various parms and measure
the effect on the database performance. I don't believe that data
propagator can be used in that way.

Lew

[Mark A]

Re: SQL Capture/Replay tool for db2 luw

"Lew" <sethwai@yahoo. comwrote in message
news:c74e9b84-4483-4cbf-80aa-5ba715bb9f25@62 g2000hsn.google groups.com...

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

Q Replication (from IBM). Will handle all DML, but not DDL.

[Bernard Dhooghe]

Re: SQL Capture/Replay tool for db2 luw

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

[Lew]

Re: SQL Capture/Replay tool for db2 luw

Thank you everyone for your ideas. I'll investigate them further.

[Serge Rielau]

Re: SQL Capture/Replay tool for db2 luw

Lew wrote:

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

I have been told that this tool is quite commonly used:

http://www.exact-solutions.com/iwatchsql.asp

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[stavrogin]

Re: SQL Capture/Replay tool for db2 luw

On Feb 25, 6:32 pm, Serge Rielau <srie...@ca.ibm .comwrote:

Lew wrote:

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

>
I have been told that this tool is quite commonly used:http://www.exact-solutions.com/iwatchsql.asp
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

yup ... exact-solutions is developing a new tool to address this very
need. It leverages the iWatch technology but the implementation is
different. The tool is in a beta state presently.