Write data and access paths to auxiliary storage

Normally, DB2 Universal Databaseā„¢ for iSeriesā„¢ determines when to write changed data 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.

Related concepts
Recover and restore your database