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
- 5937 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 |
Mention the different locking levels that are available in db2.
How can you do the explain of a dynamic sql statement?
wht are the restrictions for union ?
What are the 4 environments which can access DB2 ?
What is copy pending and check pending in db2?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What are the benefits of using the db2 database?
What Utility is used to migrate DB2 from one release to the next?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is bind package and plan in db2?
What is release/acquire in bind?
What is cursor stability?
COBOL 
