Re: Locking problem

Willem Roos wrote: > > Hi all, > When trying to rename a column in a table (and other table > changes too) i get a locking error (Error 242, ISAM 106). Error -106 is non-exclusive access trying to drop an index. The column you are trying to rename has one or more indexes containing it. These have to be dropped and recreated, that is the access that is being conflicted with. Try: SET LOCK MODE TO WAIT;LOCK TABLE <mytable> IN EXCLUSIVE MODE; RENAME COLUMN ...... > Onstat -k shows that the table is not locked. Is there a > way of finding out who locks the table? Querying the > system catalogs doesn't help either. The onstat -k should show a table level Intent shared lock or Index lock on the table's partnum or a detached index's partnum. Art S. Kagel PS- Please do not post HTML. Adjust your mailer to post plain text.