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

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1630


What's The Error Code For Unique Index Voilation?

659


What are the two types of logging in the db2 database? Explain them.

585


Name the lockable units in DB2?

669


Explain about open switch business continuity software?

571






What is runstats and reorg in db2?

806


What is lock escalation in db2?

582


What is the connection string to connect to the DB2 Database ?

618


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1718


What is the purpose of rollback and commit?

599


List out the data types available.

712


What is the purpose of using commit?

624


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1586


What is meant by explain?

668


How to create db2 table in mainframe?

639