MVSFORUMS.com

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

We have the same program in two environments. The time of execution is so different.
The problem may be is the path of access.

How can i know the path the program is using when it access to a table? I know that db2 decides it in BIND time. And you can see that information in PLAN_TABLES.
Is there another way to see it? For example, on catalog table, with a DB2 command, etc.

Kind regards.

kolusu · Posted: Thu May 20, 2004 2:43 pm Post subject:

Monaco,

Did you try running explain for all the sql statements in your program?

Check this topic ( the last post by me) discusses about EXPLAIN

http://www.mvsforums.com/helpboards/viewtopic.php?t=215

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Bithead · Posted: Thu May 20, 2004 2:52 pm Post subject:

Make sure that RUNSTATS has been run on all tables in the plan and re-bind.

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Thanks a lot.
It was very useful.