- Change Options to 'Y'.
- Set the Two Response Buffers value to the appropriate value:
Y, if the response is to be double-buffered.
N, if a single buffer is to be used for the response.
Double buffering is useful when large responses are expected from the database and large response buffers are used. Substantial improvements in response time can result by transferring the next buffer-full of response data from the database while the previous buffer-full is being accessed by the application program.
The response buffer or buffers are re-stocked automatically by DBCHCL. The application program may have to wait for data to arrive if the application program is consuming the data faster than the database can re-stock the buffer, but it does not have to arrange for data to arrive.
Although the value of Two Response Buffers is read and stored by the Connect function, it is not used for the connect operation itself.
Two Response buffers are ignored if the fetch request is for LOB or cursor repositioning responses.