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
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?
What's The Error Code For Unique Index Voilation?
What are the two types of logging in the db2 database? Explain them.
Name the lockable units in DB2?
Explain about open switch business continuity software?
What is runstats and reorg in db2?
What is lock escalation in db2?
What is the connection string to connect to the DB2 Database ?
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 ?
What is the purpose of rollback and commit?
List out the data types available.
What is the purpose of using commit?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is meant by explain?
How to create db2 table in mainframe?