zOs/SQL/EXPLAING

--- versionen, compiles und explains eines packages -------------------
select *
    from cmnbatch.plan_view0
    where   collid       = 'NG'
        and prog         = 'YNGPRKT'
    order by pcBi  desc, bind_Time desc
    with ur
;
--- ausgewählte Explains analysieren
select *
 -- from cmnbatch.plan_view1
    from cmnbatch.plan_view2
 -- from cmnbatch.plan_view2Det
    where     collid     = 'NG'
        and progName     = 'YNGPRKT'
        and bind_time    = '2012-05-19-23.59.50.200285'
    order by collid, progName, version, bind_time,
             queryno, qBlockNo, planno, mixopSeq
    with ur
;
select *
    from cmnbatch.plan_viewPred
    where     collid     = 'NG'
        and progName     = 'YNGPRKT'
        and bind_time    = '2012-05-19-23.59.50.200285'
    order by collid, progName, applName, bind_time,
             queryNo, qBlockNo, planno,
             stage, predNo
    with ur
;x;
select count(*), NG005021, NG005022
    from oa1p.tng005a1
    group by NG005021, NG005022
    order by 1 desc
    fetch first 100 rows only
with ur
;x;
select count(*), NG005020, NG005021, NG005022, NG005025, NG005001
               , NG005010
    from oa1p.tng005a1
    group by NG005020, NG005021, NG005022, NG005025, NG005001, NG005010
    order by 1 desc
    fetch first 100 rows only
;x;