zOs/SQL/EXPLAIVA

--- 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;
DECLARE GLOBAL TEMPORARY TABLE SESSION.XTGLOBAL (TEMP_DBKEY INTEGER NOT
NULL, OUT_IDSYMBOL_1 CHAR (30) WITH DEFAULT NULL, OUT_SCHEMESYMBOL_1
CHAR (30) WITH DEFAULT NULL, OUT_IDSYMBOL_2 CHAR (30) WITH DEFAULT
NULL, OUT_IDSYMBOL_3 CHAR (30) WITH DEFAULT NULL, OUT_INPUT_3 CHAR
(150) WITH DEFAULT NULL, OUT_INPUT_4 CHAR (30) WITH DEFAULT NULL,
OUT_INPUT_5 CHAR (30) WITH DEFAULT NULL) ON COMMIT PRESERVE ROWS
;
explain plan set queryno = 3   for
---         : YVV3250    191A870D1E62017A
-- Last page referenced:   WKDBDOF2   DSN32K01  PAGE: X'0000064A'
-- Collection ID:  VV


SELECT OUT_IDSYMBOL_1,OUT_SCHEMESYMBOL_1,IDSYMBOL_RATING,RATINGDATE
  FROM SESSION.XTGLOBAL INNER JOIN oa1p.VVV_IDS_VISRG319 v ON
    V.INSTRUMENTID = SESSION.XTGLOBAL.TEMP_DBKEY AND
    V.SCHEME_RATING = 'SPSICRLC' AND V.ROLetype
    = 25 WITH UR FOR FETCH ONLY;
select * from  plan_view1
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by --collid, progName, applName, explain_time,
             queryNo, qBlockNo, planno,
             stage, predNo
    with ur
;
rollback
;;;;