Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    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 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

  2. #2
    Join Date
    May 2004
    Location
    Barcelona, Spain
    Posts
    54
    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

  3. #3
    Join Date
    Jun 2004
    Posts
    2
    Thank you very much for the data, I´m not an Informix DBA, and I have to confirm the suspects on this error.

    regards.

  4. #4
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    Oncheck verify index and data pages of table use share lock mode,but fix the bad index and data pages use exclusive lock mode.
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •