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

Once you create a view, where would information about the view be stored?

What is a correlated sub query?

What is database reorganization?

What is precompiler in db2?

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

What are bind parameters in db2?

How do you prepare a COBOL + DB2 program from coading till execution ?

What is meant by union and union all?

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

What is the database descriptor?

What is copy pending and check pending in db2?

What is ACQUIRE/RELEASE in BIND?

For more DB2 Interview Questions Click Here