Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

rsdb/max_blocking_factor - Split factor for FOR ALL ENTRIES queries

rsdb/max_blocking_factor - Split factor for FOR ALL ENTRIES queries

ABAP Short Reference   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : rsdb/max_blocking_factor |
------------------------------------------------------------------------

------------------------------------------------------------------------
Short description: 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. |
| The profile parameter defines the upper limit for the number of |
| [itab] entries to be processed in a single statement. That is, if |
| internal table specified in the FOR ALL ENTRIES clause has more than |
| rsdb/max_blocking_factor rows, the Open SQL statement is divided |
| multiple steps with regard to the database. Their individual results |
| are collected in the database interface and then returned to the |
| ABAP program as the entire result. This means that for an internal |
| table with N rows,
| |
| |
| N / "rsdb/max_blocking_factor" + 1 |
| |
| individual SELECT statements are performed on the database. |
| However, this parameter has no effect on the mapping for IN (...) - |
| see the documentation for rsdb/prefer_in_itab_opt. |
| |
| The technical maximum blocking factor is also calculated for each |
| statement, to ensure that no database system limits are exceeded. |
| If the blocking factor limit is smaller than max_blocking_factor, |
| this limit is implicitly used. |
| |
------------------------------------------------------------------------

------------------------------------------------------------------------
| 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: 10 |
| DB2 UDB: 10 |
| Informix: 20 |
| iSeries: 20 |
| MaxDB: 10 |
| MS SQL Server: 50 |
| Oracle: 15 |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
| rsdb/prefer_in_itab_opt |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : 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
------------------------------------------------------------------------


ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 7278 Date: 20211201 Time: 193424     sap01-206 ( 5 ms )