what's the best lock size that you could use when you
create a tablespace?
- 2 Answers
- 4865 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 |
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What are union and union all?
How can we retrieve the total number of records in RPG & CLLE?
Is db2 a database?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is the role of union all and union
How do you define a correlated name?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is the difference between oracle and db2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Is it mandatory to use DCLGEN? If not, why would you use it at all?
How does one remove entries from the SCT02 table?
COBOL 
