DB2 10.5 Range Partitioned Tables Available in WSE

Figured I’d start off the new year with this tip. Unbeknowst to many, IBM included range partitioned tables in the WSE edition in 10.5. Additionally, you get up to 128GB per instance, up from 64GB. Range partitioned tables offer improved performance via partition elimination and availability improvements via reorg of partitioned indexes only. No need to reorg all indexes or none as is the case with non-partitioned tables. Stay tuned!