Re: Shared Memory Not released

cphdcbl@ted.cs.depaul.edu (Brian Li) wrote: >Dear Informix experts, >We are currently have Informix Dynamic Online running on our HP T500 machine >and recently have shared memory problem which is only known to be solved >by brining down and up the database instance(DBA's said so). >It appears that shared memory used by threads cannot be released even after >application is close. >I would highly appreciate if anyone can provide me some hints or point me >to the correct direction. Thanks. >Following is a log from onstat -m command:- >Message Log File: /d2/informix/online.log >13:20:49 size of resident + virtual segments 162562048 + 362864640 > 512000000> total allowed by configuration parameter SHMTOTAL >13:20:49 out of virtual shared memory >13:20:49 Assert Failed: WARNING! No memory available for page cleaners >13:20:49 Who: Thread(43, flush_sub(0), cadf2444, 3) >13:20:49 Results: OnLine may be unable to complete a checkpoint >13:20:49 Action: Make more virtual memory available to OnLine >13:20:49 See Also: /tempfile/af.3e5ec3 >13:20:49 size of resident + virtual segments 162562048 + 362864640 > 512000000> total allowed by configuration parameter SHMTOTAL >13:20:49 out of virtual shared memory >13:20:49 Assert Failed: WARNING! No memory available for page cleaners >13:20:49 Who: Thread(43, flush_sub(0), cadf2444, 3) >13:20:49 Results: OnLine may be unable to complete a checkpoint >13:20:49 Action: Make more virtual memory available to OnLine About a year ago we had a 7.11 system running on a 8 way t500 at hpux 10.01. We started crashing every hour or so out of virtual shared memory once the system was turned up for production. Our problem was the 7.11 tapes were for hp 9.04 not 10.x. Once we installed the right tapes the problem went away. Another thing is if you are taking extra virtual segments on a 7.x system the onmode -F will release any that are no longer used for reuse. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com