Oninit cdi / Archive
Talk to an expert →

Informix row locks

Posted in 2007

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Transactions, Locking & Isolation, Versions, Editions & End-of-Life

Greg Bunting — — source: IIUG Forums & Mailing Lists

We currently have a I4GL applications running on IDS 7.23 on SCO Uni= x 5.0.06 (yeah - I know this is archaic) but this server also runs Sage= line 500 which is not supported on later versions of IDS. One of the routines is occasionally leaving a row lock on a table which= results in the other sessions 'hanging' trying to access or insert dat= a in the same table. Is there any way of releasing the lock on the row? This table stores th= e process ID but the process is no longer running. Thanks Greg. [3D"cid:0__=3D0FBBF835DFC6110A8f9e8a@wharncliffe.co.uk"] Wharncliffe Business Systems Ltd Wentworth Industrial Park | Maple Road | Tankersley | Barnsley | S75 3D= L Tel: 01226 361100 | Fax: 01226 361122 | Web: [1]www.wharncliffe.co.uk | Directions: [2]www.wharncliffe.co.uk/contactus This email is subj= ect to the terms defined here [3]http://www.wharncliffe.co.uk/disclaimer/ = References 1. 3D"http://w=/ 2. 3D"http://www.wharncl=/ 3. 3D"http://www.wharncliffe.=/

↪ replying to Greg Bunting
Marcus Haarmann — — source: IIUG Forums & Mailing Lists

Hi, Search for the locking session and kill it with onmode -z. The session will rollback and the lock is gone. Marcus -----Original Message----- From: Greg Bunting [mailto:Greg.Bunting@wharncliffe.co.uk] Sent: Thursday, March 22, 2007 5:12 PM To: ids@iiug.org Subject: Informix row locks [8703] We currently have a I4GL applications running on IDS 7.23 on SCO Uni= x 5.0.06 (yeah - I know this is archaic) but this server also runs Sage= line 500 which is not supported on later versions of IDS. One of the routines is occasionally leaving a row lock on a table which= results in the other sessions 'hanging' trying to access or insert dat= a in the same table. Is there any way of releasing the lock on the row? This table stores th= e process ID but the process is no longer running. Thanks Greg. [3D"cid:0__=3D0FBBF835DFC6110A8f9e8a@wharncliffe.co.uk"] Wharncliffe Business Systems Ltd Wentworth Industrial Park | Maple Road | Tankersley | Barnsley | S75 3D= L Tel: 01226 361100 | Fax: 01226 361122 | Web: [1]www.wharncliffe.co.uk | Directions: [2]www.wharncliffe.co.uk/contactus This email is subj= ect to the terms defined here [3]http://www.wharncliffe.co.uk/disclaimer/ = References 1. 3D"http://w=/ 2. 3D"http://www.wharncl=/ 3. 3D"http://www.wharncliffe.=/ ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary