The STRMBUFFERS configuration parameter

The STRMBUFFERS parameter sets the number of server-stream buffers per device. The onpload utility sends data to the database server through a server stream. The server stream is a set of shared-memory buffers. The memory for the server-stream buffer is allocated from the memory allocated for the database server.

Each device has a separate server stream with STRMBUFFERS buffers. Thus the total number of stream buffers is as follows:
STRMBUFFERS * numdevices
where numdevices is the number of devices in the current array.
Default value
Maximum of (4,2*CONVERTTHREADS)
Recommended value
Maximum of (4,2*CONVERTTHREADS)
Range of values
Integer > 4
Assess information for loading or unloading external data

Copyright© 2019 HCL Technologies Limited