What are the various locking levels available?

Answer Posted / sadiq afroze

PAGE, TABLE, TABLESPACE

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system catalog table in db2?

683


What are the different types of base tables?

658


Why do we use cursor?

681


What is commit in db2?

687


What is release/acquire in bind?

733






Which is faster delete or truncate?

767


What is ibm db2 used for?

697


What do you mean by between and in? Is between inclusive of specified range values?

769


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11171


Why do we bind in db2?

737


What is meant by explain?

742


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?

1723


How many databases are there?

668


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2504


How does coalesce work?

670