PrepAway - Latest Free Exam Questions & Answers

Which two actions can they take to reduce this contention?

In a data sharing system, a system programmer observes very high page p-lock contention.
Which two actions can they take to reduce this contention? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Reduce row level locking for objects used in high volume transactions.

B.
For table spaces defined with LOCKSIZE ANY, useISOLATION(UR) for high volume query
transactions using these objects.

C.
ALTER heavy used table spaces to use COMPRESS NO.

D.
Ensure heavy used indexes are defined with COPY NO.

E.
ALTER heavy used table spaces to use TRACKMOD NO.


Leave a Reply