Cursor buffer

The DBH stores the intermediate results produced by retrieval statements in the cursor buffer.

If the size chosen for the cursor buffer is too small and the buffer overflows, the data in the cursor buffer is written to one or more internal cursor files (see section “Cursor files for retrieval statements”).

To keep access to the cursor files to a minimum, system administrators can adjust the size of the cursor buffer for the DBH session using a DBH option, and thereby optimize the handling of retrieval statements.

The DBH statistics supplied by the SESAM/SQL utility SESMON help administrators to choose an appropriate size for the cursor buffer (see the “Database Operation” manual).