zOs/SQL/EXPLMODE

           -- explain mode yes: explain wie üblich
           --                   statements in dsn_statement_cache_table
delete from A540769.plan_table;
delete from A540769.dsn_statement_cache_table;
commit;
set current explain mode explain
;
set current explain mode yes
;
select strip(tbcreator) || '.' || strip(tbName), c.*
    from sysibm.sysColumns c
    where name like '%CLUST%' and tbCreator = 'SYSIBM'
    order by 1
;
set current explain mode no
;
select * from A540769.plan_view1
;
select * from A540769.dsn_statement_cache_table
;
rollback