How does DB2 determine what lock-size to use?

Answer Posted / s

LOCKSIZE is defined with the CREATE TABLESPACE DDL.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is diffrence b/w file-aid tool and file-aid utility???

4536


What is the difference between plan and package in db2?

847


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

11390


i want to maintain uniqueness on pdf without make lf??????????

1912


What is meant by explain?

867


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3340


What is drop table?

787


Explain dclgen.

943


What is reorg and runstats in db2?

964


what is the role of the cursor in db2?

829


What is runstats and reorg in db2?

1031


Are view updateable?

821


How will you return the number of records in table?

717


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?

1854


What are the contents of dclgen?

859