SESSION RESPBUFLEN - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

This control enables users to specify the initial size of the client response buffer for future database sessions. It overrides the buffer length specified in the resp_buf_len entry in CLI’s System Parameter Block (SPB).

Syntax



where the following is true:

DEFAULT
Using the DEFAULT keyword has the same effect as specifying 0, and results in the following values:

Workstation

CLI SPB default

Mainframe

32767 bytes

0
Using 0 has the same effect as specifying DEFAULT, and results in the following values:

Workstation

CLI SPB default

Mainframe

32767 bytes

MAX32
Specifying MAX32 results in the following values:

Workstation

32731 bytes

Mainframe

32705 bytes

MAX64
Specifying MAX64 results in the following values:

Workstation

65535 bytes

Mainframe

65473 bytes

MAX1MB
Specifying MAX1MB results in the following values:

Workstation

1048418 bytes

Mainframe

1048418 bytes

MAX16MB
Specifying MAX16MB results in the following values:

Workstation

16775168 bytes

Mainframe

16775168 bytes

256..n
A number between 256 and n can be specified for the buffer length, where n is equivalent to the MAX16MB value for BTEQ.

Usage Notes

This command sets the initial size of the client response buffer. However, CLI will automatically increase the buffer if needed to handle larger responses. Use caution when setting the SESSION RESPBUFLEN value above MAX1MB, since a large amount of memory will be initially allocated for this purpose. And be aware that memory consumption could be significantly higher, particularly if multiple sessions are being used.