Parameter
dbs/db4/dbsl_buffersize
Short text
Maximum number of bytes transferred per SQL Fetch
Parameter Description
dbs/db4/dbsl_buffersize specifies the maximum number of bytes transferred per request. Larger buffers may improve performance when fetching large number of database rows.
Application Area
Database
Parameter Unit
Bytes
Default Value
131072
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
Integer value
