Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 23 Aug 2012 @ 19:18:51 GMT


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


Subj:   Re: What exactly a SESSION means?
 
From:   Dave Wellman

Hi Sughesh,

What are you really trying to find out here? A number of people have responded to this thread all with basically the same information.

A session is a logical connection between the program and the DBMS. Having established the session (i.e. logged on) all commands from the program have to issued under that session. In most programming languages / api 's the program will have a numeric identifier for the session. In CLI this is the SessionID, in ODBC (and I think JDBC) it is usually referrred to as a 'connection handle'.

On the DBMS side, you will see a row in dbc.sessioninfo for each currently connected session. Each will have a Session Number.

If a utility has 20 sessions, then it has 20 connected links with the DBMS. Each session can have requests executing through them at the same time.


Cheers,

Dave

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



     
  <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