nerdexam
IBM

C2090-600 · Question #14

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

The correct answer is C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90. See the full explanation below for the reasoning.

Question

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

Options

  • AUPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
  • BUPDATE DB CFG USING OPT_DIRECT_WRKLD YES
  • CUPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
  • DUPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

How the community answered

(45 responses)
  • A
    11% (5)
  • B
    2% (1)
  • C
    80% (36)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C2090-600 Practice