zOs/TX/QBDPSEXP

--- ausgewählte Explains analysieren
select *
 -- from A540769.plan_view1
    from A540769.plan_view2
 -- from A540769.plan_view2Det
    where bind_time > current timestamp - 1 hour
    order by collid, progName, version, bind_time,
             queryno, qBlockNo, planno, mixopSeq
    with ur
;
select *
    from A540769.DSN_PGRANGE_TABLE
    where explain_time > current timestamp - 1 hour
    order by collid, progName, applName, explain_time,
             queryNo, qBlockNo, tabNo, range
    with ur
;
select *
    from A540769.plan_table
    where bind_time > current timestamp - 1 hour
    order by collid, progName, version, bind_time,
             queryno, qBlockNo, planno, mixopSeq
    with ur
;
select *
    from A540769.plan_viewPred
    where bind_time > current timestamp - 1 hour
    order by collid, progName, applName, bind_time,
             queryNo, qBlockNo, planno,
             stage, predNo
    with ur
;x;
delete from A540769.plan_table;
delete from A540769.DSN_PGRANGE_TABLE;
commit;