what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 4881 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 |
Define check constraint.
What does an outer join do?
What are the various locking levels available?
wht steps we need will coding cobol and db2 pgm ?
What is a Cartesian product?
Which are the db2 tools to protect integrity of the database?
how to resolve -811 sqlcode .give clear explaination
How can deadlocks be resolved?
can we view the access paths created by dbrm ? how ? thx
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Once you create a view, where would information about the view be stored?
What is -904 sql code? How to resolve it?
COBOL 
