MAXIMUM PARTITION IS 4096 AFTER VERSION 8. EARLIER VERSION MAXIMUM PARTITI

how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none

Question Posted / sathsih

Answer Posted / sathsih

MAXIMUM PARTITION IS 4096 AFTER VERSION 8.
EARLIER VERSION MAXIMUM PARTITION IS 254.
EACH PARTITION MAXIMUM SIZE IS 64GB OF DATA.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

On which levels locks can be applied?

651

What is the latest version of ibm db2?

733

How do I create a view in db2?

597

What is check constraint. Explain with example.

639

How to connect to db2 database from windows command line?

560

What is cloudant database?

638

What is database alias db2?

593

What is universal database?

609

Explain the contents that are a part of dclgen.

651

What is a system catalog table in db2?

580

Is db2 a mainframe?

579

How to take backup of table in db2?

591

What is db2 plan table?

612

What is collection in db2 bind?

569

Mention the various locks that are available in db2.

612