dbs/db4/dbsl_alternate_package SAP Parameter attribute - Switch to an alternate set of SQL packages

dbs/db4/dbsl_alternate_package is a SAP Parameter attribute which is used to control Switch to an alternate set of SQL packages information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/db4/dbsl_alternate_package profile paramerter attributes

Parameter Name: dbs/db4/dbsl_alternate_package
Description: Switch to an alternate set of SQL packages
Default Value: 0
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DB4
System-Wide parameter: No
Dynamic Parameter: Yes
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

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: In the instance profile; to affect the SAP instance at startup. 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.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.