RE: Sudden & massive SHMADD activity; engine went BANG!

Installed any new software recently (including ODBC connections) ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malc_p@btinternet.com Sent: 04 March 2005 02:38 PM To: informix-list@iiug.org Subject: Sudden & massive SHMADD activity; engine went BANG! IDS9.30HC5; HP-UX11i; largely OLTP; 4ge applications on server; about 150 users. Just now our engine suddenly allocated 48 SHMADD segments in under 5 minutes and af'd itself into oblivion. We normally blithely run with just the initial SHMVIRTSIZE virtual segment and haven't added a SHMADD segment for weeks and weeks; the system is pretty well-behaved as a rule and hasn't af'd for months. The SQL showing in the af file is pretty innoccuous ( I just brought the engine back online and ran the sql; it returns 85 rows so I think I can discount that SQL as the culprit). Trouble is, the system is once again quiet and happy and no SHMADDs and manglement are happily jumping up and down on my squashy DBA bits to try to extract the reason for this turn of events from me and our consequent Service Level Interruption (yea verily and let us all pray from the book of Key Performance Indicators). I know what the Virtual Segment is for and how it may be required to expand but I can't come up with an explanation for the sudden SHMADD activity. All I can do is keep an eye on it and see if it happens again. Can anyone share any clues as to what may have caused it (is there an IDS9.30HC5 bug I need to know about?) and so on. Thanks Malc sending to informix-list