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

Why db2 is called db2?

975

What is runstats and reorg in db2?

1244

Mention the downsides of page level lock.

1116

What is the maximum length of sqlca?

1440

What is node in db2?

990

What do you mean by between and in? Is between inclusive of specified range values?

1044

Describe major components of db2?

1046

What is the physical storage length of the data types date, time, and timestamp?

1042

What is multi row fetch in db2?

988

What is the use of runstats in db2?

1025

what is db2 restart?

2104

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1118

What is ibm db2 client?

886

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2871

Differentiate between cs and rr isolation levels? Where do you specify them?

1025