Will key locking strategy in OnLine be changed?
Posted in 1993
Topics: General Discussion
Not long ago I read an article in this group about the strategy used in OnLine whereby locks are placed on adjacent keys when a row has been inserted or deleted. Someone mentioned that they heard that this will be changed in a future release. What I would like to know is if anyone can confirm or deny that this will be changed? And if so, when and what to? My problem is that I want to be able to ensure at a certain point in a transaction that a row can be deleted later in the transaction. I thought I would be able to do this by getting an exclusive lock on the row. This will not work if another user inserts a row with a key between the one I want to delete and the next 'higher' key, because a lock will be placed on the new key, thereby causing my delete to fail. If Informix changes this strategy it may make it easier for me. TIA for any help on this. -- /~~` /~~\\ /~~` /| /| /| Stephen Szalla sms@mel.cocam.oz.au | | |-| /-| / | / | Co-Cam Computer Group Tel: +61 3 286 3456 \\__, \\__/ \\_ / |/ |/ | Melbourne, Australia Fax: +61 3 417 7857