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 |
What is db2 command?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How to find schema of a table in db2?
What is bind plan?
How to check table size in db2 sap?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is the role of data manager in the db2 database?
how to take the back up of the DB2 table.
How can you display the current date & current time ?
What does CURRENTDATA option in bind indicate
what is a plan and how do you refer the plan in the program?
What is the purpose of the QUIESE Utility?