I am trying to tune our ITIM for performance. Going through the document, there is a mention of the row-level compression using DB2 Storage Optimization feature, as a means to improve performance by reducing I/O. During normal operation, we normally have quite a bit of spare CPU on our DB2 server, so we can take more in CPU usage as a trade-off.
If any of you have enabled row-level compression, I would like a feedback from anyone with respect to performance in conjunction with ITIM (space is not a problem ATM for us).
Any other ideas WRT to DB2 performance tuning, not noted in the guide, are also welcome.