how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
Answer Posted / vish
Unfortunately nonoe of the above answers are completely
correct. Answer posted by Nawal Kishore is partly correct
but not the complete answer. Answer from Vani may be partly
correct depending upon the DSSiZE and the page size. Let me
try to answer the question:
DB2 alllows a maximum of 4096 partitions of a partitioned
table space. Actually, the maximum number of partitions in
a table space depends on the data set size (DSSIZE
parameter) and the page size. Thus the partitions can range
from 1 to 4096 depending upon the above parameters (DSSIZE
ands the page size).
You can refer to IBM documentations to confirm the
same...suggesstions are welcome...!!
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the maximum length of sqlca?
What is db2 plan table?
What are foreign keys in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How to view db2 table structure?
What is multi row fetch in db2?
How does coalesce work?
What is null in db2?
What is a cursor in programming?
What is check constraint in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the advantage in De-normalizing tables in DB2?
What is reorg and runstats in db2?
What is syscat in db2?
B37 abend during spufi?