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

Answer Posted / s

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

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the rules for db2 programming?

852


What is db2 connect?

793


When reorg is used?

852


What is the maximum number of columns in a db2 table?

979


Where can you declare a cursor in a cobol-db2 program?

775


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

795


How can you count the number of rows from a table tab?

837


How to find primary key of a table in db2?

809


What is the difference between plan and package in db2?

827


What is dbrm? What it contains? When it will be created?

795


How can we retrieve the total number of records in RPG & CLLE?

372


How would the varchar column remarks defined?

843


What is a bind in db2?

768


How will you return the number of records in table?

701


What is the syntax for FETCH in DB2 ?

910