Pool tuning, sizing, and object placement is not a guessing game. It takes a large effort to get everything done properly, and once done, it must be monitored frequently and adjustments made. New applications come into the system, SQL is re-coded and access paths change, databases grow, etc. Monitoring should be done at least on a monthly basis, and bi-weekly is better on highly active systems.

Pool tuning, sizing, and effective object placement provides significant performance improvements...for the applications, for the DB2 system, for the DASD subsystem, and for the entire MVS complex.

If DB2 was really easy, and static, you would not be sitting here today because the corporations wouldn’t need any of us.