Specifying the frequency of writing the access path (FRCACCPTH) parameter when creating database files

The force access path (FRCACCPTH) parameter controls when an access path is written to auxiliary storage. FRCACCPTH(*YES) forces the access path to auxiliary storage whenever the access path is changed. This reduces the chance that the access path will need to be rebuilt should the system fail.

FRCACCPTH Parameter Tips

Specifying FRCACCPTH(*YES) can degrade performance when changes occur to the access path. An alternative to forcing the access path is journaling the access path. For more information about forcing access paths and journaling access paths, see Recovering and restoring your database.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]