Re: Select hangs - Help!

In article <1994Mar7.050135.2628@nezsdc.icl.co.nz>, steve@nezsdc.icl.co.nz (Steve Chell) says: > >Can anyone shed any light on the following problem. > >Twice over the past four weeks, one of our customers has reported >that their entire suite of Informix 4GL application programs >(developed and supported by us) suddenly hang. > >On further investigation I discovered that one table was causing the >problem (although it was a different table on each occasion): >if I attempted to select from the suspect table, the select would hang. >Selecting from other tables worked fine. The reason why the customer >reported that the whole suite of programs were hanging is because >each program selects from both of these tables as part of the program >initialization procedures. > >On rebooting the machine I checked for database corruptions using bcheck. >There were none. I therefore conclude that it might be some sort of >locking problem. However, both tables that were involved are rarely >updated (and then only by hand - never by a batch job). As I have >already suggested, they are read (selected) from a lot. To my knowledge >no programs set the lock mode to wait. > >Has anyone else had any similar experiences? Hi Steve, If the tables are really BIG, you should check the empty space in rootdbs to see if Informix has enough space to do its temporary tables while querying (or joining) tables. HTH. Alain (Alain.Leroy@csl.sni.be)