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

How to fetch the last row from the table in SQL (db2)?

1657

How connect db2 database to datastage?

1245

How can you do the explain of a dynamic sql statement?

1069

Is db2 a mainframe?

1045

Can there be more than one cursor open for any program?

1169

Why do we use cursor?

1105

What is dclgen (declaration generator)?

1060

What is a storage group (stogroup)?

1247

How to get the ddl of a table in db2?

1131

Is db2 a mainframe database?

1003

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

1077

What is consistency token in db2?

1145

what is the sqlcode -501

13162

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1105

Explain about dbrm.

1049