Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by repeatable read?
- 4 Answers
- 10458 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 is usage pointer in cobol?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What does db2 stand for?
What are the advantages of using a PACKAGE?
wht steps we need will coding cobol and db2 pgm ?
how to resolve -811
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is db2 connect?
Can you define an Index if the table size less than 10 PAGES?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Explain transactions, commits and rollbacks in DB2.
pls explain the precompilation process of cobol-db2 pgm
COBOL 
