2

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?

1 Answer 1

0

As long as there is no application code that uses the partitioning scheme in their logic, adding a partition is a solution to your space issue.

I would suggest that you use 5 partitions instead of 4. Your data should then spread out more evenly.

P1 00-20                                                                    
P2 21-40                                                                    
P3 41-60                                                                    
P4 61-80                                                                    
P5 81-100    

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.