Re: Re: finding inplace alters

Morning Fernando, I'd assume so (will check once I find time). The counters should be updated for every single row/page being lifted to the latest version. If you're taking the counters from the (secondary) partition pages, you'd probably need to checkpoint first to get the in-memory partition informations flushed to partition pages (and to disk, though this part probably isn't what you need). HTH, Andreas From: Fernando Nunes <domusonline@gmail.com> To: Andreas Legner/Germany/IBM@IBMDE Cc: informix-list@iiug.org Date: 11.01.2011 01:55 Subject: Re: Re: finding inplace alters On Mon, Dec 20, 2010 at 5:41 PM, Andreas Legner <andreas.legner@de.ibm.com > wrote: I could offer a tool called 'onion' that, among other things, can provide the desired informations directly from versions' page counters on (secondary) partition pages, so no data and other pages need to be scanned and you can get what you want in a second or two. The engine will not sense a bit since the tool is reading directly from disks. Nothing official, designed for support purposes, but usually serving its purpose... Let me know if you need it (platform required since it is a binary). Andreas Hello Andreas... Are you sure the counters are updated after a dummy update? I get to the point where I get that info from SQL, but unless I'm doing something completely wrong, the counters did not change..... Regards -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...