zOs/SQL/PDBGENSU

select *
    from rr2xx.tstat_general
    WHERE subsystem_id = 'DOF2'
    and INTERVAL_TSTAMP  between '2012-01-19-00.00.00'
                             and '2012-01-20-00.00.00'
    order by INTERVAL_TSTAMP desc
;;;
set current path = 'OA1P';
select *
    from rr2xx.tacct_program
    WHERE PCK_ID = 'YSUDCFC'
         and plan_name = 'WC0217' -- and subsystem_id = 'DOF2'
         and timestamp between '2012-01-19-00.00.00'
                           and '2012-01-20-00.00.00'
    order by class7_elapsed desc
    with ur
    ;
select fosfmte7(class1_elapsed) c1ela
      ,fosfmte7(class3_global_cont) "gloCon"
      ,fosfmte7(class3_page_latch) "pgLat"
      , g.*
    from rr2xx.tacct_general g
    WHERE --PCK_ID = 'YSUDCFC' and
          plan_name = 'WC0217' -- and subsystem_id = 'DOF2'
         and timestamp between '2012-01-19-00.00.00'
                           and '2012-01-20-00.00.00'
    order by class1_elapsed desc
    with ur
;;;
select *
    from rr2xx.tacct_program
    WHERE PCK_ID in('DADSP203'
                   ,'DADSP202'
                   ,'WEBM051'
                   ,'WEBM051N'
                   )
         and plan_name = 'WC0217' and subsystem_id = 'DOF2'
         and timestamp between '2012-01-19-00.00.00'
                           and '2012-01-20-00.00.00'
    order by class7_elapsed desc
    with ur
    ;;;;