51) What is the difference between CS and RR isolation levels?
CS: Releases the lock on a page after use
RR: Retains all locks acquired till end of transaction
52) Where do you specify them ?
ISOLATION LEVEL is a parameter for the bind process.
53) When do you specify the isolation level? How?
During the BIND process. ISOLATION ( CS/RR )...
I use CS and update a page. Will the lock be released after I am done with
that page?
No.
54) What are the various locking levels available?
PAGE, TABLE, TABLESPACE
55) How does DB2 determine what lock-size to use?
1. Based on the lock-size given while creating the tablespace
2. Programmer can direct the DB2 what lock-size to use
3. If lock-size ANY is specified, DB2 usually chooses a lock-size of
PAGE
|