Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 19:10:40 GMT

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

Subj:   Re: Question on Concurrent sessions
From:   Anomy Anom

<-- Anonymously Posted: Thursday, March 31, 2005 13:41 -->

  we do select * from dbc.sessioninfo and load into a table.  

  we use crontab to run this on regular basis.  

The crux of the issue is if user 'A' has 3 rows in the table (doesn't matter whether Logonoff or sessioninfo) with same logondates and different logontimes with a difference of a second or some time none at all, how do you know that these 3 rows are concurrent sessions created by one web user or by 3 different sessions created by 3 different users...? BTW we are on Windows platform.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023