DB2 Cursor Stablity

I) Cursor Stablity Leads to Higher concurency
ii) Repeatable Read Leads to Higher consistency

1 Both are True
2 i) Is Only True
3 ii) is only True
4 Neither is True
Both are True

Questions by radibioinfo   answers by radibioinfo

Showing Answers 1 - 15 of 15 Answers

Gurumoorthy K

  • Jul 3rd, 2014
 

4. Neither is true.

Cursor Stability Leads to Higher Consistency which means the data is very much reliable.
Repeatable Read Leads to Higher concurrency, means data availability as there is no lock over the table.

Guru

  Was this answer useful?  Yes

Rama

  • Nov 20th, 2016
 

Cursor Stability provides the High Concurrency (more than one db2 application program can access resource) as it locks only one row.
Repeatable Read Leads to Higher consistency as it hold the page

So both are true

  Was this answer useful?  Yes

Dinu

  • Dec 3rd, 2017
 

- Used as row level locking
- Acquires an exclusive lock on the row that is to be updated.
- When the control is moved to the next updatable row, the lock is released.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions