RE: Logbackup failed - ISAM error: cannot allocate memory.
I would not be running 9.30.UC2 - upgrade.
I presume you have SHMVIRTSIZE 800Mb and SHMADD 1Gb. There is a total 2.6Gb shared memory.
There is plenty free now, but you need to find what requires that large amount of shared memory. When it runs out your system will want to add another 1Gb of shared memory, which it cannot.
You need to determine if your application or engine has a memory leak - or do you have sufficient users to consume this large amount of shared memory.
I would configure SMHADD much smaller and possibly SHMVIRTSIZE larger, if it is necessary.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of M.J.R.
> Sent: Thursday, 5 August 2004 2:49 a.m.
> To: informix-list@iiug.org
> Subject: 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
> > >>unexpectant