Have you tried scheduling "select count(*) from sessions" every 5 or 10
minutes?

Todd

-----Original Message-----
From: MC Matt Cooper (2838) [mailto:Matt.Cooper AT AMGREETINGS DOT COM]
Sent: Wednesday, October 16, 2002 7:31 AM
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


**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**********************************************************************