What are the three lock types?

Answer Posted / raji

intent,shared,exclusive,update,bulk

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2247


How do I add a column in db2?

570


What is bind package and plan in db2?

570


what is the sqlcode -501

11188


What db2 400?

655






What is runstats and reorg in db2?

763


Define declaration generator (dclgen).

648


What is the use of commit in db2?

612


How will you return the number of records in table?

496


How do you select a row using indexes in db2?

616


What is dbrm? What it contains?

644


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1211


What is the difference between cursor and select statement?

592


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

711


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?

1604