Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12178 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 |
Request to database but database is not available so what is was abend is raised?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
db2 restart logic ?
Can you define an Index if the table size less than 10 PAGES?
What are the abend codes occour in ur latest PROJECT in DB2
Where would you find information about the type of database authority held by the user?
how can u nderstand the sql stmts executed successfully or not ?
What is the advantage in De-normalizing tables in DB2?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
how to resolve -811 sqlcode .give clear explaination
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is the use of with ur in db2?
COBOL 
