btree invalidation

FAQ

Profile

btree invalidation

Database Forums (Home) -> Informix

Next: Column Naming Too Long

Author

Message

roger_vilca

External

Since: Dec 22, 2008
Posts: 5

(Msg. 1) Posted: Mon Dec 22, 2008 1:05 pm Post subject: btree invalidation Archived from groups: comp>databases>informix (more info?)

I have the following line in the output of onstat -g mem btree inval V c000000054330028 1745338368 149991704 1704431 213054 I'm care about that because the last week the number of memory segments (onstat -g seg) has increased and onmode -F has no efect. I've noticed that "btree inval" is 1745338368 (that means aprox. 1.6 GB of virtual memory) What means "btree inval " and how can I do to release this memory ? Thanks in advance Peter >> Stay informed about: btree invalidation

david

External

Since: Dec 31, 2006
Posts: 26

(Msg. 2) Posted: Mon Dec 22, 2008 3:20 pm Post subject: Re: btree invalidation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On 22 Dec, 21:05, roger_vi....RemoveThis@yahoo.es wrote: > I have the following line in the output of onstat -g mem > > btree inval V c000000054330028 1745338368 149991704 1704431 > 213054 > > I'm care about that because the last week the number of memory > segments (onstat -g seg) has increased and onmode -F has no efect. > > I've noticed that "btree inval" is 1745338368 (that means aprox. 1.6 > GB of virtual memory) > What means "btree inval " and how can I do to release this memory ? > > Thanks in advance > > Peter Which Informix version? What does onstat -C show the btree scanners are doing? What does onstat -g stk all and onstat -g sql all show? Are online index rebuilds in progress? >> Stay informed about: btree invalidation

roger_vilca

External

Since: Dec 22, 2008
Posts: 5

(Msg. 3) Posted: Mon Dec 22, 2008 8:15 pm Post subject: Re: btree invalidation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

My version is: Informix Dynamic Server Version 7.31.FD3W1 There is no Index rebuild A typícal output of onstat -C is: Btree Cleaner Info btcleanr pool flags pools npend busypnum head tail free c000000052ab6ab8 c0000000fa7b6ec0 1 5 8 0 c0000000fa7b6ec0 c00000006583f3c8 c00000006a602fb0 nreqs dups success dfrmv unnec ditems ditlks cmprs palcs 21223 0 21484 21484 99 94234 1435733 361 0 outstanding requests address next partnum pagenum keynum sequence c0000000fa7b6ec0 c0000000fa7b6ee0 f00085 5 c0000000544d3f58 102831764 c0000000fa7b6ee0 c0000000fa7b6f00 f00085 1a c0000000544d3f98 102831764 c0000000f73ffac8 c0000000f73ffae8 1300007 1 c000000054748a70 102831767 c0000000f73ffae8 c0000000f73ffb08 1300007 2 c000000054748ab8 102831767 c0000000fb762260 c0000000fb762280 1e0000a 3bb33 c000000054755dd0 102831769 c00000006ccf3890 c00000006ccf38b0 1300006 1 c00000005bb7fdc0 102831786 c00000006ccf38b0 c00000006ccf38d0 1300006 2 c00000005bb7fe08 102831786 c00000006583f1e8 c00000006583f208 1300003 8fc91 c000000054733b98 102831788 Invalidation Requests count sequence special 28539542 102831789 28487087 >> Stay informed about: btree invalidation

roger_vilca

External

Since: Dec 22, 2008
Posts: 5

(Msg. 4) Posted: Tue Dec 23, 2008 9:04 am Post subject: Re: btree invalidation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

The CLEANERS parameter is set to 120 in the onconfig file. I believe that this is the maximum. I have a few doubts about the way how it works: When a cleaning request is invalidated ?, why ? When you indicate "All requests younger...", do you refer to cleaning requests ? Thanks for your response. best regards >> Stay informed about: btree invalidation

Gustavo Castro

External

Since: Dec 23, 2008
Posts: 1

