how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
Answer Posted / vat
Depends on version of DB2 also
V7:
64: NOT (LARGE OR DSSIZE > 2GB)
254: LARGE OR DSSIZE > 2GB
V8:
64: NOT (LARGE OR DSSIZE > 2GB)
4096: Depending on what's specified for DSSIZE OR LARGE and
the page size
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is meant by union and union all?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is load replace in db2?
what is the role of the cursor in db2?
What is a dbrm in db2?
What is check constraint. Explain with example.
What is a buffer in memory?
What is phantom read in db2?
What type of database is db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the difference between dbm cfg and db cfg file in db2 ?
Explain the function done by data manager?
How will you return the number of records in table?
What are the different types of base tables?
What are host variables in db2?