Parameter
rsdb/max_blocking_factor
Short text
Split factor for FOR ALL ENTRIES queries
Parameter Description
This parameter is only intended for internal use and must not be changed without explicit instruction from SAP.
An internal table [itab] with entry data is always returned to an ABAP SELECT query with the addition FOR ALL ENTRIES. The profile parameter sets the upper limit for the amount of entries from [itab] to be processed in a statement That is, if the internal table included in the FOR ALL ENTRIES clause contains more than rsdb/max_blocking_factor lines, the Open SQL statement is divivded up into multiple statements with regard to the database whose individual results are collected in the DB interface and then returned as a total result to the ABAP program. For an internal table with N lines, with regard to the database
N / “rsdb/max_blocking_factor” + 1
individual SELECT statements are issued. This parameter however does not have any effect in the construction of IN (…) – see the documentation on rsdb/prefer_in_itab_opt.
The technical maximum blocking factor is calculated for each statement so that no database system limits are exceeded. If the flocking factor limit is less than max_blocking_factor then this limit is implicitly used.
Application Area
Database
Default Value
The default value is database-dependent. A common, artifical value (-1) must be specified for technical reasons. The original default values are specified below for each database system. Caution: As these values are changed by kernet patches, take 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
Are other parameters affected or dependent?
rsdb/prefer_in_itab_opt
