> Yes, I commit the inserts regularly.
> How can I set "forced writes = ON" on database level ?

Use gfix in combination with the -w switch, whereas

sync = FORCED WRITES ON
async = FORCED WRITES OFF

For example:

gfix –w sync –user SYSDBA –password masterkey <your_database_path>


To check whether forced writes is on or off, check the database
header page by using gstat -h.

For example:

gstat –h –user SYSDBA –password masterkey <your_database_path>


If there is a line

Attributes force write


in the output stream, then forced writes is ON, otherwise it's OFF.



HTH,
Thomas