15.10 - Sessions - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

A 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

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