oncheck -pT output from sysmaster?
Is it possible to obtain the page version information that oncheck -pT reports in the "Home Data Page Version Summary" section from the sysmaster database instead? I'm using IDS 11.50.
Put an alternate way, how can I easily report on tables with outstanding in-place alters without having to trawl through the oncheck -pT output for each table?
Thanks in advance.
Outstanding in-place alters:
SELECT dbsname, trim(owner)||"."|| tabname AS fullname
FROM sysmaster:sysactptnhdr h,
sysmaster:systabnames t
WHERE h.partnum = t.partnum
AND dbsname != 'sysmaster'
AND pta_totpgs != 0;
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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 Sun, Aug 26, 2012 at 11:08 PM, Desmodromic <davies_ms@yahoo.com.au>wrote:
> Is it possible to obtain the page version information that oncheck -pT
> reports in the "Home Data Page Version Summary" section from the sysmaster
> database instead? I'm using IDS 11.50.
>
> Put an alternate way, how can I easily report on tables with outstanding
> in-place alters without having to trawl through the oncheck -pT output for
> each table?
>
> Thanks in advance.
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
On Monday, August 27, 2012 1:08:16 PM UTC+10, Desmodromic wrote:
> Is it possible to obtain the page version information that oncheck -pT reports in the "Home Data Page Version Summary" section from the sysmaster database instead? I'm using IDS 11.50.
>
>
>
> Put an alternate way, how can I easily report on tables with outstanding in-place alters without having to trawl through the oncheck -pT output for each table?
>
>
>
> Thanks in advance.
Art,
Thanks for your quick response.
One thing is confusing me, however. when I run your SQL as it is I get zero rows returned. If I replace the "AND dbsname != 'sysmaster'" clause with a specific database as in "AND dbsname = 'mydb'" then I get the results I am after.
Can you shed any light on this?
Thanks.
Honestly, that a poser since != 'sysmaster' should match 'mydb' and every
other database except 'sysmaster'. On the plus side, you have found a
work-around. If you want to , open a support case with IBM so they can fix
this for everyone else.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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, Aug 27, 2012 at 10:15 PM, Desmodromic <davies_ms@yahoo.com.au>wrote:
> On Monday, August 27, 2012 1:08:16 PM UTC+10, Desmodromic wrote:
> > Is it possible to obtain the page version information that oncheck -pT
> reports in the "Home Data Page Version Summary" section from the sysmaster
> database instead? I'm using IDS 11.50.
> >
> >
> >
> > Put an alternate way, how can I easily report on tables with outstanding
> in-place alters without having to trawl through the oncheck -pT output for
> each table?
> >
> >
> >
> > Thanks in advance.
>
> Art,
>
> Thanks for your quick response.
>
> One thing is confusing me, however. when I run your SQL as it is I get
> zero rows returned. If I replace the "AND dbsname != 'sysmaster'" clause
> with a specific database as in "AND dbsname = 'mydb'" then I get the
> results I am after.
>
> Can you shed any light on this?
>
> Thanks.
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>