zOs/SQL/PDBGENNZ

select class2_elapsed / max(1, commit + rollback)
     , g.*
    from RZ2xx.TACCT_GENERAL g
    where plan_name in ('VZ56C'
                       ,'VZ52C'
                       ,'NTA1P'
                       )
        and class1_elapsed > 100
        and timestamp between '2012-06-03-20:48:00.36'
                          and '2012-06-03-23.10.35.53'
    order by timestamp
;x;
select hour(timestamp)      , count(*),
        sum(class1_elapsed) "c1ela",
        sum(class1_cpu_total) "c1cpu",
        sum(class2_elapsed) "c2ela",
        sum(class2_cpu_total) "c2cpu",
        sum(select+open+fetch+insert+update+delete) "stmts",
        sum(occurrences) occ
    from RZ2hh.TACCT_GENERAL g
    where corrName in ('NZ20', 'VZ52')
        and timestamp >=      '2012-05-24-00.00.00'
    group by hour(timestamp)
    order by 3 desc
;x;
select trunc_timestamp(timestamp, 'DD'),
       int(sum(select             )) sel,
       int(sum(RID_POOL_USED      )) ridUsed,
       int(sum(RID_POOL_FAIL_NOSG )) ridFaiSG,
       int(sum(RID_POOL_FAIL_MXLT )) ridFaiMX
    from RR2DD.TACCT_GENERAL g
    where plan_name = 'NZ5820'
         and timestamp >       '2012-05-17-00.00.00'
    group by trunc_timestamp(timestamp, 'DD')
    order by 1         desc
;x;
select class2_elapsed,
    smallInt(1000* class2_cpu_total     /class2_elapsed) cpu,
    smallInt(1000* class3_global_cont  /class2_elapsed) "gloCon",
    smallInt(1000* class3_DB_IO        /class2_elapsed) "db io",
    smallInt(1000* class3_LOG_WRT_IO   /class2_elapsed) "logIO",
    smallInt(1000* (class2_cpu_total
                 + class3_global_cont
                 + class3_DB_IO
                 + class3_LOG_WRT_IO ) /class2_elapsed) "sum",
        g.*
    from RZ2XX.TACCT_GENERAL g
    where timestamp > trunc_timestamp(current timestamp - 1 DAY, 'DD')
   --     and connect_id like 'MFT5614P%'
          and connect_id like 'TNT780%'
          and plan_name in ('TN7080')
   --     and insert >= 1
    ORDER BY timestamp      desc
  --ORDER BY CLASS1_ELAPSED desc
    with ur
;
X
select insert, class2_elapsed / insert , class2_su_cpu / insert,
        g.*
    from RZ2XX.TACCT_GENERAL g
    where timestamp > current timestamp - 9 DAY
          and plan_name = 'RB5000'
          and insert >= 1
    ORDER BY Timestamp asc
;
X
select class2_elapsed / insert , class2_su_cpu / insert,
        g.*
    from RZ2XX.TACCT_GENERAL g
--  where timestamp > current timestamp - 1 month
    where timestamp IN ('2010-02-02-01.05.50.881483'
                       ,'2010-01-30-06.38.00.929757')
          and plan_name = 'BE5020'
          and  insert > 500000 -- class2_elapsed >= 1000
    order by 1 desc, class2_elapsed desc
;
select -- class2_elapsed / insert , class2_su_cpu / insert,
        g.*
    from RZ2XX.TACCT_GENERAL g
    where timestamp > current timestamp - 5 DAY
          and plan_name = 'RB5000'
    ORDER BY Timestamp asc
;
X
select min(timestamp), max(timestamp)
    from RZ2XX.TACCT_GENERAL g
    with ur
;