zOs/TX/PER08EXP

--- versionen, compiles und explains eines packages -------------------
select *
    from cmnbatch.plan_view0
    where   collid       = 'QZ'
        and prog         = 'QZPLB'
    order by pcEx  desc, explain_time desc
    with ur
;
--- ausgewählte Explains analysieren
select *
    from cmnbatch.plan_view1
 -- from cmnbatch.plan_view2Det
    where     collid     = 'QZ'
        and progName     = 'QZPLB'
        and explain_time in ( '2015-02-27-13.02.50.480540'
                            , '2015-02-27-14.02.55.226372'
                            , '2015-02-27-16.40.41.008254'
                            , '2015-02-27-14.07.32.811472'
                            )
    order by collid, progName
        , queryno
        , version
        , explain_time
        , qBlockNo, planno, mixopSeq
    with ur
;
--- ausgewählte Explains analysieren
select *
    from cmnbatch.plan_view2
 -- from cmnbatch.plan_view2Det
    where     collid     = 'QZ'
        and progName     = 'QZPLB'
        and explain_time in ( '2015-02-27-13.02.50.480540'
                            , '2015-02-27-14.02.55.226372'
                            , '2015-02-27-16.40.41.008254'
                            , '2015-02-27-14.07.32.811472'
                            )
    order by collid, progName
        , queryno
        , version
        , explain_time
        , qBlockNo, planno, mixopSeq
    with ur
;
select *
    from cmnbatch.plan_viewPred
    where     collid     = 'QZ'
        and progName     = 'QZPLB'
        and explain_time in ( '2015-02-27-13.02.50.480540'
                            , '2015-02-27-14.02.55.226372'
                            , '2015-02-27-14.07.32.811472'
                            , '2015-02-27-16.40.41.008254'
                            )
    order by collid, progName
        , queryNo
        , explain_time
    , qBlockNo, predNo, orderNo, mixOpSeqNo
    with ur
;
select *
    from cmnbatch.plan_table
 -- from cmnbatch.plan_view2Det
    where     collid     = 'QZ'
        and progName     = 'QZPLB'
        and explain_time in ( '2015-02-27-13.02.50.480540'
                            , '2015-02-27-14.02.55.226372'
                            , '2015-02-27-14.07.32.811472'
                            , '2015-02-27-16.40.41.008254'
                            )
    order by collid, progName
        , queryno
        , version
        , explain_time
        , qBlockNo, planno, mixopSeq
    with ur
;
select * from cmnBAtch.DSN_DetCost_TABLE
    where     collid     = 'QZ'
        and progName     = 'QZPLB'
        and explain_time in ( '2015-02-27-13.02.50.480540'
                            , '2015-02-27-14.02.55.226372'
                            , '2015-02-27-14.07.32.811472'
                            )
    order by collid, progName
        , queryno
        , version
        , explain_time
        , qBlockNo, planno
    with ur
;
; x;
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table  ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 3   for
    select count(*), sum(colCardF) cardF
        from QTXCRY.tPer08
        where  tbCreator = 'QTXCRY'
          and  name = 'NAME'
;
select * from  plan_view1
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by collid, progName, explain_time,
             queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
    with ur
;
rollback
;;;;