Antwort: Re: Looking for documentation of IFCID 21 (Lock Detail), Field QW0021SC (IRLM

Rolf Drees

Antwort: Re: Looking for documentation of IFCID 21 (Lock Detail), Field QW0021SC (IRLM
Hello Bart,

many thanks for your fast answer! I didn't thought that someone would
answer this question. Your answer helps a lot to me (unusual english, sry
for that, but I hope you know what I mean).

Kind regards
Rolf Drees
Anwendungsentwicklung Querschnittsfunktionen / Datenbankmanagement
Tel.: 0251 7133 - 2238 ; Fax.: 0251 7133 - 92238

GAD eG
GAD-Straße 2 - 6
48163 Münster

http://www.gad.de

Vorstand: Anno Lederer (Vors.), Dr. Elmar Pritsch (stv. Vors.), Jörg
Dreinhöfer, Friedhelm Wagner
Aufsichtsratsvorsitzender: Wilfried Guttmann
Sitz: Münster/Westf., Amtsgericht Münster, Genossenschafts-Register 337



Bart Steegmans <[login to unmask email]>
13.01.2009 11:47

An
[login to unmask email], [login to unmask email]
Kopie
Bart Steegmans <[login to unmask email]>
Thema
Re: Looking for documentation of IFCID 21 (Lock Detail), Field QW0021SC
(IRLM Subcodes)






Hello Rolf,

You can happily ignore the last two bytes of QW0021SC. It's the first two
that really indicate the IRLM Reason Code and are of interest.
So in your case, a LOCK request, with RC x'04' RSN x'10 00'
(byte 1) Reason code X’10’ The lock is already held.
So it is a lock that was already acquired by this tran/job during a
previous
lock request; for example because you are updating another row on the same
page.

Kind regards,
Bart Steegmans.