DB2 V8/V9 is for Linux/Unix/Windows.
It does the same thing for REORG on all platforms.
No index specified in the command will cause the empty rows/pages to be
reclaimed and this is true for both online and offline reorg.
The data rows may not necessarily be in the same sequence as they will move
from the end of the table to reclaim the space in the front end empty rows
and pages. So it does something!
Regards, Pierre.

-----Message d'origine-----
De : MacIntyre Allison
[mailto:db2udbdba-ezmlmshield-x90585816.[Email address protected]
Envoyé : 26 octobre 2007 15:13
À : LazyDBA Discussion
Objet : TABLE REORG on Linux

Hi,

If you have a table that has no clustered index in LINUX, what happens
when you issue a REORG without specifying an index?

Allison




-----------------------------------------
This email may contain confidential and privileged material for the
sole use of the intended recipient(s). Any review, use, retention,
distribution or disclosure by others is strictly prohibited. If you
are not the intended recipient (or authorized to receive for the
recipient), please contact the sender by reply email and delete all
copies of this message. Also, email is susceptible to data
corruption, interception, tampering, unauthorized amendment and
viruses. We only send and receive emails on the basis that we are
not liable for any such corruption, interception, tampering,
amendment or viruses or any consequence thereof.


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