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

Can we insert update delete in view?

579

What is drop table?

584

what is the sqlcode -501

11312

List out the data types available.

704

Is it possible to create an Instance in DB2 using DB2 Control Center ?

631

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

605

Comment whether the cursor is closed during commit or not.

676

What is cursor stability in db2?

813

What is commit in db2?

596

What is coalesce in db2?

682

What is the physical storage length of time data type?

676

What is the purpose of rollback and commit?

596

What is package in db2 mainframe?

559

Define data page.

634

What is nvl in db2?

630