IDS Forum

Re: Lock Table Overflow

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Tuesday, 16 May 2006, at 12:23 p.m.

In Response To: Lock Table Overflow (EILEEN LITTLER)

Get my package utils3_ak from the IIUG Software Repository and compile and
install the eventalarm.c in ALARMPROGRAM instead of log_full.sh. It will handle
multiply occurring events like the lock table overflow event by ignoring all by
the first to arrive in a given configurable period of time. The config file,
eventalarm.cfg, is used to change the time period over which multiple events are
ignored. Eventalarm also has other functionality. As it is currently coded it
will archive each logical log as it fills using ontape -a and email a list of
addresses when critical events occur. The mulitply occurring events feature
causes the program to exit very quickly, unlike log_full.sh, if a multiple event
is detected and will send only one email during each of the ignore periods if
the events continue for longer than the configure time period (30 minutes in
the sample config file). Eventalarm.c also detects when another copy of itself
is already running and also exits quickly to allow the prior copy to handle the
event.

Art S. Kagel

----- Original Message -----
From: Eileen Littler <ids@iiug.org>
At: 5/16 11:50:52

IDS 7.31.UD2 AIX 5.2.0.0 (ml 2)
Twice today we have encountered Lock Table Overflows which have caused many
problems for us.

We use the log_full.sh script as a basis for trapping certain information when
this occurs (using ALARM type 21 - Resource Overflow), and when we have the
diagnostic information from the first time that the log_full script is run we
tell the log_full script to exit. However it appears that Informix is spawning
many more log_full scripts than the Operating System can cope with. We have
MAX Process set to 256 (per user, excluding root) and before each script is
getting to the exit point we have exceeded the 256 process limit and the
server starts to struggle. We receive message "0403-030 The fork function
failed. Too many processes already exist" when trying to su to informix.

Do you know if there are any values we can set within Informix to combat this,
(obviously we need to address the resource overflow in the application).

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Lock Table Overflow
  EILEEN LITTLER -- Tuesday, 16 May 2006, at 11:47 a.m.
  • RE: Lock Table Overflow
    Marcus Haarmann -- Tuesday, 16 May 2006, at 12:00 p.m.
  • Re: Lock Table Overflow
    David Williams -- Tuesday, 16 May 2006, at 12:04 p.m.
  • Re: Lock Table Overflow
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Tuesday, 16 May 2006, at 12:23 p.m.
    • Re: Lock Table Overflow
      Peter_Logan@spartanstores.com -- Tuesday, 16 May 2006, at 1:16 p.m.
      • Re: Lock Table Overflow
        ART KAGEL, BLOOMBERG/ 731 LEXIN -- Tuesday, 16 May 2006, at 1:47 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.