Interested to Buy Any Domain ? << Click Here >> for more details...
what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 6013 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What's the difference between DB2 active log and archive log? Thanks a lot...
How does the processing of a correlated subquery differ from a non correlated subquery?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is db2 purescale?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
How to resolve -803 sql code in DB2?
Mention the definition of cobol in varchar field.
What keyword does an SQL SELECT statement use for a string search?
What is node in db2?
What is an alias and how does it differ from a synonym?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is RUNSTATS?
COBOL 
