HP3000-L Archives

September 2001, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jerry Fochtman <[log in to unmask]>
Reply To:
Jerry Fochtman <[log in to unmask]>
Date:
Tue, 25 Sep 2001 09:27:01 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (31 lines)
At 01:59 PM 9/25/01 +0100, Andrew Russel wrote:
>I have a large database (>150 datasets), and need to
>reduce the capacities of certain datasets via DBGENRL.
>
>Some of these datasets are details, and will need
>repacking as I am reducing below their current HWM.
>
>I am also reducing the capacities on some Automatic
>Masters.
>
>My question is...
>
>Should I reduce the capacities on the Auto Masters
>first, or repack the details first? Or does it not
>make any difference?


As a general rule, the short answer is to change the master
set capacities first before repacking any details.  This is
because in repacking details it is likely that the entries
will be move to other locations in the set, making it
necessary to also update the master chain pointers.  If there
is less empty space in a master set, the detail reorg process
will have less empty space to read through when updating
master chain pointers.  This makes even more sense if the
master set in question points to several details that will
be repacked.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2