zOs/SQL/PDBGENPR

select * -- corrName, min(timestamp), max(timestamp), count(*)
    from RZ1xx.TACCT_GENERAL g
    where      plan_Name = 'PVPOSY'
        and  subsystem_id like 'DAF%'
        and  timestamp between '2010-11-14-00.00.19.176317'
                           and '2010-11-17-19.55.21.911467'
 --   group by corrName
 --   order by corrName
;x;
select *
    from RZ1dd.TACCT_GENERAL g
    where      corrName = 'PVABRUFA'
   --   and  subsystem_id like 'DAF%'
        and  timestamp between '2010-09-01-00.00.19.176317'
                           and '2011-09-07-19.55.21.911467'
    order by timestamp
;x;
           ) and
       --    subsystem_id like 'DAF%'
             timestamp between '2010-09-06-13.40.19.176317'
                           and '2011-09-09-18.49.21.911467'
select *
    from RZ1xx.TACCT_GENERAL g
    where -- (   corrName like 'A343905%'
        -- and  plan_name like 'PVPOS%'
        --   ) and
       --    subsystem_id like 'DAF%'
             timestamp =       '2010-09-07-14.11.54.964347'
;x;
             timestamp between '2010-09-06-13.40.19.176317'
                           and '2011-09-09-18.49.21.911467'
SELECT  *
    FROM RZ1XX.TACCT_PROGRAM
    where    timestamp between '2010-09-07-14.00.00'
                           and '2010-09-07-15.55.00'
    AND PCK_ID   like 'A5PO356%'
;x;
select *
    from RZ1xx.TACCT_GENERAL g
    where  (   corrName like 'PVABRUFA'
         and  plan_name like 'PVPOS%'
           ) and
       --    subsystem_id like 'DAF%'
             timestamp between '2010-09-06-13.40.19.176317'
                           and '2011-09-09-18.49.21.911467'
 -- order by corrname
    order by class1_elapsed desc
;x;
select *
    from RZ1xx.TACCT_GENERAL g
    where   timestamp in ( '2010-09-07-14.35.31.976691',
                           '2010-09-07-14.39.19.176317',
                           '2010-09-07-14.39.21.911467')
;x;
SELECT  *
    FROM RZ1XX.TACCT_PROGRAM
    where    timestamp between '2010-09-07-14.00.00'
                           and '2010-09-07-15.33.00'
    AND PCK_ID   like 'A5PO%'
;x;
             or plan_name like 'PVPO%')
         and subsystem_id = 'DAF1'
         and timestamp between '2010-09-07-14.00.00'
                           and '2010-09-07-15.33.00'
 -- order by corrname
    order by class1_elapsed 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
;