Table corruption

haamid.gazi0 · Post by **haamid.gazi0** » Thu Aug 30, 2012 5:17 pm

Hi John,

we have recently seen errors related to the table corruption in permission tables. The issue got fixed by running kdbfchk. Our users want to know the cause of corruption and how can it be avoided. Can you please help us on that?

Regards
Haamid

Post by **mark** » Thu Aug 30, 2012 5:52 pm

That's really hard to say with no info. The main class of things that cause corruption is texis being forcefully stopped while writing to the table. It can be forcefully stopped by an admin hard killing the process, sudden power-offs, or a bug in the software causing an ABEND while writing which is highly unlikely.

Has anyone been killing texis related processes?
Has the server been shutdown or rebooted without ensuring that texis was not running?
Are there any ABENDs logged?