Symptom
You find that the database instance shuts down unexpectedly without explicit errors
In the db2diag.log, you see the following warning listed prior to the shutdown:
2022-01-01-00.00.00.000000+000 E713884E693 LEVEL: Warning
PID : 123 TID : 140304132859648 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000
HOSTNAME: dbhostname
EDUID : 208 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:20
DATA #1 : <preformatted>
Reserved heap size exceeded for Kernel(BSU) Heap on node 0,
allocating additional unreserved memory.
Requested block size : 37200 bytes.
Physical heap size : 35323904 bytes.
Configured heap size : 35192832 bytes.
Unreserved memory used by heap : 131072 bytes.
Unreserved memory left in set : 24182784 bytes.
This error can seen under the following most often:
- New instance build
- System copy
- Unexpected large job run requiring high sorts
- Changing to use of BLU tables
Read more...
Product
Keywords
KBA , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview