what's the best lock size that you could use when you
create a tablespace?
Answer Posted / 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 |
Post New Answer View All Answers
Where do you specify them?
What is host variable in db2 cobol?
Which component is responsible for db2 startup and shutdown?
How to execute stored procedure in db2 command editor?
How do I connect my db2 database to ibm?
Outputs of explain are with matchcols = 0. What does this signify?
Mention the downsides of page level lock.
What is the physical storage length of date data type?
What is sqlca?
What is the difference between plan and package in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is cursor with hold option in db2?
can we view the access paths created by dbrm ? how ? thx
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is deadlock in db2?