Have you tried scheduling "select count(*) from sessions" every 5 or 10 minutes?
Todd -----Original Message----- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 7:31 AM To: [EMAIL PROTECTED] 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 **********************************************************************
