Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
Posted: Fri Aug 26, 2022 9:58 am
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.
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.