IBM Mainframe Forum

Hi,

i am not having access to Create table.... i want to use PLAN_TABLE.

if i use below statements in SYSTSIN , i am getting INVALID syntax EXPLAIN.
can any body help how to execute Exlpain query????

DSN SYSTEM(DB2)
RUN PROGRAM(PROG1)
PLAN(TESTPL1)
EXPLAIN(YES)
END

regards,
raja.

Hello,

If you post all of your jcl, control info, and the disgnostic info from the jes output(s), we may be able to offer suggestioins.

Hi ,

you can't give Explain (Yes) in the Run Comamnd of your Db2-Run JCl . you can enable explain (YES) during binding the plan / pacakge .
So go ahead with re-bind the plan/package with Exaplin (YES) .

Please correct me If i am wrong

Regards
Senthil