From the udt.errlog, the output of a deadlock warning:

I can understand most of this, but what does PICK REC mean in this context?
From the udt.errlog, the output of a deadlock warning:

I can understand most of this, but what does PICK REC mean in this context?
From the udt.errlog, the output of a deadlock warning:

I can understand most of this, but what does PICK REC mean in this context?
The PICK is used to differentiate between the types of PICK and PHYSICAL. In general PICK type locks are going to be created via a READL or READU statement and often called soft locks. Other than that the use of the word PICK in this regard are historical.
The types of lock that could be seen are :-
PICK FILE
PICK REC
PHYSICAL FILE
PHYSICAL RECORD
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.