Writing data and access paths to auxiliary storage

Normally, Db2® for i 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.