Re: Lockups!

In article aa4@emory.mathcs.emory.edu, informix@asl3.asl-labs.bc.ca (Informix Sysadmin) writes: >We've recently been enduring a spate of lockups. > >Scenario...The sqlturbo process starts up and goes NOWHERE. > >any user on the database gets complete freeze. > >The usual check of tbstat -l shows that we have lots of log space, but >that a checkpoint is required. > >An attempt at tbmode -c goes off for a while, and then returns the >prompt, having NOT done a checkpoint, but certainly NOT told us about any >error. > >"Force checkpoint" from the online menu locks tbmonitor menu up solid. > >We can take the database offline with an "Immediate shutdown", but this >is not really an acceptable solution. Anyone have any ideas why this is >happening? Do you need more info? If so, I can gather at the next >occurence. > >Brian P. Hampson > We have encounted this problem several times. Informix has indicated that there are some problems when SHMEM becomes fragmented. We have increased our initial SHMEM size such that no memory is dynamically allocated. This has reduced the frequency of the problem, but every once in a while, we get stuck in a checkpoint. This is still an open case. ------------------------------------------------------------------------------- . . | ... ... | John M. Shoemaker internet: shoe@forte.sps.mot.com ..... ..... | Senior Software Engineer voice: (602) 244-6074 fax: 5898 .. ... .. | Business Integration Group pager: (602) 219-1679 . . . | Semiconductor Products Sector | 5005 E McDowell Road Motorola-SPS | Phoenix, AZ 85008 ------------------------------------------------------------------------------- EXEC SQL include "disclaimer.h" -------------------------------------------------------------------------------