Unable to use locking w/ SE-7.10 on HPUX 9.05... why???
Posted in 1997
I have been trying to use table locking with informix-SE 7.10 on an HPUX
9.0.5 machine, but it just doesn't work.
Given this query:
---
set lock mode to wait;lock table table1 in exclusive mode;
---
I then open two windows into dbaccess. Issuing that query in the first
window works just fine, and it locks the table. However, when I issue it in
the second window, I get a -242 error, with a -113 ISAM code.
---
-242 Could not open database table table-name.
The database server is unable to begin reading a table.
Check the accompanying ISAM error code for more
information. There may be a problem with file permissions,
or a hardware error, or the system catalog may have been
corrupted. Unless the ISAM error code or an operating
system message points to another cause, run the bcheck or
secheck utility to verify file integrity.
---
-113 ISAM error: the file is locked.
The file (table) that was requested has been opened in
exclusive mode by another user request. In systems that use
files for locking, a tablename.lok file exists. Possibly such a
file is residual, left behind when another program
terminated abnormally. If you can be sure that is the case,
you can release the lock by emptying that file. Lock files are
not used in many systems, and are never used with the
INFORMIX-OnLine Dynamic Server.
C-ISAM programs: Rerun the program after the file has been
unlocked. SQL products: Tables are locked explicitly using
the LOCK TABLE statement, and implicitly during the
execution of the CREATE INDEX and ALTER TABLE
commands. Rerun the program or query when the table has
been unlocked.
---
It appears as if the lock mode is being ignored.
Anyone have any suggestions?
-- Nathan
------------------------------------------------------------
Nathan Neulinger Univ. of Missouri - Rolla
EMail: nneul@umr.edu Computing Services
WWW: http://www.umr.edu/~nneul SysAdmin: rollanet.org