DB2 Explain table



IBM's flagship relational database management system

DB2 Explain table

Postby Raja » Mon Oct 01, 2007 7:16 pm

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.
Raja
 
Posts: 7
Joined: Fri Sep 21, 2007 8:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Explain table

Postby dick scherrer » Mon Oct 01, 2007 9:52 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: DB2 Explain table

Postby senthilssg » Tue Oct 30, 2007 5:14 pm

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
senthilssg
 
Posts: 1
Joined: Tue Oct 30, 2007 5:06 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post