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
 

 

Which path has been selected by optimizer

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
manjinder

New User


Joined: 04 Dec 2005
Posts: 45
Location: pune

PostPosted: Thu Jan 19, 2006 2:58 pm    Post subject: Which path has been selected by optimizer
Reply with quote

i want to know which path has been selected by optimizer and list of the remaining paths please tell me the query.

thanx in advance.
regard..
manjinder
Back to top
View user's profile Send private message

futuredba

New User


Joined: 08 Jan 2006
Posts: 22
Location: Delhi

PostPosted: Fri Jan 20, 2006 7:26 pm    Post subject:
Reply with quote

Hi manjinder,

While binding ur dbrm, one should specify explain = yes. After that, look out in ur plan_table, it will show u the path taken by optimizer.

we can tell some other paths that optimiser can choose(obviously, only if we modify the query) but i dont know whether one can get some list which will show all the paths that can be taken by optimizer.

regards,
futuredba
Back to top
View user's profile Send private message
saranya_sn

New User


Joined: 03 Jul 2005
Posts: 12
Location: India

PostPosted: Tue Jan 24, 2006 4:12 am    Post subject:
Reply with quote

Can some one tell me for the pakage how to look for the optimiser path
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Sun Jan 29, 2006 4:53 pm    Post subject:
Reply with quote

Hi,
you can get the accesspath chosen by optimizer for a query through PLAN_TABLE.
But all the possible paths will not be saved anywhere.
possible paths will be calculated by optimizer internally during BIND and select most optimum path and saves it.

Thanks
Rags
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 Reading selected volumes of a multi-v... RickBig JCL & VSAM 6 Wed Jul 13, 2016 7:26 pm
No new posts VSAM - Use of DEFINE PATH vs. DEFINE ... Abhi Nature JCL & VSAM 13 Wed Aug 19, 2015 4:35 pm
No new posts -805 sql code from db2 optimizer yugendran DB2 1 Thu Aug 13, 2015 7:59 am
No new posts store randomly selected row vinod.fugal CICS 1 Thu Jul 16, 2015 11:49 am
No new posts GDG versions not being selected for b... Randy Wood SYNCSORT 2 Wed Aug 27, 2014 10:24 pm


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