Short text
Continue with Single Execution when SQL Package is full
Parameter Description
Setting this to true (1) results in DBSL reacting to a package overflow errors during SQL statement preparation by re-designating and re-preparing the SQL statement as single execution. When this condition occurs, a SYSLOG entry D52 is written. We advise opening an OSS Ticket to BC-DB-DB4 so we have an opportunity to assist you in adding an appropriate profile parameter (dbs/db4/dbsl_tablehint) to optimize SQL statement management performance.
Application Area
Database
Default Value
1
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
Boolean value, case-insensitive:
1, on, yes, true — Auto-fallback to Single Execution is enabled
0, off, no, false — Auto- fallback to Single Execution is disabled
