We have a DB2 V9 installed. We have a table with 14 GB data which is 10 yrs worth of data. The potential for growth is at the rate of 1-2 GB per year.

We are upgrading the application and a DBA has suggested to use partition table space instead of Simple table space. They are also suggesting 16 partitions of 64 GB each.

Here are our questions on this :
1. Does partitioning enhance access performance.
2....