Re: Re: finding inplace alters
Andreas, you could probably rewrite it to use the sysmaster:syspaghdr table and then you may be able to release the source. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Dec 20, 2010 at 12: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 > > On 20:59, Davorin Kremenjas wrote: > > On Nov 18, 12:21 am, Fernando Nunes <domusonl...@gmail.com> wrote: > > > >> AFAIK there is no quick way to find pending inplace alters... Only a > slow > >> process. Not sure if Panther changed this... > > > > There is a good document somewhere on the IBM web and it is slow, but > > it works, returns only tables with pending IPAs. > > Since it's usually the biggest tables which end up with pending IPAs > > (there's never enough time/resources to get red of them properly) I > > was wondering if this could be further narrowed down to specific pages > > in those tables. Never got to the bottom of this though. > > > > Fernando, would you know if page flags could provide an answer? For > > example, sysmaster:syspaghdr.pg_flags. > > > > Thanks > > > > Davorin > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >