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 are catalog tables in db2?

610


What is check constraint. Explain with example.

650


How do I delete a column in db2?

680


Explain the function of data manager.

632


How to test SQL -911 error while developing COB-DB2 program

6720






What does runstats do in db2?

607


Define predicate?

645


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1238


What db2 400?

679


What is cobol db2?

570


Is db2 a database?

574


How do you pull up a query which was previously saved in qmf?

676


Explain about dbrm.

609


What happens in bind step in a db2 program?

569


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

670