Oninit cdi / Archive
Talk to an expert →

Lock mode ...

Posted in 2000

Summary

Arnaud Andrieux asked how to see whether an IDS 7.31 TC2 instance on NT4 uses lock wait or no wait, suspecting the default is not wait. Thomas Mieslinger confirmed NOT WAIT is the default and an application must issue SET LOCK MODE to change it. Rudy Fernandes added that the mode is per session and that onstat -g sql shows the settings of connected sessions.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Versions, Editions & End-of-Life

Arnaud ANDRIEUX — — source: Informix-list mailing list archive (1991-1998)

Hi All ! Again a question of lock management !! How can I see which behaviour has my instance on lock management : lock wait, lock not wait ? I have run some tests so I suppose that default IDS configuration is 'not wait' ?... I run IDS 7.31 TC2 on NT4 SP5. Thanks -- - ------------------------------------------------------------------ - - Arnaud ANDRIEUX arnaud.andrieux@aql.fr - - Ingenieur en developpement tel direct : 02.99.12.52.22 - - Direction Metier Industrie - - ------------------------------------------------------------------ - - Alliance Qualite Logiciel http://www.aql.fr - - GROUPE SILICOMP http://www.silicomp.fr - - - - Rue de la Chataigneraie - - B.P. 127 - - 35513 CESSON SEVIGNE - - FRANCE - - tel : (33) (0)2.99.12.50.00 - - fax : (33) (0)2.99.63.70.40 - - ------------------------------------------------------------------ -

↪ replying to Arnaud ANDRIEUX
Thomas Mieslinger — — source: Informix-list mailing list archive (1991-1998)

Hi Arnaud, not wait is the default behaviour. Your Application must issue a "set lock mode to ..." for a diffrent behavior. Please look at the Manual for a detailed description of set lock mode Command. Thomas Arnaud ANDRIEUX wrote: > > Hi All ! > > Again a question of lock management !! How can I see which behaviour has > my instance on lock management : lock wait, lock not wait ? I have run > some tests so I suppose that default IDS configuration is 'not wait' > ?... > > I run IDS 7.31 TC2 on NT4 SP5. > > Thanks > > -- > - ------------------------------------------------------------------ - > - Arnaud ANDRIEUX arnaud.andrieux@aql.fr - > - Ingenieur en developpement tel direct : 02.99.12.52.22 - > - Direction Metier Industrie - > - ------------------------------------------------------------------ - > - Alliance Qualite Logiciel http://www.aql.fr - > - GROUPE SILICOMP http://www.silicomp.fr - > - - > - Rue de la Chataigneraie - > - B.P. 127 - > - 35513 CESSON SEVIGNE - > - FRANCE - > - tel : (33) (0)2.99.12.50.00 - > - fax : (33) (0)2.99.63.70.40 - > - ------------------------------------------------------------------ - -- Thomas Mieslinger German Parcel Paket Logistik GmbH & Co German-Parcel-Str. 1-7 Fon: +49 6677 17 463 36282 Neuenstein Fax: +49 6677 17 111 Germany Mobil: +49 170 510 6095

↪ replying to Arnaud ANDRIEUX
Thomas Mieslinger — — source: Informix-list mailing list archive (1991-1998)

Hi Arnaud, not wait is the default behaviour. Your Application must issue a "set lock mode to ..." for a diffrent behavior. Please look at the Manual for a detailed description of set lock mode Command. Thomas Arnaud ANDRIEUX wrote: > > Hi All ! > > Again a question of lock management !! How can I see which behaviour has > my instance on lock management : lock wait, lock not wait ? I have run > some tests so I suppose that default IDS configuration is 'not wait' > ?... > > I run IDS 7.31 TC2 on NT4 SP5. > > Thanks > > -- > - ------------------------------------------------------------------ - > - Arnaud ANDRIEUX arnaud.andrieux@aql.fr - > - Ingenieur en developpement tel direct : 02.99.12.52.22 - > - Direction Metier Industrie - > - ------------------------------------------------------------------ - > - Alliance Qualite Logiciel http://www.aql.fr - > - GROUPE SILICOMP http://www.silicomp.fr - > - - > - Rue de la Chataigneraie - > - B.P. 127 - > - 35513 CESSON SEVIGNE - > - FRANCE - > - tel : (33) (0)2.99.12.50.00 - > - fax : (33) (0)2.99.63.70.40 - > - ------------------------------------------------------------------ - -- Thomas Mieslinger German Parcel Paket Logistik GmbH & Co German-Parcel-Str. 1-7 Fon: +49 6677 17 463 36282 Neuenstein Fax: +49 6677 17 111 Germany Mobil: +49 170 510 6095

↪ replying to Arnaud ANDRIEUX
Rudy Fernandes — — source: Informix-list mailing list archive (1991-1998)

The lock mode is set at the session level, defaulting (AFAIK) to NOT WAIT. To see the actual settings of connected sessions, run "onstat -g sql". Rudy Arnaud ANDRIEUX wrote: > Hi All ! > > Again a question of lock management !! How can I see which behaviour has > my instance on lock management : lock wait, lock not wait ? I have run > some tests so I suppose that default IDS configuration is 'not wait' > ?... > > I run IDS 7.31 TC2 on NT4 SP5. > > Thanks > > -- > - ------------------------------------------------------------------ - > - Arnaud ANDRIEUX arnaud.andrieux@aql.fr - > - Ingenieur en developpement tel direct : 02.99.12.52.22 - > - Direction Metier Industrie - > - ------------------------------------------------------------------ - > - Alliance Qualite Logiciel http://www.aql.fr - > - GROUPE SILICOMP http://www.silicomp.fr - > - - > - Rue de la Chataigneraie - > - B.P. 127 - > - 35513 CESSON SEVIGNE - > - FRANCE - > - tel : (33) (0)2.99.12.50.00 - > - fax : (33) (0)2.99.63.70.40 - > - ------------------------------------------------------------------ -

Related threads

Glossary