zOs/SQL/PDBGENTN

select timestamp, connect_id, commit,
        class2_elapsed/max(1, commit) "ela/com",
        class1_elapsed, class2_elapsed,
        class2_cpu_total,
        update, select, open, fetch,
    g.*
    from RZ2dd.TACCT_GENERAL g
    where timestamp > '2011-05-01-00.00.00'
      and plan_name in ('TN7080','TN8110')
    order by timestamp desc
    with ur
;;;
select *
    from RZ2xx.TACCT_GENERAL g
    where plan_name in ('TN7080','TN8110')
    order by timestamp desc
    with ur
;;;
select trunc_timestamp(timestamp, 'IW'),
       sum(class2_elapsed    ) / sum(select+open+fetch) "ela/sof",
       sum(class2_cpu_total  ) / sum(select+open+fetch) "cpu/sof",
       sum(select+open+fetch) "sof",
       sum(class2_elapsed    ) ela,
       sum(class1_cpu_total  ) "c1Cpu",
       sum(class2_cpu_total  ) "c2Cpu",
       sum(class3_global_cont) "gloCon",
       sum(class3_DB_IO      ) "db io",
       sum(select            ) "sel",
       sum(open              ) "open",
       sum(fetch             ) "fetch",
       sum(SUSPEND_IRLM_CONT  ) "irmlCont",
       sum(SUSPEND_XES_CONT  ) "xesCont"  ,
       sum(SUSPEND_FALSE_CONT  ) "falseCont"
    from RZ2dd.TACCT_GENERAL g
    where timestamp >= '2009-09-01-00.00.00'
   --     and connect_id like 'MFT5614P%'
          and connect_id like 'TNT780%'
          and plan_name in ('TN7080')
   --     and insert >= 1
    group by trunc_timestamp(timestamp, 'IW')
    ORDER BY 1 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
;