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

How to get the ddl of a table in db2?

679


What does sqlcabc has?

633


Define sqlca.

649


What is plan in cobol db2?

595


What is db2 plan table?

622






Is db2 a mainframe database?

567


How to compare data between two tables in db2?

660


What is the syntax for creating a table in the db2 database?

628


What is runstats db2?

585


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

748


How to access db2 tables in mainframe?

613


What is load replace in db2?

560


What is the difference between oracle and db2?

587


Is schema the same as database?

629


What is db2?

741