Lately I experience below errors when restoring db2 database
- SQL2043N Unable to start a child process or thread
- SQL1084C Shared memory segments cannot be allocated
db2stop and then
db2start always helps.
As a part of my job (testing) I restore databases often during the day.
Current usage can be decreased via deactivating databases when is it really close to
Memory Limit. But lately only deactivation didn't help and I was still getting these errors. Then I found out that
HWM usage might be the trouble part as it is only increasing and after I do db2stop & db2start both
Current usage &
HWM usage are reset.
Is there any other way how to 'clear/reset' HWM on db2?
- DB2 9.7.2 on SuSE