DB2 10 for z/OS Database Administrator — Question 35

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

Answer options

• A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
• B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
• C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
• D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Correct answer: C

Explanation

The correct command is C, as it specifically configures the LOCKLIST and MAXLOCKS parameters, which are necessary for enabling EHL. The other options do not relate to setting the required locking parameters for EHL in a DB2 pureScale environment.