Previous Topic: DBKYWORK FileNext Topic: SORT File


INDXEXTR and INDXWORK Files

Space for the INDXEXTR and INDXWORK files is primarily used for integrated index orphan records and, secondarily, for integrated index errors.

If your database contains a small number of member records in integrated index sets, then you can estimate the total blocks using this formula:

Total Number of Blocks=((total # integrated index member records)*record size)*0.5
                                                      block size

 Record Size = 76 + length of member symbolic key +
               length of owner symbolic key +
               4 bytes for the record descriptor word (RDW)

If your database contains a large number of member records in integrated index sets, multiply the result by 3. In a typical situation, a DASD cylinder allocation of 20,4 should be adequate.

Both INDXEXTR and INDXWORK should use the same space allocation.