IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 BIND - EXPLAIN


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srinut123

New User


Joined: 11 Oct 2005
Posts: 62
Location: India

PostPosted: Thu Apr 28, 2011 1:40 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Apr 28, 2011 1:43 pm
Reply with quote

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
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Thu Apr 28, 2011 5:26 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts JCL for pl1 db2 precompile, compile a... JCL & VSAM 4
No new posts Bind process DB2 4
No new posts How syntax check at Bind time is diff... DB2 5
No new posts VALIDATE option in BIND jcl DB2 2
Search our Forums:

Back to Top