Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 14 Sep 2001 @ 16:42:58 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Number of ACTIVE users
From:   Thomas F. Stanek


Ruth's original question was:

  "I'm looking for an easy way of reporting on how many active sessions are on my system on an hourly basis."  

Assuming Ruth defines active as "doing work on the system", or more precisely, "consuming resources", I think John Hall answered that question pretty well.

I think your question is a tougher to answer. The only definitively accurate way to determine "active" sessions during the execution of another query is through PM/API (mentioned earlier by David Wellman), or some sort of custom coded scrapper of HUTCNS=type output. However, something to consider: if your "canary" query takes 10 seconds to run, when will you be looking at active sessions during that period? It may sound trivial, but in a mixed workload environment or on system with large numbers of concurrent users, many sessions can log on and or off in 10 seconds.

I think it would be helpful to get a better understanding of what it is you are trying to determine. With more details, maybe someone on the list could provide an approach that might meet your needs.

BTW, in re-reading this note, it could be read as sounding less than friendly. That's not the tone I was going, for but that's the problem with email.:-)


Thomas F. Stanek
TFS Consulting

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023