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

Is db2 relational database?

917

How do I optimize a query in db2?

1042

What is bind package and plan in db2?

1006

What is null indicator in cobol db2?

994

Define db2.

1067

How is the value function used?

1084

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11618

What is buffer pool and list some of them?

984

Who uses db2?

986

How do I delete a table in db2?

1010

How to find the maximum value in a column in the db2 database?

1020

How do I create a view in db2?

977

What is the latest version of ibm db2?

1205

What is the role of data manager in the db2 database?

1055

What is the use of dclgen in db2?

1015