Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 14:43:35 GMT

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

When a "multi-session" utility logs on, all of the related sessions will be assigned the same Logon Sequence Number. You can find the number of currently active utilities by querying DBC.SessionInfo:

     lock DBC.SessionInfo for access
      select
      Partition
     ,count(distinct(LogonSequenceNo))
      from DBC.SessionInfo
      where Partition in ('MLOAD', 'FASTLOAD', 'EXPORT')
      group by 1;

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