Re: Logbackup failed - ISAM error: cannot allocate memory.

The following stats were taken while the instance is running ok ... after I bounced it and was able to restart ontape -c. If/when it decides to give the ISAM error again, I'll redo the commands and repost. BTW ... the online.log file gave this message, too: shmat: [EMFILE][24]: out of shared memory segments,check system SHMSEG Is SHMSEG an AIX enviroment available? onstat -g seg reveals:Segment Summary: id key addr size ovhd class blkused blkfree 1703937 1381451777 30000000 751370240 237716 R 183413 27 917506 1381451778 60000000 805306368 25176 V 23091 173517 2490373 1381451779 90000000 1048723456 32608 V 8 256028 Total: - - 2605400064 - - 206512 429572 (* segment locked in memory) onstat -l reveals:Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 8 16 348 30 11.60 phybegin physize phypos phyused %used 300035 2000 278 24 1.20 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 7 16 16601 697 71 23.8 9.8 Subsystem numrecs Log Space used OLDRSAM 16601 2764148 address number flags uniqid begin size used %used 601a9900 4 U-B---- 12288 400435 1024 1024 100.00 601a9938 5 U-B---- 12289 400835 1024 1024 100.00 601a9970 6 U-B---- 12290 400c35 1024 1024 100.00 601a99a8 7 U-B---- 12291 401035 1024 1024 100.00 601a99e0 8 U-B---- 12292 401435 1024 1024 100.00 601a9a18 9 U-B---- 12293 401835 1024 1024 100.00 601a9a50 10 U-B---- 12294 600803 1024 1024 100.00 601a9a88 11 U-B---- 12295 600c03 1024 1024 100.00 601a9ac0 12 U-B---- 12296 601003 1024 1024 100.00 601a9af8 13 U-B---- 12297 601403 1024 1024 100.00 601a9b30 14 U-B---- 12298 601803 1024 1024 100.00 601a9b68 15 U---C-L 12299 601c03 1024 509 49.71 601a9ba0 16 U-B---- 12250 602003 1024 1024 100.00 601a9bd8 17 U-B---- 12251 602403 1024 1024 100.00 601a9c10 18 U-B---- 12252 602803 1024 1024 100.00 601a9c48 19 U-B---- 12253 602c03 1024 1024 100.00 601a9c80 20 U-B---- 12254 603003 1024 1024 100.00 601a9cb8 21 U-B---- 12255 603403 1024 1024 100.00 601a9cf0 22 U-B---- 12256 603803 1024 1024 100.00 601a9d28 23 U-B---- 12257 603c03 1024 1024 100.00 601a9d60 24 U-B---- 12258 604003 1024 1024 100.00 601a9d98 25 U-B---- 12259 604403 1024 1024 100.00 601a9dd0 26 U-B---- 12260 604803 1024 1024 100.00 601a9e08 27 U-B---- 12261 604c03 1024 1024 100.00 601a9e40 28 U-B---- 12262 605003 1024 1024 100.00 601a9e78 29 U-B---- 12263 605403 1024 1024 100.00 601a9eb0 30 U-B---- 12264 605803 1024 1024 100.00 601a9ee8 31 U-B---- 12265 605c03 1024 1024 100.00 601a9f20 32 U-B---- 12266 606003 1024 1024 100.00 601a9f58 33 U-B---- 12267 606403 1024 1024 100.00 601a9f90 34 U-B---- 12268 606803 1024 1024 100.00 601a9fc8 35 U-B---- 12269 606c03 1024 1024 100.00 60106ac0 1 U-B---- 12270 400035 1024 1024 100.00 60106af8 2 U-B---- 12271 600003 1024 1024 100.00 60106b30 3 U-B---- 12272 600403 1024 1024 100.00 60106b68 36 U-B---- 12273 607003 1024 1024 100.00 60106ba0 37 U-B---- 12274 607403 1024 1024 100.00 60106bd8 38 U-B---- 12275 607803 1024 1024 100.00 60106c10 39 U-B---- 12276 607c03 1024 1024 100.00 60106c48 40 U-B---- 12277 608003 1024 1024 100.00 60106c80 41 U-B---- 12278 608403 1024 1024 100.00 60106cb8 42 U-B---- 12279 608803 1024 1024 100.00 60106cf0 43 U-B---- 12280 608c03 1024 1024 100.00 60106d28 44 U-B---- 12281 609003 1024 1024 100.00 60106d60 45 U-B---- 12282 609403 1024 1024 100.00 60106d98 46 U-B---- 12283 609803 1024 1024 100.00 60106dd0 47 U-B---- 12284 609c03 1024 1024 100.00 60106e08 48 U-B---- 12285 60a003 1024 1024 100.00 60106e40 49 U-B---- 12286 60a403 1024 1024 100.00 60106e78 50 U-B---- 12287 60a803 1024 1024 100.00 50 active, 50 total > From: The Big Potatoe <JJ@Nospam.Com> > To: informix-list@iiug.org > Subject: Re: Logbackup failed - ISAM error: cannot > allocate memory. > Date: Wed, 04 Aug 2004 09:50:32 GMT > > Murray Wood (IList) wrote: > > > What does onstat -g seg say? > > > > > >>-----Original Message----- > >>From: owner-informix-list@iiug.org > >>[mailto:owner-informix-list@iiug.org]On Behalf Of > M.J.R. > >>Sent: Wednesday, 4 August 2004 10:08 a.m. > >>To: informix-list@iiug.org > >>Subject: Logbackup failed - ISAM error: cannot > allocate memory. > >> > >> > >>Hi all! > >> > >>We are running an AIX 4.3 IBM machine with > Informix > >>9.30.UC2 with a spatial data engine. The machine > has > >>7gb memory. We have ontape -c continuous logging > >>running so the logs get backed up immediately. > >>Sometimes the ontape -c command terminates > >>unexpectantly, and when we try to restart it we > get a > >>"Logbackup failed - ISAM error: cannot allocate > >>memory." error and it doesn't run. The only way I > >>know of getting it to work again is to bounce the > >>database, which our users don't appreciate for > some > >>reason. The SHMVIRTSIZE is set to 786432. Should > we > >>increase this value to avoid this problem? > >> > >>TIA ... much appreciated! > >> > >> > >> > > > > sending to informix-list > > What does onstat -l show? Just interested in the > LOGBUFF settings and usage. > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail sending to informix-list

"M.J.R." <doomdogak@yahoo.com> wrote in message news:cequa1$m99$1@news.xmission.com... > > The following stats were taken while the instance is > running ok ... after I bounced it and was able to > restart ontape -c. If/when it decides to give the > ISAM error again, I'll redo the commands and repost. > BTW ... the online.log file gave this message, too: > shmat: [EMFILE][24]: out of shared memory segments,> check system SHMSEG > > Is SHMSEG an AIX enviroment available? It's a kernel parameter.