Hi, we are running an oncheck -cD on oour Informix 7.31 after a critical crash and we couild see the following error in the oncheck log.

TBLspace data check for p0202adm.tst03
ERROR: Could not obtain lock for p0202adm.tst03.

I think that it was because someone tries to access the table at the same time.

could anyone confirm that.

Thank you

Hi!

This message is caused by a lock being held for that table. You should be able to locate this lock by means of "onstat -k" or a query on syslocks (and syssessions) and identify the user session that is holding it.

Cheers

Iñaki

Thank you very much for the data, I´m not an Informix DBA, and I have to confirm the suspects on this error.

regards.

Oncheck verify index and data pages of table use share lock mode,but fix the bad index and data pages use exclusive lock mode.