>> My client, who is using this 2.3 GB database suddenly had a problem where two of the
>> master entries (product master) went missing, leaving orphan transactions.
>>
>> The records were pertaining to some high volume products such as syringe and distilled
>> water.
>>
>> Any suggestions would be much appreciated.
>>
>> Db stats as follows
>>
>> Thanks in advance
>> Duleep
>>
>> Database name /boma/linhis.gdb
>> Creation date 26-12-2007 23:23
>> Statistics date 16-04-2008 18:34
>> Page size 8192
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>> Forced Write OFF
>
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> Switch it ON!!!!!

I guess this wouldn't make any difference, as the database path above
implies, that he is using Linux where forced writes is "useless" due to
an old bug in the linux kernel.

According to the Firebird 2.1 release notes, it has been fixed in 2.1.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com