Re: Calculate BLOB pages

Proflow Acc (proflow@hclind.hclc-ggn.hcla.com) wrote: : Hi , : Please share your knowledge and enrich us. : We intend to do the following. We need to calculate the blob pages : used by the byte fields of different tables stored at different : blob spaces. If we use length(field), that gives the bytes used : by the field. How do we get the information of how many blob pages : it is occupying. We can not simple devide the bytes occupied by the : size of the blob page to know the no of blob pages as the blob page : may contain some other information for storage purposes. : Does any one know how to get the no of blob pages used by some way. : Thanx in anticipation. : proflow developement Team You can use tbcheck/oncheck -pB database:table. This gives you information about no blob pages and % used. You can also find useful information in tbcheck/oncheck -pp database:table rowid output - it reports adresses of used blob pages for given rowid. I hope this helps. Mirek -- ================================= Miroslav Lorenc Database Administrator Software Applications and Systems e-mail: Miroslav.Lorenc@sasprg.cz 108 28 Prague 10 Tel: +42 2 705134 Czech Republic Fax: +42 2 705128