View previous topic :: View next topic
|
Author |
Message |
Balaji Canabady
New User
Joined: 07 Dec 2011 Posts: 19 Location: India
|
|
|
|
Is it possible to obtain the bind information such as the total number of binds and rebinds that has happened in a particular DB2 region ? |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Did you mean -- number of PACKAGEs/PLANs for a given DB2 sub-system? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Anuj,
I believe the question is "how many times does this happen?" as opposed to "how many are there?".
d |
|
Back to top |
|
|
Balaji Canabady
New User
Joined: 07 Dec 2011 Posts: 19 Location: India
|
|
|
|
Yes Dick you are correct.
I would like to know the total number of binds |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Balaji Canabady wrote: |
Yes Dick you are correct.
I would like to know the total number of binds |
my, that is a useful statistic. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
How might this statistic be used? Just curious.
I don't know if there is a way to find what has already happened, but the standard compile/link/bind process(es) could be modified to capture this info going forward - if the value of the nfo would be worth the effort to get it. |
|
Back to top |
|
|
Balaji Canabady
New User
Joined: 07 Dec 2011 Posts: 19 Location: India
|
|
|
|
I have developed a REXX tool that can be easily invoked to do binds of single or multiple programs. I would like to know the bind statistics in our DB2 region in order to validate the tool's efficacy. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
i think you have things a little backwards.
you can bind all day, and if the binds are incorrect,
the plans will not work.
so the tool can have 100% efficacy, yet generate garbage.
so, you need to test the modules to insure that your production continues to function.
hopefully your 'rexx tool' submits jobs to generate the binds.
in which case, it is just a matter of using the same control cards
as a normal compile/link/BIND job.
(if not, why not????)
one of the appendices to every DB2 VSN SQL Reference,
is a discussion of SYSIBM... tables,
info about plans/packages (binds, when they were done, etc....) is contained.
there are also examples of sql to access data from all these tables.
oh! and i imagine your dba's already have such 'tools',
so instead of wasting time, use theirs. |
|
Back to top |
|
|
Balaji Canabady
New User
Joined: 07 Dec 2011 Posts: 19 Location: India
|
|
|
|
Thanks Dick(s) for the replies.
Quote: |
(if not, why not????)
|
As suggested, I have modified the JCL to do compile/link/bind of programs for component testing ...
Now exploring the AUTOBIND option in Endevor for integration testing... |
|
Back to top |
|
|
|