SQL within a St.proc

Any method to find out which SQL is being executed within a stored
procedure. St.proc has been written using SQL running on V8.2/AIX 5.3.

Application Snapshot only shows the stored procedure call statement and
not which SQL is being executing currently.

Hi,

1.) The first link describes a framework for dynamic C stored procedure
logging

http://www-128.ibm.com/developerwork...dm-0601khatri/

2.) The below tutorial by Serge describes tracing API for SQL procedure

http://www-128.ibm.com/developerwork...dm-0409rielau/

3.) This gives an introduction to the SQL PL Profiler

http://www-128.ibm.com/developerwork...lau/index.html

Thanks...
rAinDeEr

rAinDeEr wrote:

Quote:

3.) This gives an introduction to the SQL PL Profiler
>
http://www-128.ibm.com/developerwork...lau/index.html

This one has been incorporated into both the DB2 Performence Expert ($$)
and Developer Workbench (no $$) :-)

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html

SQL within a St.proc

re: SQL within a St.proc

re: SQL within a St.proc

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about