Conference smurf::ase

2024.0. "dlm_quecvt() question" by TKTV30::HASEGAWA () Fri Apr 25 1997 09:25

Our DB vender have a question on convrting lock (dlm_quecvt).

TCR V1.4, Digital UNIX V4.0A

As the below, if dlm_quecvt() twice for same object continuously, 
DLM_LKBUSY  should be returned, or DLM_NOTQUEUED should be returned ?

They expect DLM_NOTQUEUED, but on test, DLM_LKBUSY returned.

[1] dlm_quecvt() rqmode: DLM_PRMODE, flags: DLM_SYNCSTS
[2] dlm_quecvt() rqmode: DLM_PWMODE, flags: DLM_SYNCSTS | DLM_NOQUEUE

 dlm_quecvt([1]);
 dlm_quecvt([2]);
   .....

Above condition occures on the below SQL

         Node A                               Node  B
lock table xxx in shae mode nowait;
					  lock table xxx in share mode nowait;
lock table xxx in share row exclusive nowait;
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Which error should be retuned ? Please let me know about it.

Thanks in advance.

/Hase