Archives of the TeradataForum

Message Posted: Sun, 05 Oct 2014 @ 21:21:13 GMT

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

Hi,

Yes, SessionID values they can be reused. To double check your findings below I suggest you look at LogondateTime and not CollectTimeStamp. I agree that it is unlikely that the same session has bene logged on for 8 months, but you never know...

SessionID is defined as INTEGER so there will be a max value. Nominally INTEGERs are signed values, so the max is probably @2.14billion. I don't know if the PE or GTW software have any inbuilt limits.

I think you'll find that a dbms restart will 'reset' the values, but not totally sure about that.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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