Teradata Sessions - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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