View previous topic :: View next topic
|
Author |
Message |
srinut123
New User
Joined: 11 Oct 2005 Posts: 62 Location: India
|
|
|
|
Hi
We bind our cobol-db2 programs with bind option explain(yes)..
Can anyone help.. how to see the explain report?
Thanks
Sri |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
setting up the environment for the explain need a bit of work,
ask Your support for the local standards and practices
and if Yo have the need to do/know they will be glad to help |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
And also check out the DB2 Command Reference manual. The usage of the EXPLAIN(YES) option of the BIND command is clearly explained, including the naming convention used for the PLAN_TABLE associated with the BIND. |
|
Back to top |
|
|
|