Depends on version of DB2 also V7: 64: NOT (LARGE OR DSSIZE

how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none

Question Posted / vat

8 Answers
16443 Views
Amdocs, HeadStrong, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is meant by union and union all?

1051

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1235

What is load replace in db2?

1048

what is the role of the cursor in db2?

1110

What is a dbrm in db2?

1077

What is check constraint. Explain with example.

1162

What is a buffer in memory?

1107

What is phantom read in db2?

1224

What type of database is db2?

1019

what is diffrence b/w file-aid tool and file-aid utility???

4959

What is the difference between dbm cfg and db cfg file in db2 ?

1591

Explain the function done by data manager?

1330

How will you return the number of records in table?

986

What are the different types of base tables?

1163

What are host variables in db2?

1122