Parameter
dbs/db4/dbsl_alternate_package
Short text
Switch to an alternate set of SQL packages
Parameter Description
This can, for example, be useful to force the re-prepare of a statement for diagnostic purposes, or to overcome an “SQL package full” condition (SQL0904 error, type 7) without having to restart SAP immediately.
To cause SQL statements to be re-prepared without deleting the SQL packages, modify the dbs/db4/dbsl_alternate_package in one of the following ways:
1. In the instance profile; to affect the SAP instance at startup.
2. Dynamically for a single workprocess or entire instance via transaction RZ11.
To overcome an SQL0904 condition, set the parameter for all servers.
Note that the parameter works as a toggle between two package sets, ‘0’ stands for the standard package set, ‘1’ for the alternate set. Once you have used both sets, you have to delete SQL packages to get any benefit from a switch again. If you start the SAP system with dbs/db4/dbsl_alternate_package == 1 after having deleted SQL packages, you may switch the package set by setting dbs/db4/dbsl_alternate_package = 0.
When changed dynamically, the developer traces for the affected workprocesses show:
dbsl_alternate_package = On
or
dbsl_alternate_package = Off
For more information, see SAP Note 972460.
Application Area
Database
Default Value
blank
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
1 — Use alternate set of packages
0 — Use standard set of packages
