Table corruption

Post Reply
haamid.gazi0
Posts: 4
Joined: Wed Oct 07, 2009 6:32 am

Table corruption

Post by haamid.gazi0 »

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
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Table corruption

Post by John »

There are a few possible causes:

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.
John Turnbull
Thunderstone Software
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Table corruption

Post by mark »

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?
Post Reply