Archives of the TeradataForum

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

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

Hi,

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.

Cheers,

Dave

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

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