You can use the pdgetcst command to automatically collect optimizing information and simultaneously register it in a dictionary table. For details about the specific procedure, see 19.2 Using optimizing information. The following figure shows the collection of optimizing information from a database.

Figure 19-1 Collecting optimizing information from a database

Create a parameter file that contains optimized information that describes optimizing information, and use the pdgetcst command to register the file in a dictionary table. For details about the specific procedure, see 19.3 Using a parameter file that contains optimized information. The following figure shows the process of registering optimizing information using a parameter file that contains optimized information.

Figure 19-2 Registration of optimizing information using a parameter file that contains optimized information