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

On 4 Mar 2005 04:38:06 -0800, malc_p@btinternet.com wrote: >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 No one creating large indexes? JWC