On Wed, 28 Apr 1999 13:49:47 -0700, "Eben Yong" <[log in to unmask]> wrote: >I have a KSAM file that has hit the FLIMIT. I want to expand the number of >records the file holds. Is it as simple as using MPEX's ALTFILE command to >increase the FLIMIT? > >FYI, the KSAM file is the old-style that is actually two MPE files, as >opposed to the new style where the data and index are incorporated into the >same file. > >Thank you! > >Eben Yong >Health Plan of San Mateo >[log in to unmask] > > > Yes, MPEX's ALTFILE command can be used with CM KSAM files. Also, in RE to Leonard's reply: CM KSAM has an undocumented, unsupported ";REUSE" parameter you can use on the BUILD command in KSAMUTIL. I figured REUSE was fairly safe to use since HPToolSet built some of its KSAM work files with it. Caveat emptor, however, but I used it successfully for years at a prior site until converting the files to NM KSAM. REUSE allows KSAM to reuse deleted records. This can reduce the frequency of "file reorgs" to increase the FLIMIT or remove deleted records. Note: REUSE is documented/supported with NM KSAM files, but ;REUSE files are built with an EOF at 115% of your DISC=# specification.