what's the best lock size that you could use when you
create a tablespace?
Answer Posted / 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 |
Post New Answer View All Answers
Explain about rct in db2?
How do I delete a table in db2?
What is rebind in db2?
What is performance tuning db2?
What is the use of dclgen in db2?
How can you quickly find out the # of rows updated after an update statement?
What are the contents of a dclmgen?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to execute stored procedure in db2 command editor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What does a deadlock mean in DB2?
How to fetch the last row from the table in SQL (db2)?
what is db2 restart?
What are db2 tables?
B37 abend during spufi?