Archives of the TeradataForum

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

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

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>>