Parameter
dbs/db4/single_execution_reuse
Short text
Deactivation of the database hint ‘SINGLE_EXECUTION’
Parameter Description
If you set this parameter, it deactivates parts of the effect of the database hint ‘SINGLE_EXECUTION’. Although affected SQL statements are prepared in special, temporary SQL packages, existing statement resources are not necessarily released again immediately.
Setting this parameter can have a significant effect on system performance.
Application Area
Database
Default Value
0
Who is permitted to make changes?
Only on the recommendation of SAP Support.
Database System Restrictions
This parameter is only evaluated for DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
0 — ‘SINGLE_EXECUTION’ works as normal
1 — ‘SINGLE_EXECUTION’ is partially deactivated
