What are the various locks available?

Answer Posted / muthusamy

share,exclusive and update

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 plan table?

622


How can you find out the # of rows updated after an update statement?

641


What is node in db2?

609


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


How many types of page locks can be held in db2?

593






How does a cursor work?

558


What is the difference between using bind () and rebind () methods of naming class?

795


Mention the downsides of page level lock.

711


Is ibm db2 free?

575


Which is faster delete or truncate?

681


What is copy pending status in db2?

636


What do you mean by between and in? Is between inclusive of specified range values?

668


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

1597


What is a db2 tablespace?

602


Who uses db2?

576