Tuning databases

You can tune your database in a variety of ways by using the reorganization utilities.

Keep in mind that when you tune your database, you are often making more than a simple change to it. For example, you might need to reorganize your database and at the same time change operating system access methods. This topic has procedures to guide you through making each type of change. If you are making more than one change at a time, you should look at the flowcharts in Changing the number of data set groups. When used in conjunction with the individual procedures in this topic, the flowcharts guide you in making some types of multiple changes to the database.

Also, some of the tuning changes you make can affect the logic in application programs. You can often use the dictionary to analyze the affect before making changes. In addition, some changes require that you code new DBDs and PSBs. If you initialize your changes in the dictionary, you can then use the dictionary to help create new DBDs and PSBs.