On Thu, 14 Jul 2011 00:56:40 -0000, "Tim Wilson"
<timwilsonaus@...>
wrote:

> Hi
>
> We are currently having an issue with a client database that keeps both
> losing data and getting black entries on certain tables.
>
> We have an Options table which stores all of the system wide settings for
> our application. For this client their options table is being cleared and
> all settings are being lost. We also have a Members table which stores

all

> of the user information that is getting black users added to it.
>
> Using Gfix, we have run a validate on the database which didn't show any
> errors. We then tried a Mend followed by a Backup and Restore to see if
> this would prevent the issue. However only 10mins after performing these
> steps the options table was blank again.
>
> Any suggestions as to what may be the cause would be greatly appreciated.

It might be a 'stupid' suggestion, but are you 100% sure that the data has
actually been comitted (fully committed, not commit retaining)?
Disappearing data is usually a good indication of not commtting.

BTW: What do you mean with 'black entries'?

Mark