Find SQL in Stored Procedures

[swami]

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 ?

[Kent Milligan]

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:

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 ?

--
Kent Milligan
ISV Enablement - System i
kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!!

>>ibm.com/iseries/db2

(opinions stated are not necessarily those of my employer)

[Serge Rielau]

Re: Find SQL in Stored Procedures

swami wrote:

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 ?

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