I'm trying to load data into a DB2 table. The tablespace has 3 partitions with about 60M,60M,70M rows. The 3rd partition is failing to load. It gives me a warning that loading this partition's dataset will exceed the maximum size of # pages.
The DSSIZE is currently set to 4G for this table space. To increase to 8G, I would need to change the storage groups to SMS.
The data is currently partitioned by a numeric range.
- P1 00-33
- P2 33-66
- P3 66-100
Would adding another partition and reorginize the data be a better solution?
- P1 00-25
- P2 25-50
- P3 50-75
- P4 75-100
Are there any other suggestions that would help load this data?