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

How can record locking be achieved in those DB2 versions which do not support it?

627


What is the difference between spufi and qmf?

640


What is the clustering index in the db2 database?

586


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2048


What is release/acquire in bind?

656






What is alias in db2?

572


What is ibm db2 database?

541


Define db2.

672


What is the use of predicate?

588


How and when does the db2 enforces the unique key?

616


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1821


What does db2 plan contain?

573


what is db2 restart?

1695


When the like statement is used?

640


What is db2 catalog database?

582