zOs/SQL/DEADLOCK

select *                                                                00001009
    from oa1a.tadm60a1                                                  00002009
    where timestamp > '2010-12-01-00.00.00'                             00003009
          and name like '%FI04A1T%'                                     00004009
;;                                                                      00005009
select date(timestamp), count(*) "total dead/timeout"                   00010006
     , sum(case when reason_code = '00C900BA' then 1 else 0 end)        00011004
            "drainTimeout"                                              00012001
     , sum(case when reason_code = '00C9008E' then 1 else 0 end)        00013004
            "lockTimeout"                                               00014003
     , sum(case when reason_code = '00C90088' then 1 else 0 end)        00015005
            "deadlock"                                                  00016005
    from oa1p.tadm60a1                                                  00020000
    where timestamp > '2009-01-01-00.00.00'                             00030008
          and ssid like 'DOF%'                                          00040000
    group by date(timestamp)                                            00050006
    order by date(timestamp) desc                                       00060007
    with ur                                                             00070000