Archives of the TeradataForum
Message Posted: Wed, 31 Oct 2001 @ 19:19:46 GMT
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)
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|