ADSM-L

Re: how many active session?

2002-10-16 08:17:52
Subject: Re: how many active session?
From: Halvorsen Geirr Gulbrand <gehal AT WMDATA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 16 Oct 2002 14:19:33 +0200
Hi Matt

I hope I can help with this. It doesn't seem straightforward but one way
could be...;
select number as sessid,cast(start_time as TIME)as Start,cast(end_time as
TIME)as End from summary where activity='BACKUP' AND cast(start_time as
DATE)='2002-10-15'

This will give you all backup sessions and their start/end time for the date
10/15/2002, but not those that started, say 23:55 the 14th, end ended on the
15th. You might want to put additional checks on this to get all sessions
between a start and end-time on two following days.

Now, you would have to count the sessions according to start/end-times. I'm
sure someone on the list can find a more precise way to count concurrent
sessions within a time period.

Rgds.
Geirr G. Halvorsen


-----Original Message-----
From: MC Matt Cooper (2838) [mailto:Matt.Cooper AT AMGREETINGS DOT COM]
Sent: 16. oktober 2002 13:31
To: ADSM-L AT VM.MARIST DOT EDU
Subject: how many active session?


Does anyone know of a way to track the number of active sessions overnight.
I know you can schedule re-occurring QUERY SESSIONs and then count them.   I
want to just get the number of active sessions say every 15, 30 or 60
minutes.   I have to find the best place to move some backups but I don't
have way of tracking this.

Would that TSM MANGER product provide this?
Thanks
Matt

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