By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

URGENT SQL help

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.