MVSFORUMS.com

Veera333 · Beginner Joined: 16 Jul 2010 Posts: 7 Topics: 5

Hi,
Is there any JCL that binds the program and can be scheduled as daily or weekly job for rebinding.

Thanks in advance,
Veera

dbzTHEdinosauer · Posted: Tue Jul 20, 2010 8:38 am Post subject:

Veera333,
are you a dba, working in db2 support or a development programmer?

if the later contact the former.
_________________
Dick Brenholtz
American living in Varel, Germany

kolusu · Posted: Tue Jul 20, 2010 10:19 am Post subject:

Veera333,

I just don't get this concept of re-binding the program everyday/every week. Re-org is the way to do and I have seen a surge of questions on re-binding which absolutely makes no sense without a re-org.

Kolusu

Anuj Dhawan · Posted: Wed Jul 21, 2010 4:18 am Post subject:

Yes, I also agree with Dick and Skolusu and probably the first question I'd like to ask is: why do you want to do that? What business need initiates such a requirement?
_________________
Regards,
Anuj

Veera333 · Beginner Joined: 16 Jul 2010 Posts: 7 Topics: 5

Hi,
In development region i have to bind the program whenever i do a reorg on a table.

I was assuming the same case in production as well. Dont i need to bind or rebind the program every time reorg is executed on the table that is being used in the program?

Thanks,
Veera

RonB · Posted: Wed Jul 21, 2010 9:46 am Post subject:

1) You don't "NEED" to bind/rebind a program every time a Reorg is done.
2) The major reason for doing a Reorg is to improve table access - and table access paths are determined by the optimizer based on the results of the latest Runstats; so unless you do a Runstats following the Reorg, access paths will not change merely by doing a rebind.
3) There is no benefit in automatically rebinding a program daily/weekly unless you have a high insert/delete ratio ( and you also perform a Reorg/Runstats prior to every automatic rebind ).
4) Even if Reorg/Runstats HAVE been done, if the ratio of inserts/deletes is low, a rebind will likely not result in any change to access paths, thus not significantly improving performance.
5) Lastly, there is a very real possibility that access paths for some table accesses will actually deteriorate - not improve - following a Reorg/Runstats/Rebind; so a review of Explain results should be done following any Rebind.

A quick read of This article might help in understanding the process.
_________________
A computer once beat me at chess, but it was no match for me at kick boxing.