dbs/db4/keep_tmp_SQLpkgs SAP Parameter attribute - Do not delete SQL packages for single-execution statements at system r

dbs/db4/keep_tmp_SQLpkgs is a SAP Parameter attribute which is used to control Do not delete SQL packages for single-execution statements at system r 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/keep_tmp_SQLpkgs profile paramerter attributes

Parameter Name: dbs/db4/keep_tmp_SQLpkgs
Description: Do not delete SQL packages for single-execution statements at system restart
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: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

SQL packages that are assigned SQL statements that are not intended for reuse (SINGLE_EXECUTION) are normally automatically removed when the SAP system is restarted, to save space. These are the SQL packages in the library R3<(><<)>sid>Y0000. if dbs/db4/keep_tmp_SQLpkgs = 1, the cleanup is not performed. This can be useful on a temporary basis during troubleshooting, but should otherwise be avoided.

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