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.