Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2001 @ 12:38:16 GMT

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

Adam and Ruth,

We're also interested in reporting active as opposed to logged on but idle sessions. We tried your approach, but in our test where I submitted a query via Queryman and a colleague ran the query, I never showed up in the answerset. The query I ran is:

sel distinct databasename from DBC.Diskspace group by 1 having SUM(CURRENTSPOOL) > 0

We also saw accounts in the DISPATCHING phase who didn't show up.

Thanks,

Mary Lou Arundell

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