Specifying the force write ratio (FRCRATIO) parameter

The FRCRATIO parameter on the create, change, or override database file command controls when database file changes are written to auxiliary storage.

Normally, the system determines when to write changed data from main storage to auxiliary storage. Closing the file (except for a shared close) and the force-end-of-data operation forces remaining updates, deletions, and additions to auxiliary storage. If you are journaling the file, the FRCRATIO parameter should normally be *NONE.

FRCRATIO parameter tip

Using the FRCRATIO parameter has performance and recovery considerations for your system.