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
- 5839 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 |
How to select the duplicate rows from a table?
What is reorg and runstats in db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is cursor stability in db2?
What is DB2 (IBM Database 2)?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can deadlocks be resolved?
What is db2 catalog database?
How can we read records for specific member in CL? AND rpg?
wht r the requirements for writing a cobol-db2 pgm ?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
Explain the contents that are a part of dclgen.
COBOL 
