ADSM-L

Re: [ADSM-L] How many DB2 users should there be?

2016-01-27 09:45:42
Subject: Re: [ADSM-L] How many DB2 users should there be?
From: "Ryder, Michael S" <michael_s.ryder AT ROCHE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 27 Jan 2016 09:43:19 -0500
Thanks Remco, that's a reasonable response.  In other words, the number of
processes will be directly related to how many processes/sessions are
active at any one time.

Looking at a graph of several hours of activity, it appears that when my
TSM 7.1.3 server is idle, there are on average 65 connections from the
dsmserv account.  And right now, I see 4 Migration, 8 Identify Duplicate
and 4 Space Reclamation processes running, and connections hovers between
125 and 150.  During a database backup the connections were pinned at ~175.

I'd be interested in hearing about other installations' metrics, if anyone
is interested in sharing them here.

Best regards,

Mike, x7942
RMD IT Client Services

On Wed, Jan 27, 2016 at 2:54 AM, Remco Post <r.post AT plcs DOT nl> wrote:

> > On 26 jan. 2016, at 23:37, Ryder, Michael S <michael_s.ryder AT ROCHE DOT 
> > COM>
> wrote:
> >
> > Hello all
> >
> > Running a pair of TSM 7.1.3 servers here, and use Nagios to monitor our
> > environment.
> >
> > One of the service checks I run watches the number of DB2 users on the
> TSM
> > database.  We see an rise and fall of user connections, and they are all
> > consistently from one user...
> >
> > "dsmserv"
> >
> > Does anyone know if there is a reason for what all these processes are
> > for?  I generally see between 50-150 connections depending on what TSM is
> > doing, and I'm trying to understand what the thresholds should be so I
> can
> > configure the service checks with meaningful values.
> >
>
> 50-150 connections seems to be quite a low value. I’d guess that for each
> client connection there should also be one DB2 connection, plus a few.
> During the housekeeping window: one for each expiration thread, one for
> each reclaim or migration process, etc. SO tens of DB2 connections on a
> large server should be normal, hundreds during peak back-up window, I’d
> guess.
>
> > Yes, I could easily just look at my existing trends and derive them, but
> I
> > was hoping to gain insight into what is actually going on that so many
> > connections are necessary.
> >
> > Thanks for your time
> >
> > Best regards,
> >
> > Mike Ryder
> > RMD IT Client Services
>
> --
>
>  Met vriendelijke groeten/Kind Regards,
>
> Remco Post
> r.post AT plcs DOT nl
> +31 6 248 21 622
>
>

<Prev in Thread] Current Thread [Next in Thread>