There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

Question

Accepted Answer

B. set isolation to dirty read;

Answer

A. commit work;

Answer

C. set lock mode to not wait;

Answer

D. set lock mode to nolocking;

There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error…

Question

Options

How the community answered

Community Discussion