what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 6069 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 is the use of DELGEN in DB2? Can we Write the program with out using it?
What is dbrm? What it contains?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
what is the use of bind parameter, Replace?
Explain about cursor stability?
What is DCLGEN ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is an alias?
What is a clustered index?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
On which levels locks can be applied?
COBOL 
