To give back all the space you would need to do a REORG.

Stefan S. wrote:

>Hello,
>a SMS Tablespace is managed by the OS. When the DB needs a page the OS
>allocates the nessesary Space for the DB.
>But, what happens when all rows of all tables (belonging the SMS-TS)
>are deleted. Deallocates the OS some Space? If Yes, at what Time?
>
>Thanks for your answers!
>
>stefan
>
>

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands