zOs/SQL/PDBGENBX

set current path = oa1p;
select time(timestamp - class1_elapsed seconds) von, timestamp,
       SUBSYSTEM_ID subS,
       fosfmte7(class3_db_IO / class3_Log_wrt_IO) "db/log",
       fosfmte7(class3_db_IO) db_io , fosFmte7(class3_Log_wrt_IO) logIO,
       g.*
    from RZ2MM.TACCT_GENERAL g
    where    corrName like 'BXT64%'
         and timestamp between '2011-12-01-00.00.00'
                           and '2011-12-02-00.00.00'
         and subsystem_id like 'DOF%'
         and class3_Log_wrt_IO > 0
         and plan_name = 'DSNUTIL'
  --     and class2_elapsed > 600
    order by class2_elapsed desc
    WITH UR
;x;
select count(*), sum(occurrences), sum(class2_elapsed),
       sum(class3_db_IO) / sum(class3_Log_wrt_IO) "db/log",
       sum(class3_db_IO) dbio, sum(class3_Log_wrt_IO) "log",
       timestamp
    from RZ2HH.TACCT_GENERAL g
    where -- corrName like 'BXT64%'
             timestamp between '2011-12-01-00.00.00'
                           and '2011-12-02-00.00.00'
         and subsystem_id like 'DOF%'
         and class3_Log_wrt_IO > 0
  --     and plan_name = 'DSNUTIL'
  --     and class2_elapsed > 600
    group by timestamp
    order by timestamp      desc
    WITH UR
;x;
select *
    from RZ2DD.TACCT_GENERAL g
    where corrName like 'BXT64%'
         and timestamp between '2010-05-31-00.00.00'
                           and '2012-10-01-09.00.00'
         and subsystem_id like 'DOF%'
         and plan_name = 'DSNUTIL'
         and class2_elapsed > 600
    order by class2_elapsed desc
    WITH UR
;x;
select *
    from RZ2DD.TACCT_GENERAL g
    where corrName like 'BXT6431P%'
         and plan_name = 'DSNUTIL'
         and timestamp > current timestamp - 1  year
    order by class2_elapsed desc
    with ur
;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
;