SESSION RESPBUFLEN

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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.