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:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 2:06 AM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 09:22
To: [EMAIL PROTECTED]
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 of the individual to whom it is addressed and others authorized to receive
it. If you are not the intended 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, please immediately notify the sender by
phone if possible or via email message.
==============================================================================
