What is an intent lock?

Answer Posted / vat

When using Page or Row locks, the table or tablespace lock
will be IS/IX/SIX

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does db2 sample database connect?

572


What is dbrm? When it will be created?

600


What is the use of reorg in db2?

608


On which levels locks can be applied?

659


What is the advantage in De-normalizing tables in DB2?

748






What are the benefits of using the db2 database?

662


Is it possible to create an Instance in DB2 using DB2 Control Center ?

631


What is a bind in db2?

594


How to find primary key of a table in db2?

615


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

660


Which component is used to execute the sql statements?

621


Discuss about db2 bind?

673


Define predicate?

645


Which component is responsible for processing sql statements and selecting access paths?

671


What is check constraint in db2?

609