 |
 |
Archives of the TeradataForum
Message Posted: Tue, 08 Dec 2009 @ 15:19:41 GMT
| Subj: | | Re: How to find Active Jobs |
| |
| From: | | Geoffrey Rommel |
Just to shed a little light on the previous postings ... FastLoad, FastExport, MultiLoad, and their TPT equivalents open multiple sessions for
one job. These are tied together by the Logon Sequence Number, which can be seen in PMon or in dbc.SessionInfo. Each LSN takes a load slot. Hence,
if everything is running normally, the number of distinct non-zero values in dbc.SessionInfo.LogonSequenceNo will be the number of load slots in
use.
Likewise, the LogonSource that Dave mentioned contains information on the application that started the session.
Soumya also asked about BTEQ and TPump. These do not take up load slots; they run ordinary SQL.
| |
