IBM
C2090-619 · Question #32
The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?
The correct answer is B. Increase the LOCKS configuration parameter. See the full explanation below for the reasoning.
Question
The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?
Options
- ARun onclean utility to clear the lock table.
- BIncrease the LOCKS configuration parameter.
- CTurn on the AUTO_TUNE configuration parameter.
- DChange the DEF_TABLE_LOCKMODE configuration parameter from page to row.
How the community answered
(31 responses)- A10% (3)
- B81% (25)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.