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?
I see in your other message you removed locks and semaphores, which may cause two processes to write to the table at the same time, causing corruption.
Accessing the same table files from multiple servers will cause problems.
A hard kill of a process while it is writing, or unexpected shutdown could cause this, as could rarely either a hardware fault, or network issue if using network storage.
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?
