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

When do you specify the isolation level?

1073

What are the rules for db2 programming?

1155

What is cobol db2?

1049

What is catalog database in db2?

1218

How to test SQL -911 error while developing COB-DB2 program

7673

What are catalog tables in db2?

1109

What does a deadlock mean in DB2?

1221

How to connect to db2 database from windows command line?

1141

What language is db2 written in?

1107

What is buffer pool and list some of them?

1098

What is bind and rebind in db2?

1191

List out the buffer pools in db2

1131

What is runstats and reorg in db2?

1363

What is multi row fetch in db2?

1105

How and when does the db2 enforces the unique key?

1143