zOs/SQL/PDBGENWB

set current path = 'OA1P';
select min(timestamp),
       fosFmte7(sum(class1_elapsed)) "c1Elaps",
       fosFmte7(sum(class2_elapsed)) "c2Elaps",
       fosFmte7(sum(class1_CPU_total)) "c1Cpu",
       fosFmte7(sum(class2_CPU_total)) "c2Cpu",
       fosFmte7(sum(CLASS1_SU_CPU   )) "c1SU",
       fosFmte7(sum(CLASS2_SU_CPU   )) "c2SU",
       fosFmte7(sum(CLASS3_DB_IO)) "dbIO",
       fosFmte7(sum(class3_LOG_WRT_IO)) "logIO",
       fosFmte7(sum(CLASS3_LOCK_LATCH)) "lockLat",
       fosFmte7(sum(CLASS3_SYNC_IO)) "syncIo",
       fosFmte7(sum(commit  )) "commit",
       fosFmte7(sum(deadlock)) "deadlock",
       fosFmte7(sum(timeout)) "timeout",
       fosFmte7(sum(occurrences)) occ,
       fosFmtE7(sum(select)) sel,
       fosFmtE7(sum(open)) open,
       fosFmtE7(sum(fetch)) fetch,
       fosFmtE7(sum(insert)) ins,
       fosFmtE7(sum(update)) upd,
       fosFmtE7(sum(delete)) del
    from RZ2DD.TACCT_GENERAL g
    where plan_name = 'WB0640'
         and timestamp >       '2010-01-01-00.00.00'
         group by trunc_timestamp(timestamp, 'MON')
            --         and     '2010-07-31-20.00.00'
    order by 1 desc
;x;
select class2_elapsed,
    smallInt(1000* class2_cpu_total     /class2_elapsed) cpu,
    smallInt(1000* class3_global_cont  /class2_elapsed) "gloCon",
select timestamp,
       fosFmte7(class1_elapsed) "c1Elaps",
       fosFmte7(class2_elapsed) "c2Elaps",
       fosFmte7(class2_CPU_total) "c2Cpu",
       fosFmte7(CLASS3_ARCH_LOG
               +CLASS3_ARCH_READS
               +CLASS3_ASYNCH_IXL
               +CLASS3_CLAIM_REL
               +CLASS3_DB_IO
               +CLASS3_DRAIN_LOCK
               +CLASS3_EXT_DEL_DEF
               +CLASS3_FORCE_AT_C
               +CLASS3_LLOCK_CHILD
               +CLASS3_LLOCK_OTHER
               +CLASS3_LLOCK_PARNT
               +CLASS3_LOCK_LATCH
               +CLASS3_LOG_WRT_IO
               +CLASS3_NOTIFY_MSG
               +CLASS3_OPEN_CLOSE
               +CLASS3_PAGE_LATCH
               +CLASS3_PLOCK_OTHER
               +CLASS3_PLOCK_PAGE
               +CLASS3_PLOCK_PSET
               +CLASS3_SCHEDUL_UDF
               +CLASS3_SCHED_STPRC
               +CLASS3_SERV_TASK
               +CLASS3_SYNC_IO
               +CLASS3_SYSLOGR_REC
               +CLASS3_UPD_COMMIT
               )                "c3",
       fosFmte7(CLASS3_OTHER_READ
               +CLASS3_OTHER_SERV
               +CLASS3_OTHER_WRITE
               +CLASS3_GLOBAL_CONT
               )                "c3Other",
       fosFmte7(CLASS3_LOCK_LATCH + CLASS3_SYNC_IO) ,
       fosFmte7(CLASS3_DB_IO      + CLASS3_LOG_WRT_IO) ,
       g.*
    from RZ2DD.TACCT_GENERAL g
    where plan_name = 'WB0640'
         and timestamp >       '2011-01-01-00.00.00'
            --         and     '2010-07-31-20.00.00'
    order by timestamp 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
;