Parameter
dbs/db4/single_execution_threshold
Short text
Maximum number of SQL statements per temporary SQL package
Parameter Description
SQL packages are restricted in size, depending on the database version. You can use this parameter to define the maximum number of SQL statements for each temporary SQL package. It can be useful to reduce the default value if statements are exceptionally complex, meaning that the estimated space required for each statement is not sufficient.
(Temporary SQL packages means packages in the library R3[sid]Y0000, which include SQL statements with the database hint ‘SINGLE_EXECUTION’. For background information, see SAP Note 481868.)
Application Area
Database
Default Value
2000
Who is permitted to make changes?
DB administrator
Database System Restrictions
This parameter is only evaluated for DB2 for IBM i.
Are other parameters affected or dependent?
Only on the recommendation of SAP Support.
Values allowed
Integer value