what are the max. & min. no. of partitions allowed in a partition tablespa

what are the max. & min. no. of partitions allowed in a
partition tablespace?

Question Posted / guest

2 Answers
8990 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the max. & min. no. of partitions allowed in a partition tablespace?..

Answer / rahul

1 to 64

Is This Answer Correct ?

0 Yes

0 No

what are the max. & min. no. of partitions allowed in a partition tablespace?..

Answer / s

The maximum number of partitions allowed in DB2 V8 is 4096
partitions.

Is This Answer Correct ?

3 Yes

6 No

Post New Answer

More DB2 Interview Questions

What is the max length of sqlca?

0 Answers

What is db2 purescale?

0 Answers

What is syscat in db2?

0 Answers

What is ibm db2 connect?

0 Answers

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers JPMorgan Chase,

how can u understand the end of the table ?

1 Answers TCS,

What is the physical storage length of time data type?

0 Answers

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers

What is a lock?

1 Answers

where will u check for sqlcode ?

2 Answers TCS,

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers

When is the access path determined for dynamic SQL?

2 Answers

For more DB2 Interview Questions Click Here