You can control when database changes are written to auxiliary storage using the force write ratio (FRCRATIO) parameter on either the create, change, or override database file commands. 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.
Using the FRCRATIO parameter has performance and recovery considerations for your system. To understand these considerations, see Recovering and restoring your database.