What are the three lock types?

Answer Posted / s

Share, Update, Exclusive

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is reorg?

610


What is a plan and package in db2?

609


How can we retrieve the total number of records in RPG & CLLE?

185


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

613


How do you eliminate duplicate values in db2?

677






What is the syntax for seeing the columns and data types of a table in the db2 database?

571


Is the primary key a clustered index?

597


What is dbrm library?

570


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

689


Which isolation level provides highest data integrity?

586


Can you tell me how can you find out the # of rows updated after an update statement?

602


What is bufferpool in db2?

568


What is plan in cobol db2?

578


What is the use of runstats in db2?

567


What is the use of dclgen in db2?

579