From: dspencer@chsra2.chsra.wisc.edu
Subject: $convert doesn't pack this file
Reply-To: spencer@macc.wisc.edu
Organization: CHSRA/UW-MADISON, MADISON, WI
Date: Thu, 17 Dec 92 17:34:04 GMT

I have been trying to reduce the size of a large indexed file (FDL included below).  I run $anal/rms/fdl, and generate the listing on the left side of the post, with a DATA_FILL factor of 57% in the anal_of_key 0 section.  I then run
$edit/fdl/anal= /script=opt  
on the *.fdl file, and it generates the three new allocations I have inserted
on the right.  Then I run $convert..., but the file that is generated using 
the new .fdl file is the same size as the old one.  I thought $convert was 
supposed to tune and reduce files in this situation.  Am I wrong?  Any
suggestions for improving the DATA_FILL I get out of this situation?

SYSTEM
        SOURCE                  VAX/VMS

FILE
        ALLOCATION              864168
        BEST_TRY_CONTIGUOUS     yes
        BUCKET_SIZE             8
        CLUSTER_SIZE            8
        CONTIGUOUS              no
        EXTENSION               65535
        FILE_MONITORING         no
        GLOBAL_BUFFER_COUNT     0
        NAME
        ORGANIZATION            indexed
        OWNER
        PROTECTION

RECORD
        BLOCK_SPAN              yes
        CARRIAGE_CONTROL        carriage_return
        FORMAT                  fixed
        SIZE                    37
                                                   ****edit/fdl/optimized
AREA 0                                              changes this to
        ALLOCATION              862488                  475392
        BEST_TRY_CONTIGUOUS     yes
        BUCKET_SIZE             8
        EXTENSION               65535

AREA 1
        ALLOCATION              1680                     1568
        BEST_TRY_CONTIGUOUS     yes
        BUCKET_SIZE             8
        EXTENSION               424                       392

KEY 0
        CHANGES                 no
        DATA_KEY_COMPRESSION    yes
        DATA_RECORD_COMPRESSION no
        DATA_AREA               0
        DATA_FILL               100
        DUPLICATES              yes
        INDEX_AREA              1
        INDEX_COMPRESSION       yes
        INDEX_FILL              100
        LEVEL1_INDEX_AREA       1
        NAME                    "RID"
        NULL_KEY                no
        PROLOG                  3
              SEG0_LENGTH             10
        SEG0_POSITION           0
        TYPE                    string

ANALYSIS_OF_AREA 0
        RECLAIMED_SPACE         0

ANALYSIS_OF_AREA 1
        RECLAIMED_SPACE         0

ANALYSIS_OF_KEY 0
        DATA_FILL               57
        DATA_KEY_COMPRESSION    73
        DATA_RECORD_COMPRESSION 0
        DATA_RECORD_COUNT       5882786
        DATA_SPACE_OCCUPIED     820736
        DEPTH                   2
        INDEX_COMPRESSION       28
        INDEX_FILL              98
        INDEX_SPACE_OCCUPIED    1040
        LEVEL1_RECORD_COUNT     56737
        MEAN_DATA_LENGTH        37
        MEAN_INDEX_LENGTH       13


Please use the address below if you email, the address in the header will
not be correct until early next year.
-----------------------------------------------
Dan Spencer         spencer@vms.macc.wisc.edu
Center for Health Systems Research and Analysis
UW-Madison