467,199 Members | 970 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

URGENT SQL help

SKC
Hi

I have already specnt many hrs in getting these resultsets but no
success....can anyone help me out please?

I need urgent help to retrive the data in the following format:

Table 1 :

Col1 : PACKAGE --> PACKAGE NAME
Col2 : START_TIME (TIMESTAMP) --> START TIME
Col3 : END_TIME (TIMESTAMP) --> END TIME

NOTE : Each package will be called many times during an interval.

Table 2 : SYSCAT.PROCEDURE (to extract procedure name)

Expected Results:
==================
Result 1:
---------
PROCNAME, PACKAGENAME, SUM_OF_EXECUTION_TIME, TOTAL_NO_EXECUTIONS.

for every 10 minutes OR 5 minutes OR n minutes given a time interval
like "BETWEEN 10 AM AND 12 NOON).

Result 2:
---------

Same as above but for WHOLE duration....ONE result set (NOT for every
10 mins or 5 mins etc..).

Result 3:
---------

PACKAGE EXECUTION TIME FOR EVERY 10mins OR 5 Mins OR every 'n' minutes
like bellow:

PROCNAME, PACKAGE, 10MIN, 20MIN, 30MIN, 40MIN, 50MIN, 60MIN, 70MIN,
80MIN

Result 4:
---------

Same as Result 3 but for NO. OF EXECUTIONS for every 10
mins/5mins/nmins...

Thanks in advance...
Nov 12 '05 #1
  • viewed: 1113
Share:
2 Replies
Looks like you want to take a look at the statement event monitor.
Check out my recent articles on developerWorks/DB2.
Especially the SQL PL Profiler mines the event monitor output and can
serve you as a guide.

Cheers
Serge
Nov 12 '05 #2
SKC
Serge Rielau,

Thanks for your suggestion. I read your article and found that it is
usefull for version 8 & STINGER.

I am using version 7.2.

Presently, I am getting this report using shellscript. I am interested
to know the better way of extracting these reports especially using
SQL.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Stefan Bauer | last post: by
8 posts views Thread by Tim::.. | last post: by
16 posts views Thread by | last post: by
7 posts views Thread by zeyais@gmail.com | last post: by
33 posts views Thread by dembla | last post: by
8 posts views Thread by ginnisharma1@gmail.com | last post: by
17 posts views Thread by Saps | last post: by
3 posts views Thread by N. Spiker | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.