Re: Statistics causing Shared Memory Problems

Have you tried to see what updating your whole db with high does? You also did not state what version of Informix or hardware you are running on? This is very interesting! I'm have a Informix 7.12 on UNIX AIX 4.2 machine I could try this on. I would need the length of the record though? Yet I do not have a table with 120 columns in it. How many pages does the table contain? Send me the schema and good size amount of data and I could try it out (of course tar and gzip/zip the attachment). If you figure it out without my help besure to let me know the fix! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Mon, 15 Apr 1996, Andrew J. Saville wrote: > I am having an interesting problem after changing some of our update scripts. Each > night we load mainframe data and update existing tables and insert new information. > In the past, I have been updating statistics in individual fields to high, but > changed this to update the whole table - about 250,000 recs - 120 fields. This takes > over an hour, and forces online to grab new shared memory segments. Well, while it > is doing this, users get locked out of the system - the login's hang, and I get > unable to allocate memory errors during query processing in dbaccess. It grabbed so > many shared memory segments one time that the online.log said the kernel parameters > had been overloaded. Is this normal behavior??? The speed increases on the table > after it is done are incredible!!! I hate to revert back to the old way - or can I do > this once a week?? > > James Saville >