Postinstallation tuning

The amount of storage that is needed for buffer pool sizes and the number of Virtual Storage Access Method (VSAM) extents (z/OS® only) depends on both the application load and the available real memory in a specific system. Ensure that the project plan includes a load testing activity. Your database administrator can monitor the buffer pools and ensure that the application is getting the best number of hits and the most space possible.

Run RUNSTATS when significant change to data volumes or data content occurs. Even if the number of rows in a table remains consistent, changes in data contents can result in different, and hopefully better, access paths by using statistics updated by RUNSTATS.

The REORG command improves database access by reorganizing your data on the disk. Similar to RUNSTATS, you need to always run REORG when significant changes to data occur.

The FTM installation provides some sample files that can be used to help maintain your database.