database/dbspace filling ?
Posted in 1994
Robert Bos — — source: Informix-list mailing list archive (1991-1998)
Hi, We are using Informix-Online 5.02 on Sun Solaris 2.3, and want to know how much space is still available in our database (actually the database space/raw device filling). Using tbcheck -pT (or -pt) we can see how many pages are used, but this is not an accurate representation, because deleting rows does not mean actually freeing the pages, in such a way that tbcheck can recognize them as free (i.e. the 'pages used' count will not decrease if you delete rows...). Does anybody know an (Informix) tool to get the correct percentage of database filling ? Thanks for any help Robert Bos (rbos@hacktic.nl or rbo@dasc.nl) P.S.: please reply via e-mail, as I don't have easy access to this news-group!