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
- 6016 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 |
wt is view ? wht r the restrictions for view ?
What are the three types of page locks that can be held?
What is image copy in db2?
What does db2 blu stand for?
What is QUIESCE?
what needs to be done if a table is in copy pending / check pending status?
What is an intent lock?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
what is Runstats? Whem will u choose to runatats?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
how to u check the query is executing or not ?where will u check for sqlcode ?
What is cursor in dbms?
COBOL 
