MS SQL Profiler equivalent in DB2 8.2?

What is the MS SQL Profiler equivalent in DB2 8.2?

Thank you

re: MS SQL Profiler equivalent in DB2 8.2?

1. DB2 Snapshot Monitor
2. DB2 Event Monitor
3. DB2 Health Center/Monitor
4. DB2 Performance Expert (graphical GUI that is extra license)

Larry Edelstein

serge wrote:[color=blue]
> What is the MS SQL Profiler equivalent in DB2 8.2?
>
> Thank you
>
>[/color]

re: MS SQL Profiler equivalent in DB2 8.2?

serge wrote:[color=blue]
> What is the MS SQL Profiler equivalent in DB2 8.2?
>
> Thank you
>
>[/color]
What does the MS SQL Profiler do?

DB2 provides explains (optimizer plan), so called snapshots and event
monitor data.
If you check for "Rielau" on www.ibm.com you will find
an SQL Procedure tracer and SQL procedure profiler for download.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

re: MS SQL Profiler equivalent in DB2 8.2?

serge wrote:[color=blue]
> What is the MS SQL Profiler equivalent in DB2 8.2?
>
> Thank you
>
>[/color]
You want the Query Patroller. It's somewhat equivalent to SQL-Profiler,
but unfortunately not included with the base db software.

http://www-306.ibm.com/software/data...uerypatroller/

Ask your rep to get you a copy to evaluate before purchasing.