Obtain number of Index/Data pages for a table on sysmaster
Hi,
Where can I find this Data on SMI or sysmaster.
Thanks for your help.
Glenn Cummings
Saint-Gobain Glass Deutschland
( oncheck -pT <DB>:<Table> )
.
.
.
Type Pages Empty Semi-Full Full Very-Full
---------------- ---------- ---------- ---------- ---------- ----------
Free 150
Bit-Map 2
Index 503
Data (Home) 6733
----------
Total Pages 7388
.
.
.
.
.
You can find it in sysptnbit, try this SQL:
select txt,count(pb_bitmap)
from sysptnbit a,
flags_text b,
your_database:systables c
where a.pb_bitmap = b.flags and
b.tabname = 'sysptnbit'
and a.pb_partnum=c.partnum and
c.tabname = 'your_table_here'
group by 1;
Erickson
In article <960boh$ef8$1@swifty.westend.com>,
"Glenn Cummings" <GCummings@Vegla.de> wrote:
> Hi,
>
> Where can I find this Data on SMI or sysmaster.
>
> Thanks for your help.
>
> Glenn Cummings
> Saint-Gobain Glass Deutschland
>
> ( oncheck -pT <DB>:<Table> )
> .
> .
> .
> Type Pages Empty Semi-Full Full
Very-Full
> ---------------- ---------- ---------- ---------- ---------- -----
-----
> Free 150
> Bit-Map 2
> Index 503
> Data (Home) 6733
> ----------
> Total Pages 7388
> .
> .
> .
> .
> .
>
>
Sent via Deja.com
http://www.deja.com/
Look at my printfreeB.ec utility in the package utils2_ak in the IIUG
Softwware Repository. It generates a report VERY similar to oncheck -pT,
the query and details are in there.
Art S. Kagel
Glenn Cummings wrote:
>
> Hi,
>
> Where can I find this Data on SMI or sysmaster.
>
> Thanks for your help.
>
> Glenn Cummings
> Saint-Gobain Glass Deutschland
>
> ( oncheck -pT <DB>:<Table> )
> .
> .
> .
> Type Pages Empty Semi-Full Full Very-Full
> ---------------- ---------- ---------- ---------- ---------- ----------
> Free 150
> Bit-Map 2
> Index 503
> Data (Home) 6733
> ----------
> Total Pages 7388
> .
> .
> .
> .
> .
For 7.3 in Chapter 34 of the Administrator's Guide for Informix Dynamic
Server which is in Answers Online.
http://www.informix.com/answers/english/pids73.htm
Yours
--
Earle A Long (Senior DBA)
SinglePoint Limited
"Glenn Cummings" <GCummings@Vegla.de> wrote in message
news:960boh$ef8$1@swifty.westend.com...
> Hi,
>
> Where can I find this Data on SMI or sysmaster.
>
> Thanks for your help.
>
> Glenn Cummings
> Saint-Gobain Glass Deutschland
>
> ( oncheck -pT <DB>:<Table> )
> .
> .
> .
> Type Pages Empty Semi-Full Full
Very-Full
> ---------------- ---------- ---------- ---------- ---------- ---------
-
> Free 150
> Bit-Map 2
> Index 503
> Data (Home) 6733
> ----------
> Total Pages 7388
> .
> .
> .
> .
> .
>
>
>