A Teradata session is an authenticated, logical connection between the application and a Teradata Database. Sessions are explicitly connected and disconnected, and while connected provide the vehicle for all communication between an application and Teradata Database.
If a session is established for requests that intended to complete quickly, the overhead of establishing and terminating a session may take longer than the actual request. When this is a common occurrence, the overhead may be minimized by using TDP session pools. A session pool establishes sessions once, then allows applications to re-use them. If the logon string for a session matches a session pool, and CLIv2 session options also match session pool attributes, then that session will be used by the application. The CLIv2 DBCAREA options and their correspondence to session attributes on the TDP START POOL command are as follows.
|DBCAREA||START POOL Operand|
|Two-phase commit of 'Y'||TWOPC|
|Transaction-semantics of 'T'||TERADATA|
|Transaction-semantics of 'A'||ANSI|
|Date-form of 'A'||DATEFORM ANSI|
|Date-form of 'T'||DATEFORM TERADATA|
|Language-conformance of '2'||SQL2|
|Language-conformance of '3'||SQL3|
|Statement-status of 'E'||STMTSTAT|
For a full description of TDP session pools, refer to: Teradata Director Program Reference (B035-2416).