If you drop a table, you could not issue the reorg command against it as the
object does not exist anymore.
The space is marked as freed or rather non existent. If in SMS the file is
erased. If in DMS the extents are erased and and freed.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Venkatakrishnan Venkataraghavan"
<db2udbdba-ezmlmshield-x11982338.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, October 30, 2006 6:48 AM
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
>



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