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
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are host variables in db2?
What is ibm db2 client?
What is blu acceleration in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is load utility in db2?
What db2 400?
How do you find the maximum value in a column in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How does cobol compile db2 program?
How do you stop a db2 database in linux?
What os does db2 run on?
What is db2? Explain.
How to create db2 table in mainframe?
What are catalog tables in db2?