what's the best lock size that you could use when you
create a tablespace?
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 |
select 100 records from million records ?
What is the function of buffer manager?
How do I delete a table in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is a bind card?
How does one remove entries from the SCT02 table?
What is the format (internal layout) of ?TIMESTAMP??
What is a host variable?
What is a DB2 catalog?
How can the duplicate values be eliminated from db2 select?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is db2?