Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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
share|improve this question
    
How do you know those errors are related to the high water mark (and for what tables)? What operations lead to these errors? –  Nick Chammas Nov 15 '11 at 5:25
    
@Nick: I updated my question. –  Radek Nov 15 '11 at 5:39

1 Answer 1

up vote 0 down vote accepted

From what I have seen reaching a High Water Mark means approaching some established limit. There are multiple "high water marks" in DB2 depending on which area you are talking about. Some relate to memory used for sorting/joining. Others relate to maximum agents allowed or differing heap sizes, or even package caching.

I'd recommend taking a look at this article on developerworks. Though it was written for an older version of DB2 (8.1), it still holds valuable nuggets for what parameters to tune when to get what you are looking for. I recommend taking a peek at it. If you search for high water mark on the page you find all the different instances I was referring to and which parameters tune them.

Also, take a look to see if you are running any hash joins and how many. This article is also helpful for understanding which parameters can be tuned that affect hash joins and certain usages of memory.

share|improve this answer
    
Ok info, but doesn't actually answer the question. –  ivanmp Feb 19 at 19:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.