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.