ADSM-L

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

2016-01-27 02:55:48
Subject: Re: [ADSM-L] How many DB2 users should there be?
From: Remco Post <r.post AT PLCS DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 27 Jan 2016 08:54:04 +0100
> 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>