zOs/SQL/PDBEOT

    -- abnormal eot pro Monat
SELECT substr(char(trunc_timestamp(timestamp, 'MM')), 1, 10),
--  smallint(max(dayofMonth(timestamp))-min(dayOfMonth(timestamp)) +1)
--        "ma-mi+1",
    smallint(count(distinct date(timestamp))) "#days",
    count(*) "all",
    sum(case when corrid_id like '%WB0670 %' then 1 else 0 end) wb0670,
    sum(case when corrid_id like '%WB0930 %' then 1 else 0 end) wb0930,
    sum(case when corrid_id like '%WC0211 %' then 1 else 0 end) wc0211,
    sum(case when corrid_id like '%WC0214 %' then 1 else 0 end) wc0214
FROM OA1P.TADM65A1
WHERE -- TIMESTAMP > '2010-07-15-00.00.00' and
     event_type = 'A' and ssid like 'DOF%'
group by trunc_timestamp(timestamp, 'MM')
order by 1 desc
with ur
;;
    -- abnormal eot pro Tag
SELECT substr(char(trunc_timestamp(timestamp, 'DD')), 1, 10),
    smallint(max(dayofMonth(timestamp))-min(dayOfMonth(timestamp)) +1)
          "ma-mi+1",
    smallint(count(distinct date(timestamp))) "#days",
    sum(case when corrid_id like '%WB0670 %' then 1 else 0 end) wb0670,
    sum(case when corrid_id like '%WB0930 %' then 1 else 0 end) wb0930,
    sum(case when corrid_id like '%WC0211 %' then 1 else 0 end) wc0211,
    sum(case when corrid_id like '%WC0214 %' then 1 else 0 end) wc0214
FROM OA1P.TADM65A1
WHERE TIMESTAMP > '2010-06-01-00.00.00' and
      event_type = 'A' and ssid like 'DOF%'
group by trunc_timestamp(timestamp, 'DD')
order by 1 desc
with ur
;;
AND SSID LIKE 'DOF%'
AND name like '%WKDBDOF%'
ORDER BY TIMESTAMP DESC
;;
SELECT *
FROM OA1P.TADM60A1
WHERE DATE(TIMESTAMP) between '01.07.2010'
AND '05.08.2010'
AND SSID LIKE 'DOF%'
AND VICTIM_PLAN LIKE 'WB0670%%'
ORDER BY TIMESTAMP DESC