Ansicht
Dokumentation

rsdb/min_blocking_factor - Min. split factor for FOR ALL ENTRIES queries

rsdb/min_blocking_factor - Min. split factor for FOR ALL ENTRIES queries

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : rsdb/min_blocking_factor |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Min. split factor for FOR ALL ENTRIES queries |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| This parameter is for internal use only and must never be |
| changed without the prior consent of SAP. |
| |
| An internal table [itab] with input data is always transferred in |
| case of an ABAP SELECT request with the addition FOR ALL ENTRIES. |
| If this parameter is set to a value greater than "0" AND |
| rsdb/prefer_fix_blocking is set to "1", two different blocking |
| factors are used: a smaller (min_blocking_factor) and a larger |
| factor (max_blocking_factor). |
| |
| The min_blocking_factor is, however, only used if there are only a |
| few entries in [itab]; to simplify it somewhat, if |
| "Entries([itab]) < max_blocking_factor / 2" applies. |
| |
------------------------------------------------------------------------

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

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

------------------------------------------------------------------------
| Default value: |
| The default value is database-dependent. For technical reasons, it |
| is unfortunately necessary to enter a common, artificial value (-1). |
| The original default values for each database system are listed
| below. Caution: Since these values can be changed by kernel patches, |
| it is important that you obtain the current default values from SAP |
| Note 48230. |
| |
| DB2/390: 3 |
| DB2 UDB: 10 |
| Informix: 0 |
| iSeries: 10 |
| MaxDB: 0 |
| MS SQL Server: 5 |
| Oracle: 10 |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
| rsdb/prefer_fix_blocking, rsdb/max_blocking_factor |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : Min. split factor for FOR ALL ENTRIES queries
------------------------------------------------------------------------

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

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

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

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

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

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


PERFORM Short Reference   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 6443 Date: 20240328 Time: 225156     sap01-206 ( 6 ms )