How do u achieve record level locking in DB2 versions when
record level locking is not allowed?

Answer Posted / nahid gorji

By using locksize page and Isolation level CS.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

886


How do you simulate the explain of an embedded sql statement in spufi/qmf?

828


is it compulsory commitment control in journal?

2202


What is the difference between dbm cfg and db cfg file in db2 ?

1249


How can you count the number of rows from a table tab?

833


What is the purpose of rollback and commit?

788


How can you classify the locks in db2?

815


How do you find the maximum value in a column in db2?

832


What are the rules for db2 programming?

840


What is the use of reorg in db2?

814


How do you select a row using indexes in db2?

839


How do I start db2 in windows?

787


What is the difference between drop table and delete table?

777


What is the maximum No of rows per page?

809


Is db2 free?

851