Rocket U2 | UniVerse & UniData

 View Only

 What is PICK REC in this context?

Kevin King's profile image
Kevin King posted 04-08-2025 11:25

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?

Jonathan Smith's profile image
Jonathan Smith

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