Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    2

    Unanswered: 107: record is locked problem

    Hi,
    We r running a Standard engine with 4gl dev. environment. One of our programs stops working whenever it tries to update a record. It can update other records, but some records are locked and it returns ISAM 107.

    I tried getting all the users out (around 8 users) and logged in as informix, but still can't update certian records. I can't seem to unlock them at all.

    Can anyone help me?

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    After you kill session Informix isn't unlock immedietly because it's rollback previous action you have to wait until that session is disapear from "onstat -g ses"

  3. #3
    Join Date
    May 2002
    Posts
    2
    This would be true if I was running Online engine. But this happens to be the standard engine, and onstat utility is not available. What I do for a temp fix is to run a bcheck -s on the affected table files.

Posting Permissions

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