Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Unanswered: the file is locked

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

  3. #3
    Join Date
    Mar 2005
    Posts
    4
    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

Posting Permissions

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