Page 1 of 1

DB2 Explain table

PostPosted: Mon Oct 01, 2007 7:16 pm
by 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.

Re: DB2 Explain table

PostPosted: Mon Oct 01, 2007 9:52 pm
by 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.

Re: DB2 Explain table

PostPosted: Tue Oct 30, 2007 5:14 pm
by 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