If expected retrieval performance cannot be achieved, we recommend that you execute the database condition analysis utility to check the data storage condition. Based on this information, determine whether the data storage condition needs to be improved.

To improve the system performance, system tuning might be necessary based on the statistical information that is obtained by executing the following commands:

• Statistics analysis utility (pdstedit command)
• pdbufls command

For details about system tuning, see 22. Obtaining Tuning Information and 23. Tuning.