473,473 Members | 1,842 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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.

Jan 9 '07 #1
2 1155
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

Jan 9 '07 #2
rAinDeEr wrote:
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
Jan 9 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bill Willyerd | last post by:
Is it possible? I have a request to create a stored proc that will dynamically add a range to a WHERE clause based on a numeric value of a comment type. If the incoming comment type request is...
4
by: Bik | last post by:
I'm building a list of customer orders via ASP/VBscript. e.g: 51 John Doe $1,201.50 52 Jane Smith $ 500.00 53 Jim Miller $1,250.25 I want order numbers 51, 52, 53 hyperlinked...
0
by: ray well | last post by:
hi, i shell out a process during my app's run, and then i want to close it when the program ends. i used the following code. it works fine with many files, for example an rtf file. Public...
3
by: Phillip N Rounds | last post by:
What I would like to do is to have a console application on my server started when a user performs a specific action on a web form. Specifically, MyConsoleApp overwrites an existing file with...
16
by: Rex | last post by:
Hi All - I have a question that I think MIGHT be of interest to a number of us developers. I am somewhat new to VIsual Studio 2005 but not new to VB. I am looking for ideas about quick and...
1
by: Psychobudgie | last post by:
Hi, I have written a stored procedure which includes a DATEPART command, i.e. DATEPART(weekday, <date>) The result when ran from SQL Query Analyser is as expected . i.e. Sunday returns 1,...
3
by: Ronald S. Cook | last post by:
I have the following line that I wish to execute from within a C# Console Application. svcutil.exe http://localhost/COWFeedyardService/Services/Animal.svc /out:Animal.vb /config:App.config ...
1
by: rshivaraman | last post by:
Hi All : A couple of tables have been identified to be deleted. My job is to find if it is at all used. On searching the web, i found a proc to search for a string within all databases in a...
16
by: Blubaugh, David A. | last post by:
To All, I was wondering if anyone has come across the issue of not being allowed to have the following within a Python script operating under Linux: time.sleep(0.0125) It appears that I...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.