Parameter
dbs/db4/keep_tmp_SQLpkgs
Short text
Retain temporary SQL packages despite SAP restart
Parameter Description
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
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.
Application Area
Database
Default Value
0
Who is permitted to make changes?
Only on the recommendation of, and following instructions from, SAP Support.
Database System Restrictions
This parameter is only evaluated for DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
1 — Retain temporary SQL packages
0 — Delete temporary SQL packages as usual
