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

Optimum access path


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

EXPERT


Joined: 28 Jan 2004
Posts: 37
Location: Trivandrum

PostPosted: Fri Mar 05, 2004 11:57 pm
Reply with quote

Hello all,

I have a doubt in Bind. During bind i read that an
Quote:
optimum access path
is created and that an optimizer is responsible for this. I would like to ask what actually is access path .

Thanks and regards,

Hari.
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Tue Mar 09, 2004 5:25 pm
Reply with quote

Hi Hari,

What u read is correct.Determining the method of access or access path(watever we call)is an automatic function of DB2. This function is performed during the bind process for static SQL or during execution time for dynamic SQL.

Access path is nothing but the order in which records in a database file are processed.Access paths reduces the system overhead.Access path selection criteria is based on the statistical information which is stored in db2 catalog.These catalog statistics are updated by execution of the RUNSTATS utility. DB2's determination of the most efficient access paths is dependent on the accurate and realistic statistics of this catalog.Optimal access path selection is important to resource utilization.Access path selection may include the use of RUNSTATS, rebinding, and EXPLAIN.

If the runstats is incomplete and doesn't reflect the current state of data there are more chances to select a very bad access path instead of good one.So we should see that always db2 catalog has current statistics.

Hope this helps.others can add

THANKS AND REGARDS
ANU
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 BPXBATCH SFTP to remote path having s... All Other Mainframe Topics 6
No new posts Access to macro definitions PL/I & Assembler 4
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts How to access web services/website? Mainframe Interview Questions 4
No new posts SET PATH in View DDL DB2 2
Search our Forums:

Back to Top