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

Answer Posted / s

PAGE lock size performs well in most situations. Use Row
level locking if there is lock contentions.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a collection in db2?

584


Why do we use cursor?

599


What is db2 purescale?

551


Before you give the explain statement, what are the prerogatives?

581


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

654






How does cobol compile db2 program?

610


How to find the number of rows in db2 tables?

619


What is bind in db2?

608


What is db2 plan table?

622


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

583


Why cursor is used in db2?

577


Differentiate between cs and rr isolation levels? Where do you specify them?

587


What's The Error Code For Unique Index Voilation?

656


Is db2 a programming language?

608


Is db2 relational database?

574