Re: online crash

ptash@iconz.co.nz (Peter Tashkoff) writes: >rswa@perth.DIALix.oz.au (Radio Spares) wrote: >>Dear All, >>I have come across this problem with online 7.10.UC1 on a Spacr 5 running >>Solaris 2.4. I have a cursor that does a count on 1 table with a where cause >>of 1 = 1. The count works but when the cursor is closed it brings the >>engine down (see online log below). --snip-- >I can't be sure (I am at home) but I think your error is similar to >one I received several weeks ago. Anyhow it is worth a check. >PDQ in UC1 is buggy. If you have it turned on then it's a good idea >to turn it off by setting PDQ priority to zero in onmonitor. >Symtoms of the problem are - Shared memory not being freed up nicely >and lots more shared memory than you would expect being used up. >onstat -g seg shows segments holding 3 or 4 pages open even when no>one is connected. For a period of time I was rolling online every >morning to clean up shared memory >Setting PDQ to zero has meant a hugely smaller signature in shared >memory and the system runniing clean as a whistle. I am told the fix >is in UD1 but I am holding out until 7.2 (next month?) as it is not a >problem for us performance-wise. >HTH >Peter Tashkoff >Auckland, New Zealand >e-mail ptash@iconz.co.nz Ditto to Peter's answer - setting PDQPRIORITY to 0 fixed a very similar problem for us, and we just (hours ago :) installed UD1 and the problem seems to be fixed. This is on HP-UX 10.01, same problem on DEC OSF1 3.2 with the 7.10 UC1 we have on there. jeffb -- Microsoft Network is prohibited from redistributing this work in any form, in whole or in part. Copyright, Jeff Bartoszewicz, 1995. License to distribute this post is available to Microsoft for $1000. Redistribution without permission constitutes an agreement to these terms. Please send notices of violation to Postmaster@microsoft.com ------------------------------------------------------------------------------- Jeff Bartoszewicz jeffb@netcom.com Give me some slack... JFB Associates, Inc. Canter & Siegal Must Be Annoyed or KILL me. fnord.