Database Sessions - Teradata Tools and Utilities

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
lifecycle
previous
Product Category
Teradata Tools and Utilities

A database session is an authenticated, logical connection between the application and the database. Sessions are explicitly connected and disconnected, and while connected provide the vehicle for all communication between an application and the 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, see Teradata® Director Program Reference, B035-2416 and Teradata® Manager User Guide, B035-2428.