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

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?..

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

Is This Answer Correct ?

3 Yes

6 No

More DB2 Interview Questions

what is dynamic cursor?gives syntax for this?

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

Write a query to retrive partial string.

What is the maximum size of a char data type in db2?

Explain various types of locks in db2?

How do I optimize a query in db2?

What is the use of COMMAREA ?Minimum how much data we can pass from it?

What is ibm db2 connect?

what is the difference between where clause and having clause

what is difference between random and sequence file access

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

How is the SUBSTR keyword used in sql?

For more DB2 Interview Questions Click Here