Lock mode ...

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 - - ------------------------------------------------------------------ -

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

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

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 - > - ------------------------------------------------------------------ -