Ansicht
Dokumentation

dbs/inf/insert_buffer_size - size of buffer for 'cursor insert'

dbs/inf/insert_buffer_size - size of buffer for 'cursor insert'

General Material Data   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/inf/insert_buffer_size |
------------------------------------------------------------------------

------------------------------------------------------------------------
Short description: Size of buffer for 'cursor insert'
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
This parameter defines the size of the data buffer, in which the
'home rows' of the data records to be inserted through the
'cursor insert' (data records without the extra BLOB data stored
for Informix) are written.
| |
The size of this buffer implicitly defines the number of
data records transferred in a packet. This packet is a logical
packet, which is split up if necessary by the network
software.
| |
Caution:
| -------- |
The default value is generally the best value. A different value
can have a negative influence on performance.
------------------------------------------------------------------------

------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Unit: Bytes |
------------------------------------------------------------------------

------------------------------------------------------------------------
Default value: 4096
------------------------------------------------------------------------

------------------------------------------------------------------------
Who is permitted to make changes: SAP
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Limitations for database systems: Informix |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
------------------------------------------------------------------------

------------------------------------------------------------------------
Valid entries, formats, areas: Integer value from 0 to 32,767
------------------------------------------------------------------------


------------------------------------------------------------------------
| Short Description : size of buffer for 'cursor insert'
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Minimum : 0
------------------------------------------------------------------------

------------------------------------------------------------------------
| Maximum : 32767
------------------------------------------------------------------------


CPI1466 during Backup   General Material Data  
This documentation is copyright by SAP AG.

Length: 5193 Date: 20240426 Time: 151750     sap01-206 ( 6 ms )