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
 

 

How to obtain bind statistics for a particular DB2 region

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

New User


Joined: 07 Dec 2011
Posts: 19
Location: India

PostPosted: Fri Jun 15, 2012 3:39 pm    Post subject: How to obtain bind statistics for a particular DB2 region
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Jun 15, 2012 7:09 pm    Post subject:
Reply with quote

Did you mean -- number of PACKAGEs/PLANs for a given DB2 sub-system?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 15, 2012 8:29 pm    Post subject: Reply to: How to obtain bind statistics for a particular DB2
Reply with quote

Hi Anuj,

I believe the question is "how many times does this happen?" as opposed to "how many are there?".

d
Back to top
View user's profile Send private message
Balaji Canabady

New User


Joined: 07 Dec 2011
Posts: 19
Location: India

PostPosted: Sat Jun 16, 2012 12:29 pm    Post subject: Reply to: How to obtain bind statistics for a particular DB2
Reply with quote

Yes Dick you are correct.
I would like to know the total number of binds
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Jun 16, 2012 4:23 pm    Post subject: Re: Reply to: How to obtain bind statistics for a particular
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 16, 2012 8:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Balaji Canabady

New User


Joined: 07 Dec 2011
Posts: 19
Location: India

PostPosted: Sat Jun 16, 2012 10:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sun Jun 17, 2012 12:05 am    Post subject:
Reply with quote

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
View user's profile Send private message
Balaji Canabady

New User


Joined: 07 Dec 2011
Posts: 19
Location: India

PostPosted: Fri Jun 22, 2012 3:39 pm    Post subject:
Reply with quote

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
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 What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts how to move view the remote file in o... mailtoashok CICS 2 Fri Feb 12, 2016 1:07 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts COBOL IMS DC program not Refreshing i... PeterHolland IMS DB/DC 16 Wed Jul 29, 2015 5:56 pm
No new posts EXEC SORT,REGION=0M,PARM=ELAP venugopal.mft DFSORT/ICETOOL 4 Wed May 20, 2015 12:45 pm


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