Writing data and access paths to auxiliary storage

 

Normally, DB2 Universal Database™ for iSeries™ determines when to write changed data and access paths from main storage to auxiliary storage. However, you can control when database changes are written to auxiliary storage.

If you want to control when changed data are written from main storage to auxiliary storage, you can use the force write ratio (FRCRATIO) parameter on the create, change, or override database file commands, and the force access path (FRCACCPTH) parameter on the create and change database file commands. Using the FRCRATIO and FRCACCPTH parameters have performance and recovery considerations for your system.

 

Parent topic:

Data recovery and integrity

 

Related concepts

Recovering and restoring your database