zOs/SQL/PDBGENCT

select *
    from RZ2HH.TACCT_GENERAL g
    where timestamp >  current timestamp  - 3 days
          and plan_name like 'CZ0580%'
        order by class2_cpu_total desc
 ;x;
select         timestamp ,
      int(sum(occurrences))   "occ",
      dec(sum(class2_elapsed)/sum(occurrences),5,2) "c2ela/occ",
      dec(sum(select+open+fetch+insert+update+delete)/sum(occurrences)
                                ,5,2)          "sopiud/occ",
          sum(class2_elapsed) "c2ela",
          sum(class2_cpu_total) "c2cpu",
          sum(class3_global_cont) "c2gloCon",
          sum(class3_DB_IO) "c3dbIo",
          sum(class3_LOG_WRT_IO) "c2logIo",
          sum(OPEN_CLOSE_SUSP) "opClo",
          sum(CLASS3_OPEN_CLOSE) "c3opClo",
          sum(SERV_TASK_SUSP) "serTa",
          sum(CLASS3_SERV_TASK) "c3serTa",
          sum(select)        "select",
          sum(open )         "open",
          sum(fetch )        "fetch",
          sum(insert)        "insert",
          sum(update)        "update",
          sum(delete)        "delete"
    from RZ2HH.TACCT_GENERAL g
    where timestamp > trunc_timestamp(current timestamp - 15 DAY, 'DD')
   -- and timestamp > '2010-05-11-17.00.00'
   --     and connect_id like 'MFT5614P%'
   --     and corrname like 'MFT5614P'
          and plan_name like 'CZ0580%'
   --     and insert >= 1
    group by timestamp
    ORDER BY timestamp desc
    with ur
;
X
select timestamp, int(sum(occurrences))   "occ",
       dec(sum(class2_elapsed)/sum(occurrences),5,2) "c2ela/occ",
        sum(OPEN_CLOSE_susp) / sum(occurrences) "OCsusp",
       sum(CLASS3_OPEN_CLOSE) / sum(occurrences) "OCtime"
    from RZ2dd.TACCT_GENERAL g
    where timestamp > trunc_timestamp(current timestamp - 99 DAY, 'DD')
          and plan_name like 'CT0790%'
    group BY timestamp
    ORDER BY timestamp 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
;