What are the various locks available?
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 |
How to restart a DB2 program?
Can there be more than one cursor open for any program?
how can u understand the end of the table ?
What is plan in cobol db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are PACKAGES ?
How connect db2 database to datastage?
What is page size in db2?
What are the advantages of using a PACKAGE?
what is check point and restart Logic ? why do we go for that ??
How can you do the explain of a dynamic sql statement?
How is the SUBSTR keyword used in sql?