SESSION TWORESPBUFS Command | Basic Teradata Query - SESSION TWORESPBUFS - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

This control enables users to specify whether CLI double-buffering is active or inactive. It overrides CLI’s System Parameter Block (SPB) two_resp_bufs entry for client response buffering.

Syntax



where the following is true:

ON
CLI’s double-buffering function is active.

If neither ON or OFF is specified in the command, BTEQ sets SESSION TWORESPBUFS to ON.

OFF
CLI’s double-buffering function is not active.

Usage Notes

The specifications for the SESSION TWORESPBUFS command always override the two_resp_bufs entries for double-buffering in CLI’s System Parameter Block (SPB). In general, use of double-buffering enables performance benefits that cannot be realized when using single-buffering. Therefore, BTEQ specifies a default of ON for this setting. For more information about CLI buffering methods, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.