Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 20:34:37 GMT

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

Gareth,

There was a thread on this very subject today or yesterday in either this list or the Masters list.

Probably the easiest way is to query Logonoff, looking for non-zero values in LogonSequenceNumber, something like:

     SELECT COUNT(DISTINCT(LOGONSEQUENCENO))
     FROM DBC.SESSIONINFO
     WHERE LOGONSEQUENCENO <> '0000000000000000'XB;

The number returned is the number of active "Load Tasks".

Cheers,

Dave

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