what's the best lock size that you could use when you
create a tablespace?

Answer Posted / kums

If we specify LOCKSIZE(ANY), DB@ will decide the optimum
locking Mechanism for the best use.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is db2 restart?

1684


What are the contents of dclgen?

650


What are the full forms of spufi and dclgen and why are they used?

652


Mention the different locking levels that are available in db2.

635


What is a db2 package?

597






Can we update view in db2?

555


What is plan in cobol db2?

585


What is the use of with ur in db2?

615


Where do you specify them?

674


Explain the benefits you can get from mainframe connect?

520


What is the use of db2 optimizer?

603


Is db2 a mainframe database?

561


Can you tell me how can you find out the # of rows updated after an update statement?

602


What is the maximum length of sqlca?

859


What is the use of reorg in db2?

597