var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oncheck lock error message
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 p02 02adm.tst03
ERROR: Could not obtain lock for p02 02adm.tst03.
I think that it was because someone tries to access the table at the same time.
could anyone confirm that.
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.
Thank you very much for the data, I´m not an Informix DBA, and I have to confirm the suspects on this error.
Oncheck verify index and data pages of table use share lock mode,but fix the bad index and data pages use exclusive lock mode.