Help me to monitoring jdbc application from DB2 zOs angle.

Renzo Razzetti

Help me to monitoring jdbc application from DB2 zOs angle.
Hi all.

I have to monitoring a jdbc application using type 4 driver directly to
connect with the DB2 zOs server.
I would like to know besides the normal indicators such as response time ,
CPU time, suspension time, which other indicators I have to pay attention
on evaluation of JDBC application.
Also I will appreciate if you can send me relevant and specific information
of how to monitoring jdbc application from DB2 Zos point of view.


Thank you

RR

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Jorg Lueke

Re: Help me to monitoring jdbc application from DB2 zOs angle.
(in response to Renzo Razzetti)
DB2 elapsed times, cpu times, ziip usage, and causes of waits.
Nothing really different on a day to day basis than anyother connection
method.

The primary issues we end up with is more bad access paths with dynamic SQL
either because of the code or because correlated stats are required.

Then someone in the company needs to understand the connections, pooling,
timeouts, network etc.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Deb Ghosh

Re: Help me to monitoring jdbc application from DB2 zOs angle.
(in response to Jorg Lueke)

101 data would not give you a slightest clue on what's going on on network, you will probably see a large class1 elapsed time, but you can use tool like sysco ethrol network monitoring tool to see end-to-end performance data. RMF mon III enclave data will reveal not of mvs related delay info. since you are saying that all your setups are ok, I would say that you focus on 2 things

1) Chatinees of your sql
2) Run proper strategic runstats
3) In correct ussage of optimize for N rows clause can slow down you transaction as well.


To analyze a DDF transaction you should focus on network monitoring tool and then drill down to 101 data much easier.
> Date: Mon, 8 Dec 2008 17:01:42 +0000> From: [login to unmask email]> Subject: Re: [DB2-L] Help me to monitoring jdbc application from DB2 zOs angle.> To: [login to unmask email]> > DB2 elapsed times, cpu times, ziip usage, and causes of waits.> Nothing really different on a day to day basis than anyother connection > method.> > The primary issues we end up with is more bad access paths with dynamic SQL > either because of the code or because correlated stats are required.> > Then someone in the company needs to understand the connections, pooling, > timeouts, network etc. > > ______________________________________________________________________> > * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *> ______________________________________________________________________> > > > The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
_________________________________________________________________
Send e-mail faster without improving your typing skills.
http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: Help me to monitoring jdbc application from DB2 zOs angle.
(in response to Deb Ghosh)
or you could look at Wily Introscope (http://www.ca.com/us/application-management.aspx) - I think this gives the level of end to end data you are looking for

Phil Grainger
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Debabrata Ghosh
Sent: Mon 08/12/2008 20:22
To: [login to unmask email]
Subject: Re: [DB2-L] Help me to monitoring jdbc application from DB2 zOs angle.


101 data would not give you a slightest clue on what's going on on network, you will probably see a large class1 elapsed time, but you can use tool like sysco ethrol network monitoring tool to see end-to-end performance data. RMF mon III enclave data will reveal not of mvs related delay info. since you are saying that all your setups are ok, I would say that you focus on 2 things

1) Chatinees of your sql
2) Run proper strategic runstats
3) In correct ussage of optimize for N rows clause can slow down you transaction as well.


To analyze a DDF transaction you should focus on network monitoring tool and then drill down to 101 data much easier.



> Date: Mon, 8 Dec 2008 17:01:42 +0000
> From: [login to unmask email]
> Subject: Re: [DB2-L] Help me to monitoring jdbc application from DB2 zOs angle.
> To: [login to unmask email]
>
> DB2 elapsed times, cpu times, ziip usage, and causes of waits.
> Nothing really different on a day to day basis than anyother connection
> method.
>
> The primary issues we end up with is more bad access paths with dynamic SQL
> either because of the code or because correlated stats are required.
>
> Then someone in the company needs to understand the connections, pooling,
> timeouts, network etc.
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms



________________________________

Send e-mail faster without improving your typing skills. Get your Hotmail® account. < http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008 >

________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Jorg Lueke

Re: Help me to monitoring jdbc application from DB2 zOs angle.
(in response to Phil Grainger)
True, but the OP asked about monitoring from the DB2 z/OS point of view.
The network is a wholly different beast and usually managed by people far
hardier than those that deal with the database.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Leila Hosseini

Re: Help me to monitoring jdbc application from DB2 zOs angle.
(in response to Jorg Lueke)
Hi Dear Renzo
 
As we have a jdbc application using type 4 driver ,I prefered to select a proper IFCID to monitor details on applications.If you review IFCID list you can find it.
I can tell you more details if you need.
Now i have a question ,Have you noticed the cursors remain open?
what have you done about the open cursors?
Thanks in advance.
L.S.H


--- On Mon, 12/8/08, Renzo razzetti <[login to unmask email]> wrote:

From: Renzo razzetti <[login to unmask email]>
Subject: [DB2-L] Help me to monitoring jdbc application from DB2 zOs angle.
To: [login to unmask email]
Date: Monday, December 8, 2008, 10:57 AM


Hi all.

I have to monitoring a jdbc application using type 4 driver directly to connect with the DB2 zOs server.
I would like to know besides the normal indicators such as response time , CPU time, suspension time, which other  indicators I have to pay attention on evaluation of JDBC application.
Also I will appreciate if you can send me relevant and specific information of how to monitoring jdbc application from DB2 Zos point of view.


Thank you

RR







IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms