Re: Actual Used space

Wayne Kidd wrote: > > Does anyone have a query for the SMI tables or any other > tables, that will return the actual used space of a table. > I am setting up a database copy function that will copy an > entire database ( several thousand tables ) and I do not > want it to use the source system current extent sizes, I > want it to use the actual size for the target system so I > have to determine what that is. Thanks in advance. > > Wayne Try this query against sysmaster: select tabname, npused from systables, sysptnhdr where systabnames.partnum = sysptnhdr.partnum You can obviously use other critiria to narrow down the output but the important table is sysptnhdr and the npused column which is the actual number of pages currently being used by the table. -- Jacques ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * * * * Laube on Xanadu: "The movie sucked... * * but the music was awesome!!!!" * ********************************************************************