what are the max. & min. no. of partitions allowed in a
partition tablespace?
Answers were Sorted based on User's Feedback
Answer / s
The maximum number of partitions allowed in DB2 V8 is 4096
partitions.
Is This Answer Correct ? | 3 Yes | 6 No |
What is normalization and what are the five normal forms?
How do you select a row using indexes in db2?
what is check point and restart Logic ? why do we go for that ??
What is a synonym? How is it used?
What is a NULL value? What are the pros and cons of using NULLS?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
How to resolve -818 sql code in DB2?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is deadlock in db2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is PRIME TABLE and what are the uses of it
What is difference between alias and synonym in db2?