Re: Locking

In article <43ujg0$7uf$1@mhafn.production.compuserve.com> 75442.2115@CompuServe.COM "Stanley Katzenstein" writes: > I am working in Informix V4 SE. The error occurs within a > PowerBuilder application. My problem is that I can't delete a row > from a table. The error I get is -263 with ISAM -107. Could not > lock row for UPDATE. I am not sure how to resolve this problem. > > When in ISQL on UNIX I get a message that the row is currently in > use by another user. Another possability is that UNIX is out of locks. 'sar -v' normally produces the required info. I can't be specific without a lot more information. You can also use 'fuser' to find out what processes are accessing the UNIX files for the table, and the final suggestion is that a process has died without removing the lock from the UNIX lock table, in which case you will have to reboot unless this is a shared memory version of Informix. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================