how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sathsih
MAXIMUM PARTITION IS 4096 AFTER VERSION 8.
EARLIER VERSION MAXIMUM PARTITION IS 254.
EACH PARTITION MAXIMUM SIZE IS 64GB OF DATA.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Define declaration generator (dclgen).
What is the physical storage length of timestamp data type?
Which component is responsible for db2 startup and shutdown?
How many databases are there?
What is cursor stability?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Is db2 a programming language?
what are bind concepts in db2 cobol?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is rct?