Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12502 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmisudha
locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nag(igate)
They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release
| Is This Answer Correct ? | 1 Yes | 1 No |
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
what is the difference between normal select query and currosor
What's the difference between DB2 active log and archive log? Thanks a lot...
Compare a subselect to a join?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Define predicate?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to execute stored procedure in db2 command editor?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How to check last update on table in db2?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is innodb buffer pool?
COBOL 
