Hi All,
We normally do a REORG on the table and indexes when the data is
deleted from the tables.
What if we are dropping a table or any database object from a database ? Do
we need to do a REORG ?

For example, I understand that the when a table is dropped , it's
corresponding other database objects like primary keys,constraints etc are
also dropped , the catalog entries are deleted. But what happens to the
table data ? Logically , the table data should also get deleted from the
disk / memory where it is stored. In that case , I believe that REORG should
be done to defragment the memory space.

Please confirm if my understanding is right or please explain what happens
when a table or any other database object is dropped.

Thanks
Venkat

____________________________________________
Confidential: This electronic message and all contents contain information
from Syntel, Inc. which may be privileged, confidential or otherwise
protected from disclosure. The information is intended to be for the
addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited. If you
have received this electronic message in error, please notify the sender
immediately and destroy the original message and all copies.

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