RE: REORG - Need advise

No. There is actually nothing to reorg as the table and indexes are gone
(i.e. there is no tablespace level reorg). The space is automatically
freed up.

Douglas Kostelnik
Senior Database Administrator/Architect
[Email address protected]
AAA Auto Club South
(813)-289-1342

-----Original Message-----
From: Venkatakrishnan Venkataraghavan
[mailto:db2udbdba-ezmlmshield-x11982338.[Email address protected]
Sent: Monday, October 30, 2006 6:49 AM
To: LazyDBA Discussion
Subject: REORG - Need advise

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.

---------------------------------------------------------------------
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

<html>
 <align=justify> 
_____________________________________________________________ 
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
</html>

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