Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

EXPLAIN in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: EXPLAIN in DB2
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: 287
Location: Basel, Switzerland

PostPosted: Mon Mar 20, 2006 5:16 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts DB2 Explain agkshirsagar DB2 3 Wed Aug 28, 2013 6:23 pm
No new posts can some one explain the below code... ram_vizag JCL & VSAM 3 Thu Aug 22, 2013 4:35 pm
No new posts Please explain this SQL CODE. tamminenisidhartha DB2 4 Wed Mar 13, 2013 5:05 pm
No new posts Explain Comparision Report gylbharat DB2 4 Tue Jun 05, 2012 5:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us