Obtain number of Index/Data pages for a table on sysmaster

Posted in 2001

Summary

Glenn Cummings asked where to find, in sysmaster, the index and data page counts shown by oncheck -pT. Norman Erickson Lugtu supplied a query on sysptnbit joined with flags_text and systables. Art Kagel pointed to his printfreeB.ec utility in utils2_ak at the IIUG repository, and Earle Long pointed to the 7.3 Administrator's Guide chapter 34.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Glenn Cummings — Fri, 9 Feb 2001 10:01:56 +0100 — source: Informix-list mailing list archive (1991-1998)

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 . . . . .

↪ replying to Glenn Cummings

Norman Erickson Lugtu — Fri, 09 Feb 2001 16:36:31 GMT — source: Informix-list mailing list archive (1991-1998)

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/

↪ replying to Glenn Cummings

Art S. Kagel — Mon, 12 Feb 2001 18:07:42 -0500 — source: Informix-list mailing list archive (1991-1998)

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 > . > . > . > . > .

↪ replying to Glenn Cummings

Earle A Long — Tue, 13 Feb 2001 11:38:21 -0000 — source: Informix-list mailing list archive (1991-1998)

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 > . > . > . > . > . > > >