Modify the database layout

Edit online

The purpose of these test runs was to show the impact of the modification of the database layout on DB2® on z/OS® to better match the layout used on DB2 on Linux®.

For details see Database layout.

wasb07e — Figure 1. ETR, ITR, and CPU utilization for the modify the database layout test case

Observations

The throughput increases by 12%, which is a significant improvement. The ITR is nearly the same showing very little additional cost.

Conclusion

The new database layout shows a significant improvement at nearly the same cost. This confirms that the implementation of the application contributes significantly to the overall performance.