What is the difference between CS and RR isolation levels?
Answer / s
CS - page or row locks are released as soon as the cursor
is moved to another row or page.
RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.
Is This Answer Correct ? | 8 Yes | 2 No |
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is a DB2 catalog?
How do you check for a null value in a db2 column?
What will the COMMIT accomplish?
Can SQL statements/queries be included in a copybook?
Which isolation level provides highest data integrity?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
How can you display the current date & current time ?
What will the DB2 optimizer do?
What is load utility in db2?
What is an inner join, and an outer join ?
What is the difference between static and dynamic SQL?