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

EXPLAIN in DB2
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
KS

New User


Joined: 28 Feb 2006
Posts: 91
Location: Chennai
PostPosted: Mon Mar 20, 2006 12:49 pm
 Reply with quote
Hi,

Can somebody please define EXPLAIN in DB2 ?

Thanks,
KS
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland
PostPosted: Mon Mar 20, 2006 5:16 pm
 Reply with quote
hy KuttiSatha,

with EXPLAIN, you can DB2 let explain your db2 packages,
with this you will see how the package will use the access paths,
to your db2 objects, if for example any index is used or not...
and much more...

martin9
Back to top
View user's profile Send private message
KS

New User


Joined: 28 Feb 2006
Posts: 91
Location: Chennai
PostPosted: Tue Mar 21, 2006 9:56 am
 Reply with quote
Thanks Martin for the reply.
But it is still not that clear for me.

Thanks,
KS
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 Can someone explain me this JCL line ... JCL & VSAM 9
No new posts DB2 Explain DB2 3
No new posts can some one explain the below code... JCL & VSAM 3
No new posts Please explain this SQL CODE. DB2 4
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us