Has anyone ever seen an sms tablespace that is grown very large
(ten gigs), when in fact there is only 190 megs worth of data in it? I
have reorged the table, the indexes etc, and still the tablespace is huge,
yet there is only 190 megs worth of actual data in it. The only thing I
can do is drop the tablespace, recreate it and reload the data. Anyone
out there in db2 land have a better solution?

This is db2 7.2 fixpack 12 on windows.

Thanks

Jeremy

DB2 & UDB email list listserv db2-l LazyDBA home page