Archives of the TeradataForum
Message Posted: Fri, 14 Sep 2001 @ 15:03:30 GMT
| Subj: | | Re: Number of ACTIVE users |
| |
| From: | | John Hall |
You're right about Ruth's original question - I did mis-read it. Being lucky, I think that the same answer still applies - almost.
Looking at DBC.SESSIONTBL will only tell you that you have sessions logged-on, not what work is being performed on a query.
Looking at DBC.DBASE will tell you that spoolspace is being consumed, but that only indicates that at least one session is consuming
spoolspace. If you have multiple sessions, then all spoolspace is lumped into just the one userid. So again, you can't identify how many
queries are being executed.
The problem with &L&D&T is that it indicates when a query began, but not when it finished. You could answer Ruth's question by using a
combination of those users who are using spoolspace and their most recently submitted queries (which can be found in DBC.ACCTG). At the
same time, I know that this won't give Ruth an accurate answer (but close is probably good enough).
| 
