Re: finding inplace alters

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

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 >