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 universal database?

622


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


How would you find out the total number of rows in a db2 table?

579


What is bind package and plan in db2?

597


What is release/acquire in bind?

656






Explain what are the various isolation levels possible?

610


What is the use of with ur in db2?

618


Mention the location where the output received from explain statement is stored.

632


What's The Percentage Free Space ?

775


What is the difference between spufi and qmf?

641


How do I create a view in db2?

606


What are the various isolation levels possible?

650


Explain in detail about buffer manager and its functionalities?

567


Mention the various locks that are available in db2.

618


What is an instance in db2?

567