Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by repeatable read?
- 4 Answers
- 10398 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The qualifying rows under Repeatable read will ensure that
no rows will be changed or added for the duration of the
lock.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sf
In RR isolation level, all the pages fetched in the cursor
are locked till end of transaction. This is the safest way
to ensure that no concurrent update happened when the
cursor was actiong on this data.
The confusion would be on CS . In CS only the page having
the relevant data would be locked. As the page size is 4k ,
we may lock more than one row of a table based on row size
and table space organization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
It is the highest level of isolation parameter. I will hold
the entire table till the completion of the transaction or
job. Others can not access that thable
| Is This Answer Correct ? | 1 Yes | 2 No |
What does runstats do in db2?
What is the role of data manager in the db2 database?
Mention the location where the output received from explain statement is stored.
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
In terms of DB2 indexing, what is the root page?
How do I copy a table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do I import a csv file into db2?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
COBOL 
