IBM Exam Questions

Which of the following commands will reduce lock contention?

Users are complaining that the online store is slow. An administrator investigates and concludes the issueis related to locking contention.
Which of the following commands will reduce lock contention?

A.
db2 update db cfg for mall using MAXLOCKS 5

B.
db2 update db cfg for mall using MAXLOCKS 15

C.
db2 update db cfg for mall using LOCKLIST 64

D.
db2 update db cfg for mall using LOCKLIST 256

E.
db2 update db cfg for mall using DLCHKTIME 15000