Find SQL in Stored Procedures

I have 100's of stored procedures running.
is there any way to find that the Stored procedure has raised a
particular sql
and it has been completed its execution ?

re: Find SQL in Stored Procedures

Yes, you can use the SQL Performance Monitors in System i Navigator or the
Database Monitor command to capture a procedure's SQL statements.

swami wrote:--
Kent Milligan
ISV Enablement - System i
kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!!(opinions stated are not necessarily those of my employer)

re: Find SQL in Stored Procedures

swami wrote:Swami,

Which platform?
On DB2 for LUW you can start a STATEMENT event monitor.
It will generate an entry for every SQL statement executed with:
Schemaname, packagename, line-number. The package dependency allows you
to link back to the procedure name.
This is the approach taken by the procedure profiler in Data Studio.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab