Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 31 Oct 2001 @ 19:19:46 GMT

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

Subj:   Re: User activity monitor
From:   David Wellman


Some of this information is available under the current release of Teradata.

System view dbc.logonoff holds information about every session that logs on to the Teradata system. To find the last time your userid logged on to the system try:

Select max((logondate (format 'yyyymmdd'))||logontime)
from dbc.logonoff
Where username = user
and event = 'logoff';

In the current release of Teradata, there is no system view which will tell you how long a query took to run.

The number of sessions currently logged on using your userid is given by:

Select count(*) from dbc.sessioninfox;

With Teradata V2R4.1 if you have an application which uses the pm&pc api, you can find out the sql that is running for a particular session. This is (I think) one of the capabilities of the latest Teradata Manager release (but you also need v2r4.1 of the dbms).

You can tell which machine a session logged on from by looking at column dbc.logonoff.LogonSource. For a session that gets logged in from a lan client, that'll give you the pc's i/p address.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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