Re: how to remove stale locks ?

Christian Haul wrote: > > Hi. > > Over here student develop programs in java using the jdbc:odbc bridge > to connect to informix oline 7.23. When their programs crash, the locks > are not released properly. Hence I need a way to remove them. So far I > couldn't find a proper way how to do it. Taking informix offline and > then online again is no real option. > > So how is this done? Have you tried to kill the sessions? This is done as informix or root with: onmode -z <sessid> That should cause the session to rollback any transaction (which may take time) and exit releasing any locks or latches and other resources. To verify that the onmode -z is working run onstat -g ses <sessid> and look for the 'R' for rollback in the session flags field. There are conditions where even this will not work and you will have to bring down the engine to release resources, though this is rare. Art S. Kagel