This database configuration parameter enables or disables explicit hierarchical locking (EHL). It affects the entire DB2® pureScale® instance.
The opt_direct_wrkld parameter specifies whether tables or range partitions are eligible to enter the NOT_SHARED state. It applies globally across all DB2 pureScale members. This parameter is supported only for instances that are part of DB2 pureScale environments.
This parameter does not require optimization profile support.
db2 update db cfg for <dbname> opt_direct_wrkld YES