HP3000-L Archives

November 2003, 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:
Stan Sieler <[log in to unmask]>
Reply To:
Stan Sieler <[log in to unmask]>
Date:
Tue, 25 Nov 2003 10:16:50 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (25 lines)
Re:
> I normally do an mpex altfile to increase the flimit of a ksam file when the
...
> I started thinking that there must be a better way of removing deleted

As mentioned earlier, when you create a KSAM file you get to decide
whether or not the space used by deleted records should be reused (the default
is to not reuse the space (NOREUSE)).  Thus, enabling the option (by specifying
REUSE at BUILD time) would answer your question.

However, as pointed out by Tracy, you will probably want to reorganize
your KSAM file from time to time.  If it has a single key, Tracy's suggestion
puts the file back into key order.  BTW, if it has more than one key, there's
no simple method of putting it into an "optimum" order ... partially because
no tool could guess the optimimum order, since it depends upon your access
patterns ... so you might as well put it into key 1 order.


> Would renaming the file twice, the 2nd time to its original name, do it?

Renaming a file has no affect on its limit.

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

ATOM RSS1 RSS2