Hello togehter,

we´ve got another problem, that while trying to access a table, which seems like no one is using it at the time, we get the ISAM error 113 the file is locked. This happens since we installed Informix 9.4, the error didn´t show up on out last Informix version. Does anybody have the same or similar problem and ist able to help us ? Thanks in advance.

koeningskind

Hi,
Please test level lock for table (page or row).
Run select hex(partnum) rom systables where tabname = 'tabname', next search this output in onstat -k.
If the table mode lock is page, then change it to row.

Gustavo.

Hi Gustavo,

I should have metioned it, but the table is set on lock mode row, thats why it is kinda hard for us to find the problem, we thought that maybe it is an Informix 9.4 bug ?

Thanks

koeningskind