Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?
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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
B.
EHL is not enabled by default in DB2 pureScale environments. However, it can be enabled or disabled by using the opt_direct_wrkld database configuration parameter.
https://www.ibm.com/docs/en/db2/10.5?topic=performance-explicit-hierarchical-locking-db2-purescale-environments