Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

Post by answerhappygod »

Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

A. EHL is enabled by default in DB2 10.5 pureScale environments.
B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.
C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.
D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”