Solution : https://service.sap.com/sap/support/notes/825392 (SAP Service marketplace login required)
Summary :
When starting SAP programs with DB2 version 08.02.0002 or higher, the database connection may close if the registry variable "DB2_WORKLOAD=SAP" is not active. This variable, essential from DB2 V8.2.2 (Fixpak 9), optimizes the system for SAP environments. Users experiencing this issue should verify their DB2 registry settings using the "db2set -all" command, which shows whether "DB2_WORKLOAD=SAP" is active and lists the optimized settings triggered by this variable. If inactive, activating this variable is crucial. Additionally, ensure the software installation aligns with SAP's guidelines for DB2 V8.2.2 or later versions.
Key words :
terms db6 db2udb udb reason, start sap programs, relevant sap notes, db2 registry settings, db2 registry variables, ] db2_evaluncommitted=yes_deferiscanfetch [db2_workload][, ] db2_antijoin=extend [db2_workload][, db2 registry, registry variable, db2 version 08
Related Notes :
| 1429324 | Improvement of the runtime behavior of RC1PHDEL |
| 940551 | DB6: Installing FixPak V8.1/V8.2 (up to FP8) on UNIX |
| 940550 | DB6: Installing FixPak V8.1/V8.2 (up to FP8) on Windows |
| 603981 | DB6: Installing V8.2 FixPaks (as of FP9) on Win NT/Win 2000 |
| 603972 | DB6: Installing V8.2 FixPaks (as of FixPak 9) on UNIX |