PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply