Re: Informix just STOPS?

Just a shot in the dark, but issue an onstat -l (while this condition exists) and see if your logical logs are all %100.00 full. The engine will appear to hang if it can not write to the logical logs. -- Regards, Walter S. Tyszka (wstyszka@ingr.com) * Standard disclaimers apply * > In article <34F468E9.189F@bloomberg.com>, > "Art S. Kagel" <kagel@bloomberg.com> wrote: > > >Ray Garrison wrote: > >> > >> Running OnLine 7.23.UC1 > >> HP UX 11.0 > >> D250 X 2, Gig RAM > >> > >> When running, well, just about anything that takes a while > >> and results in lots of reads (buffer, page, whatever) the > >> damn engine just stops and sits there. For example, I just > >> ran an update statistics for table(tabname) from the ISQL > >> menu. Table is fairly large (120 million rows, about 8 gigs > >> of space). Process runs for a few hours, then just stops. > >> ISQL window sits there with Running... displayed. If I > >> look at onstat -u I see the process, flagged as in a Read > >> mode. nreads and nwrites never increment. Using HP Glance > >> I see the system working hard when the process starts, avg > >> 40% CPU utilization, 75% disk utilization. Then, boom. CPU > >> activity drops to idle. No indication that anything has hung, > >> resource run out, I have no clue. Various onstat -g options > >> indicate the process is running, but nothing happens. This > >> is a development box, there is no one else logged on, no other > >> processes running but this one. > > > >Update statistics does a LOT of sorting ESPECIALLY for large tables.> >Most of the sort activity happens in memory and may cause additional > >virtual segments to be created which takes time. > > > >Art S. Kagel > > How much time? In one case, just to be sure that the engine was > truly hung up as opposed to doing something very slooooooowly, I > left the process up while I was out on vacation. Nine days later > nothing had changed... process still showed as alive and in a read > call, nothing incremented, no buffer reads/writes going on, onstat > reports showed no indication of any problems, but nada happening. > > Ray Garrison >