DB2 Explain table

[Raja]

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.

[dick scherrer]

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.

[senthilssg]

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