Can't Remove Update Lock
Posted in 1996
Hello, We are in the process of designing/implementing a concurrent multiuser databse system using Informix. I have gone through the Informix manuals but it seems that it is not possible to allow one user to remove an update lock set on row by another user. The first would lose her/his work, i.e. his/her transaction should be rolled back either right away or as she/he attempts to continue her/his work. This can be a major draw back. Although under normal circumstances the second user should not be able to upset the first users work which included putting an update lock on the row, it would be usefull to provied this options this option through the application. To me personllay this is comming very close to allowing users to do database administration. Perhaps in the future, they might want to be able to kill each others database sessions as well. Some people might even consider this as allowing anarchy. How about trying to delete rows from syslocks table. Probably not possible. I tried it anyways and could not delete any rows even with informix user id. Anyways, our users would like to able to do this and we might have to create our own version of the syslocks table. Thank you for all you all comments. Best regards, Alireza