zOs/SQL/PDBGENPK

--    vergleich tacct_general und tacct_package total Zahlen
--
--
set current path = oa1p;
with g as
  (
  SELECT DATE(TIMESTAMP) AS DATUM
        ,SUM(SELECT+INSERT+UPDATE+delete+open+fetch+close) as mdl
        ,SUM(CLASS2_su_cpu) C2_SU
        ,SUM(CLASS2_su_cpu) /
         SUM(SELECT+INSERT+UPDATE+delete+open+fetch+close) as su_st
        ,sum(CLASS2_CPU_TOTAL) C2_CPU
    FROM RZ2DD.TACCT_GENERAL
      WHERE TIMESTAMP >= '2012-03-01-00.00.00.000000'
        AND GROUP_NAME = 'DBOF'
    GROUP BY DATE(TIMESTAMP)
  ) , p as
  (
    SELECT DATE(TIMESTAMP) AS DATUM
          ,SUM(SQL_STMTS_ISSUED) AS ANZ_SQL
          ,SUM(CLASS7_SU_CPU) AS SU_CLASS7
          ,SUM(CLASS7_SU_CPU)/SUM(SQL_STMTS_ISSUED) as su_st_p
          ,sum(CLASS7_CPU_TOTAL) as CPU_C7
      FROM RZ2DD.TACCT_PROGRAM
        WHERE TIMESTAMP >= '2012-03-01-00.00.00.000000'
          AND GROUP_NAME = 'DBOF'
      GROUP BY DATE(TIMESTAMP)
  )
  select coalesce (p.datum, g.datum) datum
        ,substr(fosFmte7(C2_CPU), 1, 7) c2_cpu
        ,substr(fosFmte7(CPU_C7), 1, 7) c7_cpu
        ,substr(fosFmte7(C2_SU), 1, 7) c2_su
        ,substr(fosFmte7(SU_CLASS7), 1, 7) c7_su
        ,substr(fosFmte7(mdl), 1, 7) gen_st
        ,substr(fosFmte7(anz_sql), 1, 7) pg_st
        ,substr(fosFmte7(C2_SU/mdl), 1, 7) gen_su_st
        ,substr(fosFmte7(SU_CLASS7/anz_sql), 1, 7) pg_su_st

   from g full join p
     on p.datum = g.datum
    ORDER BY 1 DESC
;;;;;;;
  SELECT DATE(TIMESTAMP) AS DATUM
        ,DEC(SUM(SELECT)) AS SELECT
        ,DEC(SUM(INSERT)) AS INSERT
        ,DEC(SUM(CLASS2_CPU_TOTAL)) SUM_CLASS2
    FROM RZ1DD.TACCT_GENERAL
      WHERE TIMESTAMP >= '2012-04-01-00.00.00.000000'
        AND GROUP_NAME = 'DBAF'
    GROUP BY DATE(TIMESTAMP)
    ORDER BY DATE(TIMESTAMP) DESC
  ;