Archives of the TeradataForum
Message Posted: Thu, 14 Sep 2001 @ 16:42:58 GMT
Ruth's original question was:
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|