This metric shows the average lock time duration as computed by (LOCK_WAIT_TIME / LOCK_WAITS).
Average Lock Time can be improved by elminating redundant indexes, eliminating indexes with very low cardinalities, eliminating unused indexes, and by improving the speed and efficiency of the statement workload with appropriate indexes, MDC tables, and MQT tables.
To reduce average lock times, analyze the SQL workload to find statements with the highest average elapsed times and the highest CPU costs, then implement Clustering indexes, MDC tables, or MQTs to improve statement speed and efficiency. For best results in the least amount of time, DBI suggests using pureFeat for DB2 LUW.