The space will not be recovered until you do a reorg - no difference
between SMS & DMS. JDPope

-----Original Message-----
From: Ivan Gonzalez
[mailto:db2udbdba-ezmlmshield-x12508224.[Email address protected]
Sent: Wednesday, February 28, 2007 9:59 AM
To: LazyDBA Discussion
Subject: Row Deletion...

When a row gets deleted when is the space recaptured? Is there a
difference between how SMS and DMS handle it?



Appreciate your feedback.



Ivan







******************NOTICE*******************
This e-mail, including any attachments, is intended for the receipt and
use by the intended addressee(s) only and may contain privileged,
confidential, work-product and/or trade secret information of a
proprietary nature. If you are not an intended recipient of this
e-mail, you are hereby notified that any unauthorized use, distribution
or re-transmission of this e-mail or any attachment(s) is strictly
prohibited and that all rights of the sender and/or intended recipients
are hereby reserved without prejudice thereto.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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