All Forums Database
udayp 2 posts Joined 05/16
17 May 2016
how to determine concurrent Instances/connection

Hi,
How many concurrent connections allowed to a particular teradata box?
How many maximum instances are allowed OR is there any calculation need to be done to get it?
Can anyone please help me on this?

dnoeth 4628 posts Joined 11/04
17 May 2016

What do you mean by connections and instances?
By default there are 2 Parsing Engines per node, each supports up to 120 sessions, so usually it's 240 sessions * number of nodes.

Dieter

udayp 2 posts Joined 05/16
17 May 2016

I mean to say in one teradata session how many connections can be allowed?
 

dnoeth 4628 posts Joined 11/04
18 May 2016

A session (LOGON ...) is a connection.
Within an application you can open multiple sessions.

Dieter

tomnolan 594 posts Joined 01/08
18 May 2016

There is one, and only one, TCP socket connection per Teradata Database session.
 
However, note that a "JDBC connection" is a different concept from a "TCP socket connection".
 
In particular, with a JDBC FastLoad or JDBC FastExport connection, the Teradata JDBC Driver will log on multiple Teradata Database sessions "behind the scenes" for each FastLoad or FastExport operation.

You must sign in to leave a comment.