Re: Sizing Parameters

Posted in 1998

Art S. Kagel — Tue, 12 May 1998 15:15:37 -0400 — source: Informix-list mailing list archive (1991-1998)

Herb Blacker wrote: > > I'm going to be relocating a version 5.10 database to version 7.23. > I'm going to be detaching the indexes, and fragmenting my large tables. > Is there a utility (besides tbcheck -pT) which will get me the size > in pages of my table's data versus the size in pages of the > table's index(es) without locking the table? Not for 5.xx, for 7.2x+ you can get my submission to the IIUG Software Repository, utils2_ak, which contains printfree.ec which does just that, also the program myschema.ec produces the same information with less detail. Art S. Kagel