Specifying the force keyed access path (FRCACCPTH) parameter

 

The FRCACCPTH parameter controls whether access path changes are forced to auxiliary storage along with the associated records in a database file.

FRCACCPTH (*YES) forces access path changes to auxiliary storage whenever the access path is changed. This reduces the chance that the access path needs rebuilding if the system fails.

 

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.

 

Parent topic:

Specifying database file and member attributes

 

Related concepts

Recovering and restoring your database