I thought (without looking at any doc) that it will first default to a clustered index, then the primary key, then the first unique index that was built. I could be totally wrong though. I'm doing the lazy thing and not researching it - but it sounds good. lol
Douglas Kostelnik
Senior Database Administrator/Architect
-----Original Message-----
From: Pierre Saint-Jacques [mailto:db2udbdba-ezmlmshield-x17185396.[Email address protected]
Sent: Saturday, October 27, 2007 12:31 PM
To: LazyDBA Discussion
Subject: RE: TABLE REORG on Linux
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
---------------------------------------------------------------------
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
------------------------------------------------------------------------
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.
========================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page