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
16231 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

Give a brief description of db2 isolation levels?

1075

Is db2 relational database?

983

Can we insert update delete in view?

973

What is declare cursor?

1127

Why do we use cursor?

1106

What is the physical storage length of timestamp data type?

1101

What is node in db2?

1049

What is meant by dclgen?

1114

what are bind concepts in db2 cobol?

1097

What is the difference between cursor and select statement?

1112

Mention the different locking levels that are available in db2.

1138

What is runstats and reorg in db2?

1307

What is an instance database?

1057

When the like statement is used?

1226

Give the name of some fields form sqlca.

1090