Skip to main content
Question

What is PICK REC in this context?

  • April 8, 2025
  • 1 reply
  • 1 view
Kevin King

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?

    1 reply

    Jonathan Smith
    Forum|alt.badge.img
    • Jonathan SmithRocketeer
    • Rocketeer
    • 356 replies
    • April 8, 2025

    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


    Terms & ConditionsAccessibility statement