Hi,
In case i want a thread to wait, i need to specify the same
using SET LOCK MODE TO WAIT <n>.

but this preference is retained only for that particulat session/connection.

Is there a way wherein i can specify the same as a global setting for my database itself?

Hi,

The SET LOCK MODE TO WAIT <n> must by set in the aplication, by default is NOT WAIT.
Now, if this is imposible, maybe set lock mode first calling one SPL and set into.

Gustavo.

HI,
I am trying to avoid an additional database call from the application to set the wait, each time i neet to fire a query.

Hi,
An additional information -
I am using Informix Dynamic Server Ver. 9.30 FC2

Hi Amit,

One question: The lock level of tables are page or row ?

Gustavo.

The SET LOCK MODE lasts for the session. You don't need to call it for each query.

Hi Gustavo,
The lock mode is Row.

Hi Fred,
In my case the session are being managed by the Application server,
and i wouldn't know if the session is a new one or an older one(On which i have already fired SET LOCK MODE TO WAIT n).

Hi,

I need to know what is the current value for Lock Mode Wait setting.

How can I do that ?

thanks

hi dubeda,

you can query the sysmaster database and check it out

for the specific table - select tabname, locklevel from systables
where tabname="<the table name>"

Each session on the app server would have had to have issued the connect sequence. we fire the "set lock mode to wait" immediately following the "connect".