Examice

Exam C2090-600 All QuestionsBrowse all questions from this exam

Go to Exam

Question 49

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

UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Correct Answer: B

The command to enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment is 'UPDATE DB CFG USING OPT_DIRECT_WRKLD YES'. This command affects the entire Db2 pureScale instance and is specifically used to enable EHL.

Discussion

db2testerOption: B

The correct answer is OPT_DIRECT_WRKLD. This database configuration parameter enables or disables explicit hierarchical locking (EHL). It affects the entire Db2® pureScale® instance. REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0061024.html

JamesBondOption: B

B https://www.ibm.com/docs/en/db2/11.1?topic=performance-explicit-hierarchical-locking-db2-purescale-environments