need dbspace/table report

Hi all.. I need to report on how much each table in a dbspace is using as a percentage of the total dbspace space. I have searched all of the usual spots and if there is such a thing, then the description is buried. Has anyone done such a thing or can point me to where I would find it? I do not care if the table is fragmented since I am interested in dpspace info, and I do not have 4gl so I would need either scripts or C. tnx....... Doug

In article <3A59EF26.96436F00@nospam.fmr.com>, Doug McAllister <doug.mcallister@nospam.fmr.com> wrote: > Hi all.. > > I need to report on how much each table in a dbspace is using as a > percentage of the total dbspace space. > I have searched all of the usual spots and if there is such a thing, > then the description is buried. > > Has anyone done such a thing or can point me to where I would find it? > I do not care if the table is fragmented since I am interested in > dpspace info, and I do not have 4gl so I would need either scripts or C. > > tnx....... > > Doug > I figure you join systabnames, sysptnext, syschunks and sysdbstab and you will get the results you want. You use partnum to join systables and sysptnext, the rest aren't to bad to guess. Hope this helps, Will Will Sent via Deja.com http://www.deja.com/