The question is "what is a reorg?"

I would think moving the db to a new volume would just move the db
blocks - not changing their contents.  It would collapse the unused
db blocks, but I think this would be different result than a
unload/load, which would recreate all db objects.

Kind of like the difference between moving a logical volume to a
different disk and defraging a filesystem.  On a move logical volume
the physical partitions are moved, but their contents are left alone.
 To defrag the filesystem requires tinkering with the contents of the
physical partition.

Just a guess  . . . .

Rick

On 17 Sep 2001, at 9:42, Alex Paschal wrote:

> I just had a thought.  If you defined new dbvols and deleted the previous
> dbvols, that would move the db data over to the new volume.  Could that
> possibly defrag the db at the same time?  I would expect so because the
> manual says you can cancel the delete dbvol process, but some of the data
> may have moved.  It makes sense to me that this implies it moves db objects,
> not just vast tracts of raw dbspace.  Any thoughts?
>
> (Andy? Are you out there? Any chance on developer feedback on this one?)
>
> Alex
>
> -----Original Message-----
> From: Loon, E.J. van - SPLXM [mailto:Eric-van.Loon AT KLM DOT COM]
> Sent: Monday, September 17, 2001 2:06 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Defrag Database
>
>
> Hi Maurice!
> An online defrag utility is on all our wish lists for some time!
> The only way to defrag your database is a offline dump and reload... Note
> that this is quite a lengthy process!
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines
>
>
> -----Original Message-----
> From: Maurice van 't Loo [mailto:maurice AT COMPARE.MYWEB DOT NL]
> Sent: Monday, September 17, 2001 09:22
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Defrag Database
>
>
> Hi,
>
> *** ---> Q DB F=D
>
> Available Space (MB): 3.320
> Assigned Capacity (MB): 3.320
> Maximum Extension (MB): 0
> Maximum Reduction (MB): 20
> Pct Util: 43,2
> Max. Pct Util: 52,0
> Physical Volumes: 13
>
> Because the database is around 50% utililized, i want to reduce the
> database, the by the spacetrigger made volumes can be deleted.
>
> Is there a way to "defrag" the database?
>
> Tia,
>    Maurice
>
>
> **********************************************************************
> This e-mail and any attachment may contain confidential and privileged
> material intended for the addressee only. If you are not the addressee, you
> are notified that no part of the e-mail or any attachment may be disclosed,
> copied or distributed, and that any other action related to this e-mail or
> attachment is strictly prohibited, and may be unlawful. If you have received
> this e-mail by error, please notify the sender immediately by return e-mail,
> and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its
> subsidiaries and/or its employees shall not be liable for the incorrect or
> incomplete transmission of this e-mail or any attachments, nor responsible
> for any delay in receipt.
> **********************************************************************
>
> "WorldSecure <Freightliner.com>" made the following
>  annotations on 09/17/01 09:29:03
> ------------------------------------------------------------------------------
>
> [INFO] -- Content Manager:
> The information contained in this communication is confidential and intended 
> solely for the use o
f the individual to whom it is addressed and others authorized to receive it.  
If you are not the i
ntended recipient, any disclosure, copying, distribution or taking of any 
action in reliance on the
 contents of this information is prohibited. If you have received this 
communication in error, plea
se immediately notify the sender by phone if possible or via email message.
>
> ==============================================================================
>