Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2001 @ 15:03:30 GMT

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

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).

  <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: 28 Jun 2020