(Msg. 5) Posted: Tue Dec 23, 2008 9:56 am Post subject: Re: btree invalidation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Btree invalidation is typical of the btree CLEANER thread which is the old technology that was replaced by the btree scanner (In 7.31.xC8 if I am not mistaken). The invalidation request is the list of all cleaning requests that have been invalidated. All requests younger than the oldest transaction open in the system need to be kept in this list. So if you have a very large logical log (enough to not to generate a long TX) and have a lot of activity and a very old open transaction this list could grown very large. Your options are to open a PMR with tech support to discard a memory leak or and/or upgrade to the latest version of 7.31 of the btree scanner. IN that sense and since the end of life of 7.31 is very close you should start testing 10.00.xC9 or newer to migrate. One of the things that you will likely want to do running the btree scanner in 10 is to DETACH all indexes in the bigger tables with more than one index as this will allow the usage of the more efficient RANGE and ALICE operational modes. regards gustavo roger_vilca DeleteThis @yahoo.es wrote: > My version is: Informix Dynamic Server Version 7.31.FD3W1 > There is no Index rebuild > > A typícal output of onstat -C is: > > Btree Cleaner Info > btcleanr pool flags pools npend busypnum > head tail free > c000000052ab6ab8 c0000000fa7b6ec0 1 5 8 0 > c0000000fa7b6ec0 c00000006583f3c8 c00000006a602fb0 > > nreqs dups success dfrmv unnec ditems ditlks cmprs > palcs > 21223 0 21484 21484 99 94234 1435733 361 0 > > outstanding requests > address next partnum pagenum keynum sequence > c0000000fa7b6ec0 c0000000fa7b6ee0 f00085 5 c0000000544d3f58 > 102831764 > c0000000fa7b6ee0 c0000000fa7b6f00 f00085 1a c0000000544d3f98 > 102831764 > c0000000f73ffac8 c0000000f73ffae8 1300007 1 c000000054748a70 > 102831767 > c0000000f73ffae8 c0000000f73ffb08 1300007 2 c000000054748ab8 > 102831767 > c0000000fb762260 c0000000fb762280 1e0000a 3bb33 c000000054755dd0 > 102831769 > c00000006ccf3890 c00000006ccf38b0 1300006 1 c00000005bb7fdc0 > 102831786 > c00000006ccf38b0 c00000006ccf38d0 1300006 2 c00000005bb7fe08 > 102831786 > c00000006583f1e8 c00000006583f208 1300003 8fc91 c000000054733b98 > 102831788 > > Invalidation Requests > count sequence special > 28539542 102831789 28487087 > > > _______________________________________________ > Informix-list mailing list > Informix-list DeleteThis @iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > >> Stay informed about: btree invalidation

Display posts from previous:

Related Topics:

Testing the 'free' versions - moving from Dev edition to I.. - Just a quick wisdom request - I have the Developer edition on a Linux box and want to replace it with Innovator-C; what's the best method to do this? Just untar the new version over the old and run 'ids_install' again, or should I remove the old Dev..

AUTO: Douglas Dailey/Lenexa/IBM is out of the office (retu.. - I am out of the office until 12/05/2011. Note: This is an automated response to your message "Informix-list Digest, Vol 302, Issue 4" sent on 12/3/2011 10:00:01. This is the only notification you will receive while this person is away.

Need help to empty data in chunk before drop it. - Hello all, I've located one bad chunk in my database. I tried to drop it, but I can't drop chunk#26 because some tables extent still in this chunk. Since, most of the data in this chunk are related to system tables, I am not sure if it is safe to unload...

ontape vs onbar - IDS 10.0FC3 on Solaris 9 I'm doing some backups to disk. An ontape backup of the 30G database with a 768k TAPEBLK takes about 25 mins, but an onbar -b -L 0 takes over twice as long. I wonder if it's that the block size being used is much smaller? ..

Restore (ontape -r) problems - Hi We have two SPARC machines running Solaris 8 & IDS 7.31.UD6. One is a Sun (test), the other a Futjitsu(live). The test box has an instance of online running, with an exact copy of the onconfig from the live box. All that has been changed is..

	Database Forums (Home) -> Informix	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum