>Sometimes, I have an INSERT INTO which generates "file is in used by another user" which result in a fail.
>
>I have SET REPROCESS TO 2 SECONDS.
>
>Does this mean that during that 2 seconds, the INSERT INTO was unable to lock the header?
>
>Should I be better to move this to SET REPROCESS TO 5 SECONDS?

To handle such situation I have the routine in my error handler which sets a 10-attempt loop with RETRY, and asks what to do after this (if it is still not locked).