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...