What are the various locks available?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 schema?

758


what is utility for parm lib

1868


What is ibm db2 connect?

568


Highlight all the advantages that are attached to a package.

621


What is the role of schema in the db2 database?

645






ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1587


What is the difference between spufi and qmf?

633


What's The Percentage Free Space ?

761


What is dbrm library?

572


Why do we bind in db2?

621


What is sqlca?

608


Explain about rct.

643


Explain the contention situations caused by locks?

585


What is a cursor in programming?

587


Is db2 a database?

569