Archives of the TeradataForum

Message Posted: Wed, 12 Mar 2003 @ 15:27:49 GMT

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

<-- Anonymously Posted: Wednesday, March 12, 2003 10:15 -->

I can understand the reaction to my question because I have a habit of letting little things bother me that no one else cares about. So no offense taken. But this trait has contributed to my success doing this job. I'm kind of proud that other people think me very peculiar but omniscient. Works for me.

Our lan session numbers are in the millions. The reasons for resetting this are trite: I have trouble remembering 7 digits when investigating problems, we have home-grown programs/reports that had to be modified to handle more digits, stuff like that. I also have a nagging fear that somewhere in the database, we'll overflow some internal value and something unpredictable will happen (after all, there are some outstanding issues with counters in other places in the database code that have been "too difficult to fix" for years and years now).

But I guess the main reason that I decided to ask the list about this (I didn't think it important enough to open an incident for), is that when I did try to reset the session number, I got very strange results. The next session number assigned went down from the 4 millions to the 17000's and then back up to 3 million something and then back up to the 4 millions in a matter of moments. I just don't think a computer should act so irrationally. I was hoping it would help if I knew how this process is supposed to work.

Thanks for ANY info/thoughts/jokes,

Anomy

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