Re: Informix just STOPS?

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. > > Recently upgraded box from 10.2 to 11.0 in hopes this would fix > the problem. Nada. > > Any clues or other diagnostics I can look at? > > Thanks, > > reply ray@apsnet.com Have similar problem. Query intensive c++ app executes some 15,000-20,000 queries and then just hangs. If I try to open and close a connection after each query it won't let me reconnect after 15,000-20,000 queries. Have spent about a week playing with it and trying to track it down w/o success. Please let me know if you find anything. Am thinking I must have forgotten to get the "Data Mining" datablade which allows more than 20,000 queries from a single app. Thanks, -- Robert Winkler U.S. Army Research Laboratory Beckman Institute, Room 4357 405 North Matthews Ave, Urbana, IL 61801