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 -904 sql code? How to resolve it?

What is db2 instance?

Can one database have multiple instances?

What is the purpose of the QUIESE Utility?

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

Is db2 a database?

How do you do the EXPLAIN of a dynamic SQL statement?

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

wt is view ? wht r the restrictions for view ?

What is DCLGEN ?

For more DB2 Interview Questions Click Here